Re: package

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 14 Oct 1998 16:10:46 GMT
Message-ID: <3626ccf8.186639613@192.86.155.100>

A copy of this was sent to lien_at_cs.umb.edu (j.k.) (if that email address didn't require changing) On 14 Oct 1998 15:33:25 GMT, you wrote:

>I have package name pUSERd and I have to drop it off.
>but whenever I do 'drop package pUSERd' or 'drop package PUSERD'
>I get an error message as below:
>
>ORA-04043: object PUSERD does not exist.
>
>How to drop off a package the name contains upper case and lower case.
>Any helps will be appreciated. thanks....

SQL> drop package "pUSERd";  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Oct 14 1998 - 11:10:46 CDT