| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: compile errors
Yes, I read that off of metalink. I granted "execute any procedure" to the
user. And still got the same error. Do I still need a direct grant off of
that package?
thanks.
-----Original Message-----
Sent: Thursday, December 26, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L
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: David.Ehresmann_at_ps.net
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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: Ehresmann, David
INET: David.Ehresmann_at_ps.net
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: ListGuru_at_fatcity.com (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). Received on Thu Dec 26 2002 - 16:39:36 CST
 |
 |