Question

oracle怎么查看存储过程代码

Answer 1

> sqlplus ( < username > [/ < password > ][@ <
connect_identifier > ] | /) [AS SYSDBA | AS SYSOPER] | /NOLOG
SQL > desc user_source;
Name Null ? Type
-- --------------------------------------- -------- ----------------------------

NAME VARCHAR2 ( 30 )
TYPE VARCHAR2 ( 12 )
LINE NUMBER
TEXT VARCHAR2 ( 4000 )

SQL > select TEXT from user_source where TYPE = ' PROCEDURE ' and NAME = ' Your_Procedure_name ' ;

no rows selected

SQL > var out_var number
exec Your_Procedure_name ( '' , '' , '' ,:out_var)
print out_var