drop package

From: j.k. <lien_at_cs.umb.edu>
Date: 24 Aug 1998 17:56:38 GMT
Message-ID: <6rs9gm$ee3$1@news.res.ray.com>

Hi,
Does anyone know how to drop off the package. any help will be appreciated.

I run the following statemnet
select object_name from user_objects where object_type = 'PACKAGE BODY';

it show:
OBJECT_NAME

---

UUPDT but whenever I run 'drop package UUPDT it give me an error:

ERROR at line 1:
ORA-04043: object UUPDT does not exist

Thanks in advance. Received on Mon Aug 24 1998 - 12:56:38 CDT