Re: Strange behaviour in PL/SQL (IF ignored)

From: Michael Bialik <bialik_at_isdn.net.il>
Date: 13 Sep 2001 05:27:39 -0700
Message-ID: <969f8022.0109130427.579b0a0d@posting.google.com>

Why the same cursor "atreecursor" appears twice( inside then and inside else)?

begin
  if aParentID = 0 then

            open atreecursor for select * ...
  else

     open atreecursor for select *
       from ...

     open aoffertypecursor 
       for select a.product_id, ...

  end if;

Michael. Received on Thu Sep 13 2001 - 07:27:39 CDT