Linked tables - Oracle

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...
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 <--
 
Back
Top