oracle数据库中查看系统存储过程的方法

Shun

select line,text from dba_source where name='PRO_E_F_ORDER_STAT'; 
select object_name,object_type from dba_objects where object_type='PROCEDURE';