Devart Forums

Hi, I am using the following code to insert a byte[] to a blob field.
But I get a message like "ORA-00600: internal error code, arguments: [12259], [], [], [], [], [], [], []" while executing the command.

The code is as follows

CoreLab.Oracle.OracleCommand SQLCommand = new CoreLab.Oracle.OracleCommand();

SQLCommand .Connection = DBConnection;

SQLCommand .Parameters.Add("Dos", OracleDbType.Blob);
SQLCommand .Parameters["Dos"].Value = Value;

SQLCommand .CommandText = "INSERT INTO TableName (Dos) VALUES (:Dos)";

SQLCommand .ExecuteNonQuery();

Please refer to "Working with BLOB and CLOB Data" article of OraDirect .NET help documentation.

We looked at "Working with BLOB and CLOB Data" help and tried the same example present there with Lob, but received a similar error while writing to Lob.

Don't you use Direct=true mode?

Yes, we are using Direct=true and Connection Lifetime=0

What type of the field do you have? What is database charset?
Please send us small test project if possible to reproduce the problem; include definition of your own database objects. Do not use third party components.

We omitted Direct=true in connection string and now it is working. I think with this step, we made Direct=false (if it is default). Could we encounter a problem in the future with this? (If there is going to be a problem, I can send you a small test project?)

You can encounter this problem in Direct mode if you try to insert BLOB value to the LONG field, or it may be a problem of OraDirect .NET with particular Oracle server. Please specify the version of Oracle server, database charset. Possibly this depends on inserting data. If it is a problem of OraDirect .NET we will fix this.

We are using Oracle 10g Express edition with Turkish charset.

Send us a small test project.

We sent it to [email protected].