469,613 Members | 1,161 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,613 developers. It's quick & easy.

How to fix? ORA-22990: LOB locators cannot span transactions

Why am I getting this exception, and how can I fix it? I took out all
the commit's and "select ... for update" statements that I had been
calling using JDBC, but I'm still getting this exception. I even tried
to setAutoCommit(false) but that didn't help. :(

java.io.IOException: ORA-22990: LOB locators cannot span transactions
at oracle.jdbc.driver.DatabaseError.SQLToIOException( DatabaseError.java)
at
oracle.jdbc.driver.OracleBlobOutputStream.flushBuf fer(OracleBlobOutputStream.jav
a)
at oracle.jdbc.driver.OracleBlobOutputStream.write(Or acleBlobOutputStream.java)
at java.io.OutputStream.write(OutputStream.java)

Please help.

Thanks,

Corrine
Jul 19 '05 #1
0 8312

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by bdj | last post: by
reply views Thread by basmgokul | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.