URGENT ...PL/SQL Help

From: <sanjayraj6844_at_my-deja.com>
Date: Thu, 08 Jul 1999 20:14:51 GMT
Message-ID: <7m30rf$m0b$1@nnrp1.deja.com>

Hi all,

I am trying a to run a PL/SQL script from Database A(on machine A) . This script fetches and processes data from 2/3 tables on Database B (on machine B- I use database link for this) and inserts the data into a table in Database A (machine A). I ran one of the scripts and it ran fine BUT when I tried to run another script (very similar to the first one). I got the following error

declare
*
ERROR at line 1:
ORA-04052: error occurred when looking up remote object USERB.TABLEB_at_SF3.WORLD
ORA-04029: error ORA-904 occurred when querying ORA_KGLR7_IDL_SB4_at_SF3.WORLD
ORA-00604: error occurred at recursive SQL level 1 ORA-00904: invalid column name

Database A and B are both on HP-UX Release B.10.20 and run
Oracle7 Server Release 7.3.4.0.0 - Production With the distributed, replication and parallel query options PL/SQL Release 2.3.4.0.0 - Production

I just ran the SELECT part of the cursor in SQLPLUS on database A and it ran.

Can Somebody Help.

Thanks in advance

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 08 1999 - 15:14:51 CDT