ORA-01483: invalid length for DATE or NUMBER bind variable

[brian_chang]

Hi :
*Environment: 2 DBs.
1. A DB : 11.2.0.3 , NLS_CHARACTERSET=UTF8
2. B DB: 12.1.0.2, NLS_CHARACTERSET=AL32UTF8

My project use “dotConnect for Oracle (6.10.111.0)” ,
When connect to A DB account, and try to insert B DB data through DB link view . I got following error msg.
----
ORA-01483: invalid length for DATE or NUMBER bind variable .
ORA-02063: preceding line from AGILE.
----

Do anyone know how to solve this problem without change B DB CHARACTERSET ?
Thanks.

[Shalex]

Most likely, the issue is not related to the provider functionality: http://orasql.org/2017/11/24/oracle-iss ... e-to-12-2/.

Please upgrade to the newest (9.7.734) build of dotConnect for Oracle and send us a test project with the corresponding DDL/DML script for reproducing.