Posted by: Corey Nermo
OS = Vista 64 bit , XP
SQL Talk version 9.0.1
SQL Windows 4.2.0 Build 13978
Oracle 9i database drivers
I am getting the following sql error:
Identifier too long
The select statement is using an Oracle Database link
SELECT count(*) FROM SCHEMA.INSERT_A_LONG_ABLE_NAME_HERE@prod
The code runs fine from Oracle sqlplus and Oracle SQL Scratchpad.
It fails with our own application when calling SalTblPopulate().
It also fails from SQL Talk version 9.0.1, although I am getting a slightly
00910 PRS ITL Identifier too long
Reason: An identifier exceeds 36 characters.
Remedy: Correct the identifier that exceeds 36 characters.
It appears as though the entire combination of schema+table+link
cannot exceed 37 characters.
I know Oracle Identifiers cannot exceed 30 characters, but it appears to be
excluding the schema and dblink name portions.
Has anyone had a similiar experience with Oracle or MSSQL?