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

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