ORA-22275: invalid LOB locator specified

[AlexPA]

Hi,

I am getting (ORA-22275: invalid LOB locator specified) error when execute the follwing code:

/*
CREATE TABLE CLOB_TEST_TABLE (
ID NUMBER(12),
BINARY_DATA BLOB
)
*/
string connectionString = "DATA SOURCE=MYDB;PERSIST SECURITY INFO=True;USER ID=USR;PASSWORD=PWD";
using (OracleConnection connection = new OracleConnection(connectionString))
{
connection.Open();
OracleLob lob = new OracleLob(connection, OracleDbType.Blob);
byte[] buffer = { 1, 3, 4 };
lob.Write(buffer, 0, buffer.Length);
OracleCommand command = new OracleCommand(
"INSERT INTO CLOB_TEST_TABLE (ID, BINARY_DATA) VALUES(1, :B_DATA)", connection);
OracleParameter param = command.Parameters.Add("B_DATA", OracleDbType.Blob);
param.OracleValue = lob;
Console.WriteLine(command.ExecuteNonQuery() + " rows affected.");
}

Console.ReadKey();

Oracle version is 10.

Please help

[Shalex]

I cannot reproduce the problem with the latest (6.30.185) version of dotConnect for Oracle. Please try 6.30.185 and notify us about the results.

A similar issue was discussed at http://www.devart.com/forums/viewtopic.php?t=20100.