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(f alse) but that didn't help. :(
java.io.IOExcep tion: ORA-22990: LOB locators cannot span transactions
at oracle.jdbc.dri ver.DatabaseErr or.SQLToIOExcep tion(DatabaseEr ror.java)
at
oracle.jdbc.dri ver.OracleBlobO utputStream.flu shBuffer(Oracle BlobOutputStrea m.jav
a)
at oracle.jdbc.dri ver.OracleBlobO utputStream.wri te(OracleBlobOu tputStream.java )
at java.io.OutputS tream.write(Out putStream.java)
Please help.
Thanks,
Corrine
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(f alse) but that didn't help. :(
java.io.IOExcep tion: ORA-22990: LOB locators cannot span transactions
at oracle.jdbc.dri ver.DatabaseErr or.SQLToIOExcep tion(DatabaseEr ror.java)
at
oracle.jdbc.dri ver.OracleBlobO utputStream.flu shBuffer(Oracle BlobOutputStrea m.jav
a)
at oracle.jdbc.dri ver.OracleBlobO utputStream.wri te(OracleBlobOu tputStream.java )
at java.io.OutputS tream.write(Out putStream.java)
Please help.
Thanks,
Corrine