From: JavaDeveloper@volcanomail.com (Corrine)
Newsgroups: comp.databases.oracle
Subject: How to fix? ORA-22990: LOB locators cannot span transactions
Date: 10 Oct 2003 11:33:19 -0700
Organization: http://groups.google.com
Lines: 18
Message-ID: <54774824.0310101033.7f7a1de7@posting.google.com>
NNTP-Posting-Host: 148.87.1.171
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1065810800 31051 127.0.0.1 (10 Oct 2003 18:33:20 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 10 Oct 2003 18:33:20 +0000 (UTC)


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.flushBuffer(OracleBlobOutputStream.jav
a)
	at oracle.jdbc.driver.OracleBlobOutputStream.write(OracleBlobOutputStream.java)
	at java.io.OutputStream.write(OutputStream.java)

Please help.

Thanks,

Corrine