Re: Closing opened cursors

Chris Roy wrote:
>
>
> Using the old oracle 7 oci I've run into a simple problem. If oclose
> is called twice on a cursor the
> "ORA-01001: invalid cursor" error is generated. The question is how do
> you check if a cursor has been
> opened?
>
> if (&(secondCursor)) {
> if (oclose(&(secondCursor))) {
> flagError(&(secondCursor));
> }
> }
>
> Chris
>
> well, close the cursor then re-open it...

        if job_cursor%isopen then
           close job_cursor;
        end if;

      or

        if not job_cursor%isopen then
               open job_cursor;
        end if;

--
Posted via CNET Help.com
http://www.help.com/