my dog learned polymorphism*
The moose likes JDBC and the fly likes How to pass BLOB to a PL/SQL Stored Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to pass BLOB to a PL/SQL Stored Procedure" Watch "How to pass BLOB to a PL/SQL Stored Procedure" New topic
Author

How to pass BLOB to a PL/SQL Stored Procedure

Mike Boota
Ranch Hand

Joined: Jul 18, 2002
Posts: 82
Hi,

Can someone please provide a small sample on how to call a PL/SQL stored Procedure and pass in a parameter of type BLOB.
I need to call a PL/SQL Stored Procedure and pass BLOB as a parameter. I have table that stores different types of files and the datatype of the column is BLOB so
from my java program I need to read some file and call the PL/SQL Stored Procedure passing that file content as BLOB. Any help is really appreciated


Thanks


MB<br />Sun Certified Programmer for Java2 Platform
Mourouganandame Arunachalam
Ranch Hand

Joined: Oct 29, 2008
Posts: 396
Hi,

Look at this url... may be useful..

Oracle LOB

Mourougan


Mourougan
Open Source leads to Open Mind
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: How to pass BLOB to a PL/SQL Stored Procedure