Insert Fails With ORA-01722 When Run From SQL Developer
(Doc ID 2449388.1)
Last updated on APRIL 12, 2022
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124.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