My Oracle Support Banner

Invalid Table Name Exception While Using ATP Adapter On OIC3 (Doc ID 2984185.1)

Last updated on OCTOBER 31, 2023

Applies to:

Oracle Integration 3 - Version 23.08 and later
Information in this document applies to any platform.

Symptoms

Try to execute operation (Select or Insert) on a table with the table name starts with number (like 1TABLE1) or non-alphabetic through ATP adapter on integration Gen3, such error exception was triggered: Caused by java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name.

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.