调用存储过程打印信息

1、创建存储过程 调用     DBMS_OUTPUT.put_line()打印信息

CREATE OR REPLACE PROCEDURE proc_helloworld

 IS
 BEGIN
     DBMS_OUTPUT.put_line ('Hello World! '||chr(10)||'I am a Happy DBA Secooler!');

 END;

2、确定serveroutput 打开

SQL> execute proc_helloworld;
 
PL/SQL procedure successfully completed
 
SQL> set serveroutput on;
SQL> execute proc_helloworld;
 
Hello World!
I am a Happy DBA Secooler!
 
PL/SQL procedure successfully completed
 
SQL>
 

create or replace procedure test(workDate in char) is
begin
dbms_output.put_line(workDate);
end test;

SQL> execute test(20120928);
 
PL/SQL procedure successfully completed
 
SQL> set serveroutput on;
SQL> execute test(20120928);
 
20120928
 
PL/SQL procedure successfully completed
 
SQL>