Re: Wrong execution under Debugger

Just ran this using SQL-Programmer and I can see nothing unusual. Do you have one row in dual?

Lloyd

"Sergey M" <msu_at_pronto.msk.ru> wrote in message news:ad4g16$8v4$1_at_serv2.vsi.ru...
> Hello!
>
> I have executed below code under debugger (step by step) and I have very
> interesting result.
> Try!!!
>
> create or replace function Mart_s return number is
> num number;
> begin
> select count(*) into num from dual;
> if num = 1 then -- 1 start
> select count(*) into num from dual;
> if num = 1 then -- 2 start
> commit;
> select count(*) into num from dual;
> commit;
> else -- 2 else
> if num = 1 then -- 3 start
> select count(*) into num from dual;
> end if; -- 3 end;
> end if; -- 2 end;
> else -- 1 else;
> null;
> end if; -- 1 end;
> return num;
> end;
>
> May be Anybody can explain me this result.
>
> Best regards,
> Sergey M.
>
>
>
>
>
>
Received on Thu May 30 2002 - 09:28:48 CDT