Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Package Creation Failing with PLS 201 Error .. Basic Qs

Re: Package Creation Failing with PLS 201 Error .. Basic Qs

From: Neil Overend <neiloverend_at_gmail.com>
Date: Tue, 15 May 2007 13:17:03 +0100
Message-ID: <5acbeade0705150517j33d1db61o2a572a7c4877a268@mail.gmail.com>


who are you logged in as when you do
SQL> @pack_generic_update.sq

and have you done GRANT EXECUTE on SYS.DBMS_LOCK to <user>

(as SYS)

On 15/05/07, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:
>
> Folks
>
>
>
> Attempting to Create an Application specific Package / Package Body giving
> the following Error :-
>
>
>
> SQL> @pack_generic_update.sql
>
>
>
> Creating PACKAGE GENERIC_UPDATE
>
>
>
> Package created.
>
>
>
> *Warning: Package Body created with compilation errors.*
>
>
>
> SQL> show error
>
>
>
> LINE/COL ERROR
>
> -------- -----------------------------------------------------------------
>
> 674/3 PL/SQL: Statement ignored
>
> 674/3 PLS-00201: identifier *'SYS.DBMS_LOCK'* must be declared
>
> 1029/3 PL/SQL: Statement ignored
>
> 1029/3 PLS-00201: identifier 'SYS.DBMS_LOCK' must be declared
>
> SQL> 674
>
> 674* loop
>
> SQL> 1029
>
> 1029* LOOP
>
> SQL> !oerr pls 201
>
> 201,0, "execute"
>
>
>
> NOTE following 2 SQLs have already been from ORACLE_HOME/rdbms/admin Dir
> run as sysdba in the same Order:-
>
> dbmslock.sql, prvtlock.plb , but the Error continues to occur.
>
>
>
> Will share the package source as needed
>
>
>
> Thanks indeed
>
>
>
>
>
>
>
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> solely for the use of the addressee(s). If you are not the intended
> recipient, please notify the sender by e-mail and delete the original
> message. Further, you are not to copy, disclose, or distribute this e-mail
> or its contents to any other person and any such actions are unlawful. This
> e-mail may contain viruses. Infosys has taken every reasonable precaution to
> minimize this risk, but is not liable for any damage you may sustain as a
> result of any virus in this e-mail. You should carry out your own virus
> checks before opening the e-mail or attachment. Infosys reserves the right
> to monitor and review the content of all messages sent to or from this
> e-mail address. Messages sent to or from this e-mail address may be stored
> on the Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 15 2007 - 07:17:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US