ORA-01483: invalid length for DATE or NUMBER bind variable
Posted: Wed 24 Apr 2019 05:09
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.
*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.