SQL Language (MOSC)

MOSC Banner

ORA-904 from query over database link

edited Nov 9, 2011 12:53AM in SQL Language (MOSC) 6 comments
Hi All

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center