testing stored procedure in toad
821806Dec 7 2010 — edited Dec 7 2010DECLARE
PTABLENAME VARCHAR2(200);
PCOLUMNID VARCHAR2(200);
PCOLUMNNAME VARCHAR2(200);
PWHERECLAUSE VARCHAR2(200);
CUR_REC SYS_REFCURSOR;
BEGIN
PTABLENAME := 'HR.TBL_COMMITTEE';
PCOLUMNID := 'COMMITTEEID';
PCOLUMNNAME := 'COMMITTEENAME';
PWHERECLAUSE := 'ISDELETED=0';
-- CUR_REC := NULL; Modify the code to initialize this parameter
HR.USP_COMBOFILL ( PTABLENAME, PCOLUMNID, PCOLUMNNAME, PWHERECLAUSE, CUR_REC );
COMMIT;
LOOP
EXIT WHEN CUR_REC%NOTFOUND;
DBMS_OUTPUT.put_line(TO_CHAR(CUR_REC.COMMITTEENAME));
END LOOP;
CLOSE CUR_REC;
END;
I want to test my PROC through this code in toad is there any alternate??