Oracle Procedure 를 테스트할 때, 내부 변수들에 할당된 값을 확인해야할 때가 있다.
이럴 때, 다음의 구문을 사용하면 확인이 가능하다.
SQL> set serveroutput on format wrap
SQL> declare
2 x varchar2(30) := 'My name is neo.';
3 begin
4 dbms_output.enable(1000000);
5 dbms_output.put_line ('The value of variable "x" is: ['||x||']');
6* end;
SQL>
/The value of variable "x" is: [My name is neo.]
참조 : www.dbforums.com/oracle/1644155-how-print-value-variable-used-oracle-procedure.html 참조 : http://stackoverflow.com/questions/9519510/how-to-printf-in-oracle-stored-procedure-for-debugging-purposes 참조 : http://dscythe.tistory.com/69 참조 : http://stackoverflow.com/questions/7352366/oracle-stored-procedure-printing-varchar2-output-variable
