| 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
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
>
> -------- -------------------------------------------------------------
Thanks,
Jack Silvey
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack Silvey INET: oracle-l_at_warehousedba.com 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: NDATFM_at_labor.state.ny.us 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 Fri Dec 27 2002 - 09:24:14 CST
 |
 |