pasing a workbook as parameter tp stored procedure

[Shamu Somasundaram]

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]

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.