July 21, 2006, 12:25 PM
texascycloneError while creating synonym
I am getting the error below when I am in step 2 of creating synonym. Anybody came across this having a solution?
------------------------------------------------
(FOC1400) SQLCODE IS 904 (HEX: 00000388)
(FOC1410) SQL COLUMN NOT FOUND. (FOR TABLE: CHECK ALIAS NAMES)
: ORA-00904: invalid column name
: Erroneous token: CHAR_LENGTH
(FOC1405) SQL PREPARE ERROR.
-----------------------------------------------
Thanks in advance.
July 24, 2006, 10:14 AM
codermonkeyThere's a case on tech support:
"Customer is getting a SQLCODE is 904 error message. This is a known
issues when connecting from Oracle 817 DBMS to Oracle 9.2 Client.
Solution:
Create synonym using SET SYNONYM=BASIC in the edasprof.prf."
Not sure if this is your issue, but thought I'd mention it.
July 24, 2006, 11:12 AM
texascycloneThanks,
Yes, that was an issue. I got it resolved already using the same solution.
April 25, 2007, 11:25 AM
tearttdrquote:
Create synonym using SET SYNONYM=BASIC in the edasprof.prf
does anyone where this is put in the edasprof? Thanks!