Re: compile errors

From: Jack Silvey <oracle-l_at_warehousedba.com>
Date: Thu, 26 Dec 2002 17:18:54 -0800
Message-ID: <F001.00522BD0.20021226171854@fatcity.com>

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

Received on Thu Dec 26 2002 - 19:18:54 CST