--最简单的 [SYS@myoracle] SQL>desc dbms_output PROCEDURE DISABLE PROCEDURE ENABLE 参数名称 类型 输入/输出默认值? ------------------------------ ----------------------- ------ -------- BUFFER_SIZE NUMBER(38) IN DEFAULT PROCEDURE GET_LINE 参数名称 类型 输入/输出默认值? ------------------------------ ----------------------- ------ -------- LINE VARCHAR2 OUT STATUS NUMBER(38) OUT PROCEDURE GET_LINES 参数名称 类型 输入/输出默认值? ------------------------------ ----------------------- ------ -------- LINES TABLE OF VARCHAR2(32767) OUT NUMLINES NUMBER(38) IN/OUT PROCEDURE GET_LINES 参数名称 类型 输入/输出默认值? ------------------------------ ----------------------- ------ -------- LINES DBMSOUTPUT_LINESARRAY OUT NUMLINES NUMBER(38) IN/OUT PROCEDURE NEW_LINE PROCEDURE PUT 参数名称 类型 输入/输出默认值? ------------------------------ ----------------------- ------ -------- A VARCHAR2 IN PROCEDURE PUT_LINE 参数名称 类型 输入/输出默认值? ------------------------------ ----------------------- ------ -------- A VARCHAR2 IN[SYS@myoracle] SQL>--2、查看包的代码 SELECT * FROM all_source t WHERE t.OWNER = UPPER(user_name) AND t.TYPE = 'PACKAGE';--3、用plsql工具查看最方便
SQL> desc dbms_output; Element Type --------- --------- ENABLE PROCEDURE DISABLE PROCEDURE PUT PROCEDURE PUT_LINE PROCEDURE NE W_LINE PROCEDURE GET_LINE PROCEDURE CHARARR TYPE GET_LINES PROCEDURE
--最简单的
[SYS@myoracle] SQL>desc dbms_output
PROCEDURE DISABLE
PROCEDURE ENABLE
参数名称 类型 输入/输出默认值?
------------------------------ ----------------------- ------ --------
BUFFER_SIZE NUMBER(38) IN DEFAULT
PROCEDURE GET_LINE
参数名称 类型 输入/输出默认值?
------------------------------ ----------------------- ------ --------
LINE VARCHAR2 OUT
STATUS NUMBER(38) OUT
PROCEDURE GET_LINES
参数名称 类型 输入/输出默认值?
------------------------------ ----------------------- ------ --------
LINES TABLE OF VARCHAR2(32767) OUT
NUMLINES NUMBER(38) IN/OUT
PROCEDURE GET_LINES
参数名称 类型 输入/输出默认值?
------------------------------ ----------------------- ------ --------
LINES DBMSOUTPUT_LINESARRAY OUT
NUMLINES NUMBER(38) IN/OUT
PROCEDURE NEW_LINE
PROCEDURE PUT
参数名称 类型 输入/输出默认值?
------------------------------ ----------------------- ------ --------
A VARCHAR2 IN
PROCEDURE PUT_LINE
参数名称 类型 输入/输出默认值?
------------------------------ ----------------------- ------ --------
A VARCHAR2 IN[SYS@myoracle] SQL>--2、查看包的代码
SELECT * FROM all_source t
WHERE t.OWNER = UPPER(user_name)
AND t.TYPE = 'PACKAGE';--3、用plsql工具查看最方便
SQL> desc dbms_output;
Element Type
--------- ---------
ENABLE PROCEDURE
DISABLE PROCEDURE
PUT PROCEDURE
PUT_LINE PROCEDURE
NE
W_LINE PROCEDURE
GET_LINE PROCEDURE
CHARARR TYPE
GET_LINES PROCEDURE