ORA-904 from query over database link
I'm trying to select a function across a db link but I'm gettting an error:
SQL> select mdwrpod.FNC_INTERMEDIARY_KEY@acrm.read (0084533) from dual;
select mdwrpod.FNC_INTERMEDIARY_KEY@acrm.read (0084533) from dual
*
ERROR at line 1:
ORA-00904: "MDWRPOD"."FNC_INTERMEDIARY_KEY": invalid identifier
I have read the docs on Metalink and tried the workaround but still have the same problem.
SQL> alter session set events '10176 trace name context forever';
Session altered.
SQL> alter system flush shared_pool;
System altered.
Is my syntax correct?
Thanks,
Charlton