File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Murach's Java Servlets and JSP this week in the Servlets 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to pass BLOB to a PL/SQL Stored Procedure
 
Similar Threads
Pass Hashtable to PL/SQL procedure
Not able to insert image more than 4K in Database
How to pass class object in call to pl/sql procedure ?
Servlets and PL\SQL
Passing PL/SQL Datatype in procedure from java