Re: elseif problem

Hi
Hope I am wrong...
I see a typo in your elseif part .. I think it should be
elsif

HTH
Pradhan

DODO wrote:

> Hello,
> I have this little piece of code in a trigger:
>
> if l_f = 'sw_w' then
>
> select s.diameter into l_diameter
> from s_w s
> where :new.s_id = s.s_id;
>
> if (l_d is not null) and (:new.a <>:old.a) then
> :new.a := to_char(l_d);
> end if;
>
> elseif (l_f = 'sw_v') then
>
> select v.u into l_u
> from s_v v
> where :new.s_id = v.s_id;
>
> if(l_u is not null) and (:new.a <>:old.a) then
> :new.a := l_u;
> end if;
> end if;
>
> It doesn't compile unless I get rid of elseif(either comment out or split
> into else if, adding an additional end if; at the end)
> Is this a Oracle 8050 bug?
> TIA
> DM
Received on Thu Apr 06 2000 - 00:00:00 CDT