urgent (closing ref cursor)

[msuresh]

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.

[dknight]

I don't know the type of statement you run, but have you tried issuing a commit?

Good luck.

[vbaskar]

Hi

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