調用預存程序列印資訊

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>