Re: RE: Re: RE: Strange error with Codexpert

 Message from: Manuel C.

Hi,
Do you mean in general or those which give me that error?
The last one, are Rules 2606 and 2608.
I am Picking up "All rules by objective"

BTW I have tried also something very simple,
like the code below, and it is also giving me the same error:

declare
  
  cursor cur is 
         select *
           from dual;
begin

    if NOT cur%isopen then
      open cur;
    end if;

close cur;

end;


Question2: IS there a way for me to see the "source code" definition of those rules, i.e. what it is checking?

Thanks
manuel

_______________________________________

Historical Messages 


Author: Manuel C.
Date: Thu Dec 08 06:31:01 PST 2011
Hi,
Do you mean in general or those which give me that error?
The last one, are Rules 2606 and 2608.
I am Picking up "All rules by objective"

BTW I have tried also something very simple,
like the code below, and it is also giving me the same error:

declare
  
  cursor cur is 
         select *
           from dual;
begin

    if NOT cur%isopen then
      open cur;
    end if;

close cur;

end;


Question2: IS there a way for me to see the "source code" definition of those rules, i.e. what it is checking?

Thanks
manuel
__

Author: Gregory Liss
Date: Thu Dec 08 05:34:44 PST 2011




 

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


__

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
 
__
_______________________________________