Capture Database Lookup Error on Schema with Special Characters "Error: 3639 The following error occurred while searching the database. [[Oracle][ODBC][Ora]ORA-00903: invalid table name [Error in EDO-ExecSearch on line 68]]" (Doc ID 2059242.1)

Last updated on APRIL 03, 2017

Applies to:

Oracle WebCenter Capture 10g - Version 10.1.3.5.1 and later
Oracle WebCenter Distributed Capture - Version 10.1.3.5.1 and later
Information in this document applies to any platform.

Symptoms

After creating a new database lookup profile in Oracle Document Capture and issuing a search in Index, the following error is returned to the user:

Error: 3639
The following error occurred while searching the database. [[Oracle][ODBC][Ora]ORA-00903: invalid table name [Error in EDO-ExecSearch on line 68]]

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms