David, If the package is not too large, could you please show it (or the portions of the package that are involved in the error) to us on the list so we can see exactly what is going on?
We need to see where and how the object is being referenced. thanks Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Friday, December 27, 2002 9:49 AM To: Multiple recipients of list ORACLE-L You are right. I disabled the roles thru which the grants were made. But my schema owns the objects. I have a userprivs script that shows my schema owners privs. The schema owner does not have any privs on the objects it owns! How can that be? And I tried granting to myself(the schema owner), as you know you can't do that. What is the work around? thanks David Ehresmann. -----Original Message----- Sent: Thursday, December 26, 2002 7:19 PM To: Multiple recipients of list ORACLE-L Does the owner of the package have *direct* privs (not through a role) on the object in question? > 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). > > > Thanks, Jack Silvey -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack Silvey 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: 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: Mercadante, Thomas F 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).