Help: encountered error compiling package DBMS_RCVCAT

From: bmlam <bmlam_at_online.de>
Date: Thu, 06 Jan 2000 21:37:53 +0100
Message-ID: <3874FD21.5EC8031F@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 - 14:37:53 CST