Re: Oracle Procedures and Packages

From: Matt Arena <arenam_at_popgtwfnal.gov>
Date: 1997/07/25
Message-ID: <33D8E379.DE62D432@popgtwfnal.gov>#1/1

Paul Smith wrote:

> I'm in need of an answer to the following question:
>
> Given an Oracle7 procedure or function name, is it possible to
> determine the following:-
> a) The name of the enclosing package (if any)
> b) If it is a freestanding procedure or function
> c) If it exists on the database at all
>
> Thanks in advance,
> Paul.

 Paul,

 I'm not sure about part "a" but this will help with "b" and "c".

select object_type, owner
from dba_objects
where object_name = 'name';

---

Matt Arena
Systems Analyst / DBA
Fermi National Accelerator Laboratory
arenam_at_fnal.gov Received on Fri Jul 25 1997 - 00:00:00 CDT