English

Error: ArcGIS Schematics Designer: [Oracle][ODBC][Ora]ORA-00911: invalid character

Error Message

Creating a new document type in ArcGIS Schematics Designer using an ArcSDE for Oracle data source and applying a query results in:

Error:   
ArcGIS Schematics Designer: [Oracle][ODBC][Ora]ORA-00911: invalid character

Cause

The ArcSDE data source was created using a username that does not have sufficient permissions.

Solution or Workaround

Create the ArcSDE data source using the SDE user and password.

Refer to the following technical article, How To: Establish an ArcSDE connection using ArcGIS Schematics Designer, for directions.