Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA 1000 - Max number of cursors exceeded
hi,
i definitely know that a corsor will not close implicitly
at the procedure end.
when u run the procedure again then i twill give u an error.
try usuing cursor for loops because here u donot have to
explicitely open or close the cursor