Re: drop package

From: Terry Dykstra [TeamPS] <no_spam_tdykstra_at_cfol.ab.ca>
Date: Mon, 24 Aug 1998 16:45:08 -0600
Message-ID: <35e1ec63.0@news.cadvision.com>

Try: drop package body uupdt

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

j.k. wrote in message <6rs9gm$ee3$1_at_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 - 17:45:08 CDT