General discussion

Locked

Oracle 9.x BLOB Question

By cmptrwhz ·
Hi All,

I have an 300k xls (Excel) file that I need to store in an Oracle DB without taking a file system hit.. I have read that by using BLOB, it only places a "holder" item in the Table and points to the file system for the actual binary file..
How can I store the entire binary item in the Oracle Database Table??

Thanks in advance.

Mike

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by amanabala In reply to Oracle 9.x BLOB Question

You could read the entire file as a binary stream (byte array) and update the blob field with that byte array (assuming you are using a program to load the blob data)

Hope this helps
-Ravi

Collapse -

by cmptrwhz In reply to

Poster rated this answer.

Collapse -

by cmptrwhz In reply to Oracle 9.x BLOB Question

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums