如果您需要该包的过程/功能,您可以使用user_procedures http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_4399.htm:
Create Package package_test As
Procedure dummy( x In Number );
Function dummy2 Return Number;
End package_test;
选择对象名称、过程名称
来自用户程序
其中 object_name = 'PACKAGE_TEST';
returns
PACKAGE_TEST DUMMY
PACKAGE_TEST DUMMY2
PACKAGE_TEST
要获取参数,请选择user_arguments http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_4278.htm.
如果您想要包/过程/函数的代码,请使用user_source http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_4436.htm对于您的用户的对象,all_source
对于您的用户已授予的对象,以及dba_source
对于所有对象:
Select *
From user_source
Where name = 'YOUR_TEST'
And type = 'PROCEDURE';
如果您创建了该过程your_test
before:
Create Procedure your_test As
Begin
dbms_output.put_line('test');
End your_test;
它返回
YOUR_TEST PROCEDURE 1 Procedure your_test As
YOUR_TEST PROCEDURE 2 Begin
YOUR_TEST PROCEDURE 3 dbms_output.put_line('test');
YOUR_TEST PROCEDURE 4 End your_test;