Hi, I'm having a heck of a time getting this procedure to work.
I've simplified the procedure down to basically just opening a cursor and closing it, but I'm still getting an error that the cursor is still open.
I can install the procedure, but when I call it I get the error about the cursor still being open.(ORA-06511)
Here's my test block:
BEGIN cur_test_procedure; END;
And the procedure that's giving me the problem:
CREATE OR REPLACE PROCEDURE cur_test_procedure IS CURSOR row_cursor IS SELECT t1.col1, t1.col2, t1.col3 FROM test_table1 t1, test_table2 t2 WHERE t1.col2 = t2.col2; BEGIN OPEN row_cursor; for cur_row in row_cursor LOOP DBMS_OUTPUT.PUT_LINE( 'hello world' ); END LOOP; CLOSE row_cursor; END; /
I'm sure its a simple fix, but have been struggling with it for hours. I've tried many different ways of opening/closing the cursor and looping, but nothing is working.
Thanks for any ideas.