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).