Re: URGENT ...PL/SQL Help

Often I find that the ORA-00904 error
has to do with a lack of rights to the object.

In article <7m30rf$m0b$1_at_nnrp1.deja.com>,   sanjayraj6844_at_my-deja.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 16 1999 - 14:44:57 CDT