Re: Help: encountered error compiling package DBMS_RCVCAT

Supposedly there is an object called DFATT to which you have no access either because you don't have privilege and/or a synonym doesn't exist. The other errors are a consequence of the first.

Hth,

--
Sybrand Bakker, Oracle DBA
bmlam <bmlam_at_online.de> wrote in message news:3874FD21.5EC8031F_at_online.de...
> Hi,
>
> we got following errors while trying to create the package DBMS_RCVCAT
> using the Oracle supplied scripts.
> The package body comes as wrapped procedures so we can not look at the
> source code. I suspect that some
> object dependencies could not be resolved.
>
> We use Oracle 8.0.4 and ran the script as SYS user. Thanks in advance
> for any hints.
>
> SQL> @DBMSRVCT
>
> Package created.
>
>
> Grant succeeded.
>
> No errors.
> SQL> @PRVTRVCT.PLB
>
> Warning: Package Body created with compilation errors.
>
> Errors for PACKAGE BODY DBMS_RCVCAT:
>
> LINE/COL ERROR
> --------
> -----------------------------------------------------------------
> 39/12 PLS-00201: identifier 'DFATT.FNAME' must be declared
> 39/12 PL/SQL: Item ignored
> 75/8 PLS-00341: declaration of cursor 'TSQ' is incomplete or
> malformed
> 76/3 PL/SQL: SQL Statement ignored
> 77/8 PLS-00201: identifier 'TS' must be declared
> 89/8 PLS-00341: declaration of cursor 'DFQ' is incomplete or
> malformed
> 90/3 PL/SQL: SQL Statement ignored
> 92/8 PLS-00201: identifier 'DF' must be declared
> 104/8 PLS-00341: declaration of cursor 'RTQ' is incomplete or
> malformed
> 105/3 PL/SQL: SQL Statement ignored
> 107/8 PLS-00201: identifier 'RT' must be declared
> 114/3 PL/SQL: SQL Statement ignored
> 115/8 PLS-00201: identifier 'ORL' must be declared
> 123/3 PL/SQL: SQL Statement ignored
> 124/8 PLS-00201: identifier 'BP' must be declared
> 139/3 PL/SQL: SQL Statement ignored
> 140/8 PLS-00201: identifier 'SCRL' must be declared
> 162/8 PL/SQL: Item ignored
> 163/8 PL/SQL: Item ignored
> 164/17 PL/SQL: Item ignored
>
>
Received on Thu Jan 06 2000 - 15:10:46 CST