Linked tables - Oracle

[Guest]

Hello,

I have some Linked tables that are in Oracle and when executing this code I
get ORA-00972 - Identifier to long.

RsPort.CursorType = adOpenKeyset
RsPort.LockType = adLockOptimistic
RsPort.Open "TRAF_DATA1_TBL_PORTABLE_CLASS_TEMP", CN, , , adCmdTable

 

[Stefan Hoffmann]

hi,

I have some Linked tables that are in Oracle and when executing this code I
get ORA-00972 - Identifier to long.

RsPort.CursorType = adOpenKeyset
RsPort.LockType = adLockOptimistic
RsPort.Open "TRAF_DATA1_TBL_PORTABLE_CLASS_TEMP", CN, , , adCmdTable

Table names must not be longer than 30 characters. So you must have some
typo. Check if you have a schema pefix, e.g.

"TRAF_DATA1.TBL_PORTABL_CLASS_TEMP"



mfG
--> stefan <--