http://www.dba.5341.com/
http://www.dba.5341.com/
EXECUTE on SYS.DBMS_LOCK to PUBLIC
worked
Thanks so much Neil
Cheers
From: Neil Overend
[mailto:neiloverend@gmail.com]
Sent: Tuesday, May 15, 2007 5:47
PM
To: VIVEK_SHARMA
Cc: oracle-l@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@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
***************** |