PLS-00103 error in stored procedure!!!

Hi,
I created this procedure

CREATE OR REPLACE procedure upd_coeff as
BEGIN
               UPDATE BL
              SET COEFF=(case when area_oc=0 or area_gr=0
                           then 0
                           else (area_gr/area_oc)
                            end);
              commit;
END;

but when I compile I get error PLS-00103 on CASE clause.
my oracle version is 8.1.7.0

Thanks!!
LVL 1
db_seniorAsked:
Who is Participating?
 
willcode4coffeeConnect With a Mentor Commented:
According to other posts I found, this is not supported in 8.1

http://www.experts-exchange.com/Databases/Oracle/Q_20930966.html

http://www.lazydba.com/oracle/0__59154.html

Hope this helps.

M@
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.