| 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: 26168
|
|
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
|
|
|
0
