This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JDBC and the fly likes unsupported LOB (calling Java from Oracle) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "unsupported LOB (calling Java from Oracle)" Watch "unsupported LOB (calling Java from Oracle)" New topic
Author

unsupported LOB (calling Java from Oracle)

Andris Jekabsons
Ranch Hand

Joined: Jan 20, 2004
Posts: 82
I have a Java class that writes something to an Oracle BLOB. With a method like this (I fill the blob and return it to the caller):
To call this method, I get a connection to Oracle, call a stored procedure which returns an empty blob (which I then pass to the fillBlob() method):
The stored procedure just returns a temporary blob and contains one line:
This works fine. The problem starts when I put that class in Oracle as a Java source, and call the class from an Oracle procedure (a requirement): I am getting 'ORA-24813 cannot send or receive an unsupported LOB' error.
If my Java class returns something else (or just null), I don't get an error. So, I think the error is because I return the blob I have received as an argument.
What can I do to fix the error, or how else can I achieve my goal?

P.S. I've tried this on two different Oracle databases (10.2.0.1.0 and 10.2.0.3.0)
[ July 30, 2007: Message edited by: Andris Jekabsons ]
S J Martin
Greenhorn

Joined: Jul 31, 2007
Posts: 23
This any help ?


Never attribute to malice that which is easily explained by incompetence.<br />SCJP (1.5)
Andris Jekabsons
Ranch Hand

Joined: Jan 20, 2004
Posts: 82
Thanks for the response. It looks like I was using the correct methods, but the problem has disappeared now. Just as it "mysteriously" appeared when a previously functioning Java code was moved to Oracle (btw, a clob wasn't creating any problems, only a blob), it has "mysteriously" disappeared. I changed some code in the method, and now it works - even though I didn't change how I write data to the blob.
Go figure!
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: unsupported LOB (calling Java from Oracle)