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.

There'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.

Thanks,

Yes, that was an issue. I got it resolved already using the same solution.

quote:

Create synonym using SET SYNONYM=BASIC in the edasprof.prf

does anyone where this is put in the edasprof? Thanks!