aspose file tools*
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 Spring in Action this week in the Spring 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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30762
    
156

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
 
jQuery in Action, 2nd edition
 
subject: pasing a workbook as parameter tp stored procedure