Insert Fails With ORA-01722 When Run From SQL Developer (Doc ID 2449388.1)

Last updated on AUGUST 22, 2023

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.

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

Symptoms

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