ORA-01461: can bind a LONG value only for insert into a LONG

[slaxman]

I am guessing that the above error is due to Guid->Raw mapping. Here is the parameter mapping code.

Code: Select all

               
if (paramValue.GetType() == typeof(Guid))
{
      Devart.Data.Oracle.OracleParameter orclParam = param as Devart.Data.Oracle.OracleParameter;
      if (orclParam != null)
           orclParam.OracleDbType = Devart.Data.Oracle.OracleDbType.Raw;
}

In debug I see that this mapping code is executed but the query fails later with ORA-01461 error for some reason.

also, I tried setting the DbType to 'Binary'. That resulted in this error
{"ora-00932: inconsistent datatypes: expected - got blob"}

any ideas?


thanks

[StanislavK]

Could you please specify how the param object is defined and what query you are trying to execute? If possible, please send us a small test project including the scripts needed to create the database objects.

I've tried the following code and the Guid parameter was inserted successfully:

Code: Select all

OracleParameter orclParam = new OracleParameter("rawParam", OracleDbType.Raw, 16);
orclParam.Value = Guid.NewGuid();

OracleCommand command = new OracleCommand
    ("insert into TestRawTable(rawColumn) values (:rawParam)", connection);
command.Parameters.Add(orclParam);
command.ExecuteNonQuery();

The TestRawTable table is defined as

Code: Select all

CREATE TABLE TestRawTable 
(
  rawColumn RAW(16),
  CONSTRAINT PK_TestRawTable PRIMARY KEY (rawColumn)
)

[slaxman]

It was not the Guid field that was causing it but another field of type nvarchar2. with 'Unicode'set to true in the connection, the error went away.

[StanislavK]

Glad to see that the problem was resolved.