Re: case question

"Julia Sats" <julia.sats_at_sympatico.ca> wrote in message news:<rs7ab.6955$hF3.915710_at_news20.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 Received on Thu Sep 18 2003 - 09:39:37 CEST