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

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Tue, 15 May 2007 08:34:53 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08DDC@EXCNYSM0A1AJ.nysemail.nyenet>

Vivek,

Have you looked at security? Has the user who is creating the package been given execute priv on the package?  

Tom  

---

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA Sent: Tuesday, May 15, 2007 8:10 AM
To: oracle-l_at_freelists.org
Subject: Package Creation Failing with PLS 201 Error .. Basic Qs  

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:34:53 CDT