ORA-44003 Invalid SQL Name ORA 06512 At SYS DBMS ASSERT While Using The Bulk Insert

News Knowledge Base
1

Bulk insert: ORA-44003: invalid SQL nameORA-06512: at "SYS.DBMS_ASSERT", line 215ORA-06512: at line 1.

ORA-44003: invalid SQL name exception is raised when the input string does not conform the SIMPLE_SQL_NAME function .

Resolution :

The SIMPLE_SQL_NAME function checks the input string conforms to the basic characteristics of a simple SQL name.

  • The first character of the name is alphabetic
  • The name only contains alphanumeric characters or the "_", "$", "#"
  • Quoted names must be enclosed by double quotes and may contain any characters, including quotes provided they are overloaded. Overloading quotes means having two quotes in a row ("" or '')
  • The function ignores leading and trailing white spaces
  • The length of the input string is not validated
  • The "ORA-44003: invalid SQL name" exception is raised when the input string does not conform.