Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Package Creation Failing with PLS 201 Error .. Basic Qs .....SOLVED
EXECUTE on SYS.DBMS_LOCK to PUBLIC worked
Thanks so much Neil
Cheers
From: Neil Overend [mailto:neiloverend_at_gmail.com]
Sent: Tuesday, May 15, 2007 5:47 PM
To: VIVEK_SHARMA
Cc: oracle-l_at_freelists.org
Subject: 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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 15 2007 - 07:24:47 CDT
![]() |
![]() |