Re: elseif problem

Thanks Em.

Em Pradhan wrote in message <38ED2167.E4C929A9_at_dplus.net>...
>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 Fri Apr 07 2000 - 00:00:00 CDT