Re: question re: dba_procedures

On Feb 21, 9:31 am, "EdStevens" <quetico_..._at_yahoo.com> wrote:
> Oracle 10.2.0.2 on HP-UX
>
> Doing some queries on dba_procedures, I get some rows where
> PROCEDURE_NAME is null. That seems pretty bizarre to me. Those same
> rows did have values on OBJECT_NAME, so I cross-referenced back to
> dba_objects:
>
> select p.owner,
> o.object_type,
> o.object_name,
> p.procedure_name
> from dba_objects o,
> dba_procedures p
> where p.owner in (<snip owner list>)
> and o.object_name = p.object_name
> order by 1, 2,3
>
> That showed some of the null procedure names on object_type of
> package, package body, procedure, synonym, trigger, but no
> consistency that I can see. Also, a bunch of the packages show an
> object name of 'VALID'.
>
> So, what am I seeing here? Am I looking at things from the wrong end?

Do you have a specific problem with one of your procedures?

Give us an idea of why you are asking this.

If it is just idle curiousity then maybe submit it to oracle support as a low priority. Received on Wed Feb 21 2007 - 10:11:28 CST