Advertisement
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
Advertisement