Not a member of Pastebin yet?
                        Sign Up,
                        it unlocks many cool features!                    
                - CREATE OR REPLACE PACKAGE BODY REVELATION.EMT AS
 - CURSOR curPLAN(d DATE) RETURN EMT_PLAN IS
 - SELECT
 - *
 - FROM
 - EMT_PLAN ep
 - WHERE
 - TRUNC(ep.REP_RUN_DATE) = d;
 - PROCEDURE CLMAIN_RUNNER AS
 - rowPLAN EMT_PLAN%ROWTYPE;
 - BEGIN
 - OPEN curPLAN(TRUNC(SYSDATE));
 - LOOP
 - FETCH curPLAN INTO rowPLAN;
 - EXIT WHEN curPLAN%NOTFOUND;
 - END LOOP;
 - END;
 - END EMT;
 
Advertisement
 
                    Add Comment                
                
                        Please, Sign In to add comment