Oracle Database Link Error

forum.connectivity (1998-2005) & forum.td.connectivity (2005-2010)
Corey Nermo

Oracle Database Link Error

Post by Corey Nermo » 27 Aug 2008, 21:15

 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:
ERROR: 0
Identifier too long
POSITION: 29

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
different error:

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
"SCHEMA.INSERT_A_LONG_ABLE_NAME_HERE@prod"
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?

Fridolin Schwarz

Oracle Database Link Error

Post by Fridolin Schwarz » 05 Sep 2008, 11:57

 Posted by:  Fridolin Schwarz 


Hi Corey,

I had the same, or maybe a similar, problem and the only solution I then
found was to create a shorter SYNONYM for that database object.

hrh
fridolin

Corey Nermo

Oracle Database Link Error

Post by Corey Nermo » 05 Sep 2008, 22:18

 Posted by:  Corey Nermo 

Hi Fridolin;

Txs for the reply. Looks like that is the work around for now. A bit
annoying as this has happened at a client site using
one of our in-house programs.

Will be testing on Gupta 5.1 /Oracle 10g and see if it is still a problem.

Return to “td.connectivity”

Who is online

Users browsing this forum: [Ccbot] and 0 guests