RE: compile errors

From: Ehresmann, David <David.Ehresmann_at_ps.net>
Date: Fri, 27 Dec 2002 06:48:51 -0800
Message-ID: <F001.005230E5.20021227064851@fatcity.com>

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

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

Received on Fri Dec 27 2002 - 08:48:51 CST