This week's book giveaway is in the Mac OS forum. We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line! See this thread for details.
I get the error java.io.ioException LOB locators cannot span transactions, when I try to insert a BLOB object into oracle DB. My SP reads procname(filename1 in char, filedata out Blob) insert into ...(filename1, empty_blob); select filecontent from ... where filename=filename1 for update.
my java code reads java.sql.BLOB b = (BLOB)getQueryOutParam("filedata").getBlob();