C#, Oracle - How to store TEXT as BLOB

Question

I am coding in C# and I have following problem with Oracle DB. I would like to store some TEXT in BLOB column but I do not know how. Do you have any idea how to change my code?

String textValue = "Some example of text..."

oraCommand.CommandText = "UPDATE BLOB_TABLE SET BLOB_COLUMN = :data WHERE ID='123'";
                oraCommand.Parameters.Add(":data", OracleDbType.Blob);
                oraCommand.Parameters[":data"].Value = textValue;
                oraCommand.ExecuteNonQuery();
            }

a BLOB or a CLOB? a BLOB is a binary data type and will expect a byte[] as the value. you need to convert your string to a byte arary. — Fran
– Fran, Commented May 9, 2017 at 14:09

hkutluay · Accepted Answer · 2017-05-09 14:13:48Z

3

You must remove ":" while binding parameters. And BLOB is binary object, you should convert string to byte array. You should use CLOB for character large objects.

String textValue = "Some example of text..."

oraCommand.CommandText = "UPDATE BLOB_TABLE SET BLOB_COLUMN = :data WHERE ID='123'";
OracleParameter param  =  oraCommand.Parameters.Add("data", OracleDbType.Blob);
param.Value = Encoding.ASCII.GetBytes(textValue);
oraCommand.ExecuteNonQuery();

answered May 9, 2017 at 14:13

hkutluay

6,9742 gold badges37 silver badges57 bronze badges

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

Collectives™ on Stack Overflow

C#, Oracle - How to store TEXT as BLOB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related