function \ub9cc\ub4e4\ub2e4\uac00 debugging\uc744 \ud558\uace0 \uc2f6\ub2e4\uba74..\uc911\uac04 \uc911\uac04\uc5d0 DBMS_OUTPUT.PUT_LINE()\uc744 \uc774\uc6a9\ud558\uc5ec \ub514\ubc84\uae45 \uba54\uc2dc\uc9c0\ub97c \ucc0d\uc5b4\uc8fc\uba74 \ub418\ub294\ub370……\uadf8\uc804\uc5d0 DBMS_OUTPUT.ENABLE(10000) \uacfc \uac19\uc774 dbms_output\uc744 \ud65c\uc131\ud654 \uc2dc\ucf1c\uc57c \ud55c\ub2e4.<\/p>\n
CREATE OR REPLACE FUNCTION LH_DEV.FN_GET_TEST\r\n(\r\n arg_1 in varchar2,\r\n arg_2 in varchar2\r\n) RETURN varchar2\r\nIS\r\n ret_val varchar2(300) default '';\r\n\r\n BEGIN\r\n DBMS_OUTPUT.ENABLE(10000); -- buffer \uc0ac\uc774\uc988 \uc124\uc815.\r\n DBMS_OUTPUT.PUT_LINE('debug 01');\r\n\r\n SELECT TO_CHAR(SYSDATE, 'YYYYMMDD')\r\n INTO ret_val\r\n FROM DUAL;\r\n\r\n DBMS_OUTPUT.PUT_LINE('debug 02 : ' || ret_val);\r\n\r\n RETURN ret_goods_nm;\r\n\r\n END;<\/pre>\n<\/div>\n\uc704\uc640\uac19\uc740 \ubc29\ubc95\uc73c\ub85c \uc791\uc5c5\ud558\uace0, \uc2e4\ud589\ud574\ubcf4\uba74 toad\uc5d0\uc11c DBMS Output tab\uc5d0\uc11c \ub514\ubc84\uae45 \uba54\uc2dc\uc9c0\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
function \ub9cc\ub4e4\ub2e4\uac00 debugging\uc744 \ud558\uace0 \uc2f6\ub2e4\uba74..\uc911\uac04 \uc911\uac04\uc5d0 DBMS_OUTPUT.PUT_LINE()\uc744 \uc774\uc6a9\ud558\uc5ec \ub514\ubc84\uae45 \uba54\uc2dc\uc9c0\ub97c \ucc0d\uc5b4\uc8fc\uba74 \ub418\ub294\ub370……\uadf8\uc804\uc5d0 DBMS_OUTPUT.ENABLE(10000) \uacfc \uac19\uc774 dbms_output\uc744 \ud65c\uc131\ud654 \uc2dc\ucf1c\uc57c \ud55c\ub2e4. CREATE OR REPLACE FUNCTION LH_DEV.FN_GET_TEST ( arg_1 in varchar2, arg_2 in varchar2 ) RETURN varchar2 IS ret_val varchar2(300) default ”; BEGIN DBMS_OUTPUT.ENABLE(10000); — buffer \uc0ac\uc774\uc988 \uc124\uc815. DBMS_OUTPUT.PUT_LINE(‘debug 01’); SELECT TO_CHAR(SYSDATE, ‘YYYYMMDD’) INTO ret_val FROM DUAL; DBMS_OUTPUT.PUT_LINE(‘debug … Continue reading toad function debugging<\/span>