PLSQL using DB-LINK fails on ORA-04052

When I attempt to SELECT from a table in another database via a database link, my PLSQL program fails with:

ORA-04052: error occurred when looking up remote object TEST.PROV_T_at_TEST.WORLD
ORA-040209: error ORA-2088 occurred when querying ORA_KGLR7_IDL_SB4_at_TEST.WORLD
...

The source statement is a cursor:

     Select prov_cd from prov_t_at_test;

I am able to run the above SELECT statement using SQLPLUS, but it fails when it is part of a PLSQL program.

My environment is:

AIX 3.25 Oracle dbms: 7.0.15.4.0 PLSQL: 2.0.17.1.0

I have rerun the PLSQL scripts which prepare the environment for PLSQL e.g. catproc.sql, catrpc.sql more than once... and still NOTHING!

Any ideas would be appreciated( email or post)

\louis feges Received on Fri Apr 21 1995 - 00:00:00 CEST