My Oracle Support Banner

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 9.2.0.8 to 18.3.0.0.0 [Release 9.2 to 18]
Information in this document applies to any platform.

Symptoms

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.





Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.