2010. 7. 30. 11:08
Oracle에서 output 확인하기
2010. 7. 30. 11:08 in Program Study/Oracle
DECLARE
a VARCHAR2(40);
b NUMBER;
c NUMBER;
BEGIN
EEA_BUDGET_PKG.GET_FUNDS_AVAILABLE_P(TO_DATE('20100723', 'YYYY/MM/DD'),'건설예산','02533','19900008','21030100','99999999', a, b, c);
DBMS_OUTPUT.DISABLE;
DBMS_OUTPUT.ENABLE;
DBMS_OUTPUT.put_line('budget_amount : '||a);
DBMS_OUTPUT.put_line('amount : '||b);
DBMS_OUTPUT.put_line('budget_type : '||c);
END;