store a large size BLOB file in ORACLE

Posted by Rcroyal88 under C# on 8/9/2011 | Points: 10 | Views : 2218 | Status : [Member] | Replies : 2
Hi,
I have made connection by usin ODP.net and i want to store a large BLOB file into a table in oracle
can anyone help me out in this ........................




Responses

Posted by: Hmanjarawala on: 8/10/2011 [Member] Bronze | Points: 25

Up
0
Down
Hi,

This data must be binary formated data, or some files.....

ok read that files using binary stream....and retrive data in Byte Array Like:

FileStream fs = new FileStream(path-of-file);
byte[] sbyte = new byte[fs.Length];
fs.Read(sbyte,0,fs.Length);

this way you can read byte array from files, now pass this byte aaray to as parameter to OracleParameter.

Hope this will helps you

Himanshu Manjarawala
Sr. Software Engineer@AutomationAnywhere
http://fieredotnet.wordpress.com/

Rcroyal88, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rcroyal88 on: 8/10/2011 [Member] Starter | Points: 25

Up
0
Down
can you please provide the complete code.......
for this..

Rcroyal88, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response