Hi guys,
Both cursor works if i don't use them in one Stored procedure. Both cursors return TRUE for(cursor_x%found). But, insert into process doen't work in cursor_1. Is there any structure problem?
Thanks
CREATE OR REPLACE PROCEDURE ADD_RENTAL_SP
IS
-- cursor1
CURSOR cursor_1 IS
SELECT ......
rec1 VARCHAR(15);
-- cursor2
CURSOR cursor_2 IS
SELECT ......
rec2 VARCHAR(15);
BEGIN
OPEN cursor_2;
LOOP
FETCH cursor_2 INTO rec2;
IF ( cursor_2%found ) THEN
INSERT INTO .....
----
OPEN cursor_1;
LOOP
FETCH cursor_1 INTO rec1;
IF ( cursor_1%found ) THEN
INSERT INTO ...
EXIT WHEN cursor_1%found;
END IF;
END LOOP;
CLOSE cursor_1;
----
EXIT WHEN cursor_2%found;
END IF;
END LOOP;
COMMIT;
CLOSE cursor_2;
END;