Guest User

Untitled

a guest
Nov 23rd, 2015
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.81 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION INSERT_PAYJOURNALREC_ARCH (
  2.    V_START_ID     IN NUMBER,
  3.    COUNT_RECORD   IN NUMBER)
  4.    RETURN BOOLEAN
  5. AS
  6.    save_success   BOOLEAN;
  7. BEGIN
  8.    DECLARE
  9.       j   INT;
  10.    BEGIN
  11.       DBMS_OUTPUT.ENABLE;
  12.       j := 0;
  13.  
  14.       FOR i IN (SELECT id
  15.                   FROM ipsh.payjournalrec pay
  16.                  WHERE pay.id <= V_START_ID)
  17.       LOOP
  18.          j := j + 1;
  19.  
  20.          INSERT INTO PAYJOURNALREC_ARCH
  21.             (SELECT *
  22.                FROM PAYJOURNALREC
  23.               WHERE ID = i.id);
  24.  
  25.          DELETE IPSH.PAYJOURNALREC pay_inn
  26.           WHERE pay_inn.id = i.id;
  27.  
  28.          IF j > COUNT_RECORD
  29.          THEN
  30.             COMMIT;
  31.             DBMS_OUTPUT.put_line ('COMMIT');
  32.             j := 0;
  33.          END IF;
  34.       END LOOP;
  35.  
  36.       COMMIT;
  37.    END;
  38. END;
  39. /
Advertisement
Add Comment
Please, Sign In to add comment