RE: Re: RE: Strange error with Codexpert

Can you let me know what Rules are being triggered (the number, not the description)?  Some of the rules may need tweaking and we can look and see if these are in that group.

Thanks,

Greg

From: [email protected] [mailto:[email protected]] On Behalf Of Manuel C.
Sent: Thursday, December 08, 2011 08:35 AM
To: [email protected]
Subject: [toad] 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

__
_______________________________________