case question

[Julia Sats]

I used such code on Oracle 9 :

case i
when 0 then F(0);
when 1 then F(1);
when 2 then F(2);
when 3 then F(3);
end case;

after I moved to another server (Oracle 8) - get such error:
PLS-00103 : Encountered the symbol "CASE" when expecting one of the
following : ......

Does this limitation of version 8 ?
Thanks

[sybrandb@yahoo.com]

Re: case question

"Julia Sats" <julia.sats@sym patico.cawrote in message news:<rs7ab.695 5$hF3.915710@ne ws20.bellglobal .com>...

I used such code on Oracle 9 :
>
case i
when 0 then F(0);
when 1 then F(1);
when 2 then F(2);
when 3 then F(3);
end case;
>
after I moved to another server (Oracle 8) - get such error:
PLS-00103 : Encountered the symbol "CASE" when expecting one of the
following : ......
>
Does this limitation of version 8 ?
Thanks

Yes. PLEASE verify this in the 'new features' document available for
your version and don't ask questions you can easily answer yourself by
searching the documenation.

Sybrand Bakker
Senior Oracle DBA