Does the compiling ID have a direct grant on the package P_MESSAGES ????
If you have access to it via a grant on a role and not a direct grant, then
you will get error messages like this. Check your authorities and see if
you have a direct grant.
-----Original Message-----
Sent: Thursday, December 26, 2002 2:59 PM
To: Multiple recipients of list ORACLE-L
List,
Can anybody tell me what is happening here. I am constantly getting the
PLS-00201 error when I try to compile. It is looking inside the package at
a procedure and saying the identifier must be declared. I have gone over
metalink docs and notes. I first compile the package spec and then the
package body. I get the following response:
SQL> alter package schema.p_messages compile package;
Warning: Package altered with compilation errors.
SQL> show errors
Errors for PACKAGE schema.P_MESSAGES:
LINE/COL ERROR
-------- -----------------------------------------------------------------
193/5 PL/SQL: Declaration ignored
197/38 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared
218/5 PL/SQL: Declaration ignored
219/34 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared
SQL> alter package schema.p_messages compile body;
Warning: Package Body altered with compilation errors.
SQL> show errors
Errors for PACKAGE BODY schema.P_MESSAGES:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/14 PLS-00905: object schema.P_MESSAGES is invalid
1/14 PLS-00304: cannot compile body of 'P_MESSAGES' without its
specification
thanks,
David Ehresmann
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ehresmann, David
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
