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

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Corrine

    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(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
Working...