Case statements in Oracle 8i
Was typing in a SP in oracle 9i. Being familiar with SQL Server 2000 i used the "case" statements in the pl/sql and i found it was working smooth. The functionality should also run in Oracle 8i, so considering the developments Oracle is making in ANSI - SQL, i reviewed the code for 8i compatibility, I also browsed few sites which gave me information that case satements are compatible from 8i onwards. But when the tester ran the script i was suprised to find the script giving out compilation errors. So I cross checked the case statments compatibility in 8i once again and i was surprised to find the case statements are not compatible with PL/SQL ? Different parsers for the same Oracle version should be a well known problem but this difference in SQL and PL/SQL parsers looks stupid to me.


0 Comments:
Post a Comment
<< Home