토드에서 프로지져 실행

set serveroutput on;
DECLARE
BEGIN
pkg_qna_mail.sp_qna_mail_send('20111019161527870_0000001070','G','F2943B60A2C811D9916ED8B6B5DF9188','A013','','EDU','20111019161527_EDU_f5b0','3333333','','', '','N100','33333333333'); 
END;



-- 실행
SET SERVEROUTPUT ON

DECLARE
  V_USER_SQ NUMBER;
  V_PROP_ARR VARCHAR2(200);
  SHOWMSG VARCHAR2(200);
  SHOWCODE VARCHAR2(200);

BEGIN
  V_USER_SQ := 10008;
  V_PROP_ARR := '001*601*@002*602*@003*603*@';
  SHOWMSG := NULL;
  SHOWCODE := NULL;

  POC.PR_POC_CONFIG_SAVE ( V_USER_SQ, V_PROP_ARR, SHOWMSG, SHOWCODE );
  DBMS_OUTPUT.PUT_LINE(SHOWMSG);
 DBMS_OUTPUT.PUT_LINE(SHOWCODE);

END;