File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "" Watch "" New topic

sri pathy

Joined: May 19, 2006
Posts: 1
I get the error 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();

pls help..
Ernest Friedman-Hill
author and iconoclast

Joined: Jul 08, 2003
Posts: 24195


Welcome to JavaRanch!

I'm going to move this to our JDBC forum, where it will be more on-topic.

[Jess in Action][AskingGoodQuestions]
I agree. Here's the link:
It's not a secret anymore!