Re: RE: Strange error with Codexpert

 Message from: Manuel C.

Sorry,
I have seen there was a copy past error.
The code is like this

if NOT  c1%ISOPEN then
open c1 (name);
end if;

_______________________________________

Historical Messages 


Author: Manuel C.
Date: Thu Dec 08 05:34:44 PST 2011
Sorry,
I have seen there was a copy past error.
The code is like this

if NOT  c1%ISOPEN then
open c1 (name);
end if;
__

Author: Manuel C.
Date: Thu Dec 08 05:32:49 PST 2011
Hi,
I must admin I have not coded it and I am also no big expert of pl/sql.
But I understand the idea is to check first if the cursor is already open, and only if NOT then open it. to avoid opening an already open cursor.
manuel
__

Author: David Reed
Date: Thu Dec 08 04:51:29 PST 2011
I don't think it is so strange.  Why would you check for an open cursor and then try to open it again?


__

Author: Guest
Date: Thu Dec 08 04:51:28 PST 2011
 
__
_______________________________________