Storing binary file to Oracle Blob field in C#

Question

We have our own DataAccess library built upon the Microsoft Enterprise Data Access block.

I have stored procedure that takes binary file content as input parameter and store it into DB.

byte[] imageFileByteArray = this.GetByteArrayFromFile(imageFile);
this.dataAccess.AddCmdParameter("DOCIMAGE", System.Data.DbType.Binary, imageFileByteArray);

This code is working fine when using SQL database, But when I switched to Oracle, I get the exception saying that "Wrong type of parameter"

In oracle db, the DOCIMAGE column is declared as BLOB field.

Why inferred Dbtype.Binary is not working for oracle?

Justin Harvey · Accepted Answer · 2012-10-25 11:45:15Z

1

You will need to use an OracleParameter, with the OracleType enum value Blob, see here for more...

http://msdn.microsoft.com/en-us/library/system.data.oracleclient.oracletype.aspx

answered Oct 25, 2012 at 11:45

Justin Harvey

14.7k2 gold badges30 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

vijay Over a year ago

As i have mentioned, we are using our own DAL dll which doesn't accept explicit OracleType other than DbType.

Adrian Ciura · Accepted Answer · 2012-10-25 11:50:16Z

0

This is probably to do with different Oracle inference of OracleDbType from System.Data.DbType. The System.Data.DbType.Binary has coresponding OracleDbType=Raw. You would have to use System.Data.DbType.Object to get OracleDbType=Blob, for more details see Table 3-3 in http://docs.oracle.com/html/B14164_01/featOraCommand.htm

answered Oct 25, 2012 at 11:50

Adrian Ciura

1,1121 gold badge9 silver badges14 bronze badges

1 Comment

vijay Over a year ago

I tried, and I get this following error."Cannot bind type System.Byte[] as Blob." But in this post says, he got it working after changing it from DbType.Object to DbType.Binary. Either way it is not working for me. Any suggestions?

Collectives™ on Stack Overflow

Storing binary file to Oracle Blob field in C#

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related