24 lines
605 B
SQL
24 lines
605 B
SQL
-- object arguments
|
|
|
|
col proc_owner head OWNER for a25
|
|
col proc_object_name head OBJECT_NAME for a30
|
|
col proc_procedure_name head PROCEDURE_NAME for a30
|
|
|
|
select
|
|
a.owner proc_owner
|
|
, a.object_name proc_object_name
|
|
, p.procedure_name proc_procedure_name
|
|
, a.subprogram_id
|
|
from
|
|
dba_arguments a
|
|
, dba_procedures p
|
|
where
|
|
a.owner = p.owner
|
|
and a.object_name = p.object_name
|
|
and a.object_id = p.object_id
|
|
and a.subprogram_id = p.subprogram_id
|
|
and lower(p.owner) like lower('%&1%')
|
|
and lower(p.object_name) like lower('%&2%')
|
|
and lower(p.procedure_name) like lower('%&3%')
|
|
/
|