Win a copy of Spring Boot in Practice this week in the Spring forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Liutauras Vilda
  • Henry Wong
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Al Hobbs
  • Carey Brown
Bartenders:
  • Piet Souris
  • Mikalai Zaikin
  • Himai Minh

unsupported LOB (calling Java from Oracle)

 
Ranch Hand
Posts: 82
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 ]
 
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
This any help ?
 
Andris Jekabsons
Ranch Hand
Posts: 82
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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!
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic