2010. 7. 30. 11:08

Oracle에서 output 확인하기

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;