Web Development

Ask something
Discussion Locked

Oracle 9.x BLOB Question

0 helpful
3 replies

by cmptrwhz 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by amanabala

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

This discussion is closed to new replies.