Insert Fails With ORA-01722 When Run From SQL Developer
(Doc ID 2449388.1)
Last updated on OCTOBER 07, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199.0 [Release 9.2 to 18]
Information in this document applies to any platform.
The following Insert statement, which includes bind values, fails with ORA-1722 only when run from SQL Developer, but runs fine from sqlplus.
The data type of all columns is varchar2 in the following tables and there are no data issues.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document