This week's book giveaway is in the Jython/Python forum.
We're giving away four copies of Murach's Python Programming and have Michael Urban and Joel Murach on-line!
See this thread for details.
Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

pasing a workbook as parameter tp stored procedure  RSS feed

 
Shamu Somasundaram
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 36417
454
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!