0

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.

1
Contributor
1
Reply
2
Views
6 Years
Discussion Span
Last Post by harry010
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.