question re: dba_procedures

From: EdStevens <quetico_man_at_yahoo.com>
Date: 21 Feb 2007 06:31:29 -0800
Message-ID: <1172068289.715359.294500@a75g2000cwd.googlegroups.com>

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? Received on Wed Feb 21 2007 - 08:31:29 CST