sqlplus 执行 oracle 存储过程 分页,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

文章出处：飞诺网()