Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Oracle Database + Options
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Mar 28, 2013 4:42 PM by
java.sql.SQLException: Invalid empty lob operation
Jan 20, 2002 4:11 PM
I have a java source based stored function in which I try
to build a BLOB. Essential this is what I do:
1: oracle.sql.BLOB result = oracle.sql.BLOB.empty_lob();
2: byte bytes = new byte[ length ];
3: bytes = do_something();
4: result.putBytes( 1 , bytes )
the java.sql.SQLException happens as a result of line 4.
I have a wage understanding of what this exception is trying
to say, but can someone tell me what I need to do????
Btw.: What is the best reference documentation for the
This content has been marked as final.
Show 1 reply
Re: java.sql.SQLException: Invalid empty lob operation
Mar 28, 2013 4:42 PM
in response to
I believe you will want to use oracle.sql.BLOB.createTemporary(java.sql.Connection conn, boolean cache, int _duration).
Refer to the API at: