DECLARE
  CURSOR c1
  IS
    SELECT so_comment,
      social_office_transaction_id
    FROM social_office_transaction
    WHERE CREATION_DATE BETWEEN TRUNC(SYSDATE - 10) AND TRUNC(SYSDATE)
    AND SO_COMMENT IS NOT NULL;
PROCEDURE bufferCrap IS
BEGIN
  FOR c IN c1
  LOOP
    IF (c.SO_COMMENT LIKE '%Remarque 1 :%' OR c.SO_COMMENT LIKE '%Opmerking 1 :%') THEN
      INSERT INTO SOT_ADMIN_REMARK VALUES
        (c.social_office_transaction_id, 1
        );
    END IF;
    IF (c.SO_COMMENT LIKE '%Remarque 2 :%' OR c.SO_COMMENT LIKE '%Opmerking 2 :%') THEN
      INSERT INTO SOT_ADMIN_REMARK VALUES
        (c.social_office_transaction_id, 2
        );
    END IF;
    IF (c.SO_COMMENT LIKE '%Remarque 3 :%' OR c.SO_COMMENT LIKE '%Opmerking 3 :%') THEN
      INSERT INTO SOT_ADMIN_REMARK VALUES
        (c.social_office_transaction_id, 3
        );
    END IF;
    IF (c.SO_COMMENT LIKE '%Remarque 4 :%' OR c.SO_COMMENT LIKE '%Opmerking 4 :%') THEN
      INSERT INTO SOT_ADMIN_REMARK VALUES
        (c.social_office_transaction_id, 4
        );
    END IF;
    IF (c.SO_COMMENT LIKE '%Remarque 5 :%' OR c.SO_COMMENT LIKE '%Opmerking 5 :%') THEN
      INSERT INTO SOT_ADMIN_REMARK VALUES
        (c.social_office_transaction_id, 5
        );
    END IF;
    IF (c.SO_COMMENT LIKE '%Remarque 6 :%' OR c.SO_COMMENT LIKE '%Opmerking 6 :%') THEN
      INSERT INTO SOT_ADMIN_REMARK VALUES
        (c.social_office_transaction_id, 6
        );
    END IF;
    IF (c.SO_COMMENT LIKE '%Remarque 7 :%' OR c.SO_COMMENT LIKE '%Opmerking 7 :%') THEN
      INSERT INTO SOT_ADMIN_REMARK VALUES
        (c.social_office_transaction_id, 7
        );
    END IF;
    IF (c.SO_COMMENT LIKE '%Remarque 8 :%' OR c.SO_COMMENT LIKE '%Opmerking 8 :%') THEN
      INSERT INTO SOT_ADMIN_REMARK VALUES
        (c.social_office_transaction_id, 8
        );
    END IF;
    IF (c.SO_COMMENT LIKE '%Remarque 9 :%' OR c.SO_COMMENT LIKE '%Opmerking 9 :%') THEN
      INSERT INTO SOT_ADMIN_REMARK VALUES
        (c.social_office_transaction_id, 9
        );
    END IF;
    IF (c.SO_COMMENT LIKE '%Remarque 10 :%' OR c.SO_COMMENT LIKE '%Opmerking 10 :%') THEN
      INSERT INTO SOT_ADMIN_REMARK VALUES
        (c.social_office_transaction_id, 10
        );
    END IF;
    IF (c.SO_COMMENT LIKE '%Remarque 11 :%' OR c.SO_COMMENT LIKE '%Opmerking 11 :%') THEN
      INSERT INTO SOT_ADMIN_REMARK VALUES
        (c.social_office_transaction_id, 11
        );
    END IF;
    IF (c.SO_COMMENT LIKE '%Remarque 12 :%' OR c.SO_COMMENT LIKE '%Opmerking 12 :%') THEN
      INSERT INTO SOT_ADMIN_REMARK VALUES
        (c.social_office_transaction_id, 12
        );
    END IF;
    IF (c.SO_COMMENT LIKE '%Remarque 13 :%' OR c.SO_COMMENT LIKE '%Opmerking 13 :%') THEN
      INSERT INTO SOT_ADMIN_REMARK VALUES
        (c.social_office_transaction_id, 13
        );
    END IF;
    IF (c.SO_COMMENT LIKE '%Remarque 14 %' OR c.SO_COMMENT LIKE '%Opmerking 14 :%') THEN
      INSERT INTO SOT_ADMIN_REMARK VALUES
        (c.social_office_transaction_id, 14
        );
    END IF;
    IF (c.SO_COMMENT LIKE '%Remarque 15 :%' OR c.SO_COMMENT LIKE '%Opmerking 15 :%') THEN
      INSERT INTO SOT_ADMIN_REMARK VALUES
        (c.social_office_transaction_id, 15
        );
    END IF;
    IF (c.SO_COMMENT LIKE '%Remarque 16 :%' OR c.SO_COMMENT LIKE '%Opmerking 16 :%') THEN
      INSERT INTO SOT_ADMIN_REMARK VALUES
        (c.social_office_transaction_id, 16
        );
    END IF;
    IF (c.SO_COMMENT LIKE '%Remarque 17 :%' OR c.SO_COMMENT LIKE '%Opmerking 17 :%') THEN
      INSERT INTO SOT_ADMIN_REMARK VALUES
        (c.social_office_transaction_id, 17
        );
    END IF;
  END LOOP;
END;
BEGIN
bufferCrap();
END;