取得一个用户的存储过程列表:
select t.object_name,t.owner,t.object_type from dba_objects t where object_type = 'PROCEDURE' and t.owner='LIAN'
取得一个存储过程的参数
select t.in_out, t.argument_name, o.object_name, o.owner
from User_Arguments t, dba_objects o
where t.object_id = o.object_id
and o.object_name = 'MYPROC'