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

posted on 2007-11-28 14:00 jht 阅读(2730) 评论(0) 编辑收藏

随笔分类