RE: compile errors
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/5PL/SQL: Declaration ignored > > 197/38 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared > > 218/5PL/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 (o
RE: compile errors
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/5PL/SQL: Declaration ignored > > 197/38 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared > > 218/5PL/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).
Re: compile errors
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/5PL/SQL: Declaration ignored > > 197/38 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared > > 218/5PL/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).
RE: compile errors
I think you do. I would suggest that you go ahead and try it with the grant. Should be very easy to test out that way. -Original Message- Sent: Thursday, December 26, 2002 4:40 PM To: Multiple recipients of list ORACLE-L 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/5PL/SQL: Declaration ignored 197/38 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared 218/5PL/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). -- 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).
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/5PL/SQL: Declaration ignored 197/38 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared 218/5PL/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). -- 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).
RE: compile errors
Title: RE: compile errors You probably do not have enough privileges to access HSD_TYPES (a package maybe?) If it is a package, you need a synonym and exec privilege. If it is a table, you still need a synonym and a direct grant to select from it. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 3:59 PM To: Multiple recipients of list ORACLE-L Subject: compile errors 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). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: compile errors
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/5PL/SQL: Declaration ignored 197/38 PLS-00201: identifier 'HSD_TYPES.T_RETURN_CODE' must be declared 218/5PL/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).