Re: Disappearing Stored Procedures
From: Dwayne King <dwayne_at_kridan-consulting.com>
Date: Thu, 23 Nov 2000 23:59:16 GMT
Message-ID: <obiT5.22861$kd.4549301_at_news3.rdc1.on.home.com>
Date: Thu, 23 Nov 2000 23:59:16 GMT
Message-ID: <obiT5.22861$kd.4549301_at_news3.rdc1.on.home.com>
Are you sure you're logging in as the same user when you are checking? Different ones would be available to different users.
How are you checking? The most reliable way is to do something like:
select object_name from user_objects where object_type in ('PROCEDURE','FUNCTION','PACKAGE','PACKAGE BODY') DK
"Paul Goodfellow" <pgoodfellow_at_ups.com> wrote in message
news:8vjmvh$6sh2_at_biko.telecom.ups.com...
> It seems rather strange but has anyone experienced the inexplicable
> disappearance of Stored Procedures? My platform is Oracle 8.0.5 on the
> NT platform and twice now I have has Stored Procedures disappear from
> the system?
>
> Any ideas?
>
Received on Fri Nov 24 2000 - 00:59:16 CET