ORA-01461: can bind a LONG value only for insert into a LONG
Posted: Mon 12 Jul 2010 21:55
I am guessing that the above error is due to Guid->Raw mapping. Here is the parameter mapping code.
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
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;
}
also, I tried setting the DbType to 'Binary'. That resulted in this error
{"ora-00932: inconsistent datatypes: expected - got blob"}
any ideas?
thanks