When i try to close a ref cursor, it is not closing the cursor at all. i'm getting a ora error , which describes the error to be too many cursors open. do any one know why it is not closing the cursor inspite of so many close cursor statement in my pl/sql block.
I don't know the type of statement you run, but have you tried issuing a commit?
OCP DBA 8i, 9i, 10g
if u could clearly describe the oracle error message we can further dig on that..
is this error message u getting..
ORA-01000 maximum open cursors exceeded
on the otherway..
b4 u open the cursor issue an urcursor%isopen then close urcursor;
if u could paste the code we can try to get some solution
Click Here to Expand Forum to Full Width