This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes pasing a workbook as parameter tp stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "pasing a workbook as parameter tp stored procedure" Watch "pasing a workbook as parameter tp stored procedure" New topic
Author

pasing a workbook as parameter tp stored procedure

Shamu Somasundaram
Ranch Hand

Joined: Aug 25, 2004
Posts: 41
Hi,
I need to pass a workbook as a parameter to storeed procedure which in turn will store the file as BLOB in oracle. Please help me in this regard.
Thanks in advance.
Shanmugavel
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30361
    
150

Shanmugavel,
You need to create the BLOB or byte[] or BinaryStream in Java and pass that as a parameter.

I assume this is an Excel workbook? You can use Apache's POI/HSSF to write the workbook to a BinaryStream.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
 
subject: pasing a workbook as parameter tp stored procedure