You are not allowed to use Case statements in Stored Procedure unless you are in Oracle 9i.

Good Luck