sqlplus里如何查看|执行存储过程代码

> 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

文章出处：飞诺网()