ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODP .NET Managed Data Access 12.1.0.2.0 Exceptions ORA-01483 and ORA-01461

user10616170Feb 13 2015 — edited Feb 26 2015

I am encountering exceptions when using ODP .NET Managed Data Access 12.1.0.2.0 and NLS_CHARACATERSET=AL32UTF8. If I do an update on a VARCHAR2(2000 Byte) column with 1004 bytes and a FLOAT (126), I will receive this exception "Oracle.ManagedDataAccess.Client.OracleException (0x000005CB): ORA-01483: invalid length for DATE or NUMBER bind variable". If I do an insert on a VARCHAR2(2000 Byte) column with 1004 bytes I will encounter "Oracle.ManagedDataAccess.Client.OracleException (0x000005B5): ORA-01461: can bind a LONG value only for insert into a LONG column".

Does anyone have a solution using the ODP .NET Managed Data Access 12.1.0.2.0? If there is no solution does Oracle have plans to address?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 26 2015

Added on Feb 13 2015

#odp-net

5 comments

2,911 views