[오렌지]오렌지에서 프로시져 리턴값 확인할때...
DECLARE
ls_Text VARCHAR2(500);
ls_Receive VARCHAR2(500);
BEGIN
ls_Text := 'eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee';
SP_RETURN_TEXT ( ls_Text, ls_Receive);
DBMS_OUTPUT.ENABLE;
DBMS_OUTPUT.PUT_LINE(CHR(10));
DBMS_OUTPUT.PUT_LINE('--------------------------------------------');
DBMS_OUTPUT.PUT_LINE(ls_Receive);
DBMS_OUTPUT.PUT_LINE('--------------------------------------------');
END;
ls_Text VARCHAR2(500);
ls_Receive VARCHAR2(500);
BEGIN
ls_Text := 'eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee';
SP_RETURN_TEXT ( ls_Text, ls_Receive);
DBMS_OUTPUT.ENABLE;
DBMS_OUTPUT.PUT_LINE(CHR(10));
DBMS_OUTPUT.PUT_LINE('--------------------------------------------');
DBMS_OUTPUT.PUT_LINE(ls_Receive);
DBMS_OUTPUT.PUT_LINE('--------------------------------------------');
END;