通过查询 user_source 视图,就可得到你存储过程的文本。 SQL> create or replace procedure sp_test(p int) 2 as 3 begin 4 dbms_output.put_line('p:' || p) ; 5 end; 6 /过程已创建。SQL> select text from user_source where name = 'SP_TEST' ;TEXT --------------------------------------------------------------------------------procedure sp_test(p int) as begin dbms_output.put_line('p:' || p) ; end;SQL>
SQL> create or replace procedure sp_test(p int)
2 as
3 begin
4 dbms_output.put_line('p:' || p) ;
5 end;
6 /过程已创建。SQL> select text from user_source where name = 'SP_TEST' ;TEXT
--------------------------------------------------------------------------------procedure sp_test(p int)
as
begin
dbms_output.put_line('p:' || p) ;
end;SQL>