编写一个oracle 存储过程报错

问题描述

--计算个人所得税createorreplaceproceduregetTex(salinnumber,texoutnumber)asbeginifsal<3500thentex=0;elsif(sal-3500)<1500tex=round((sal*0.03),2);elsif(sal-3500)between1501and4500thentex=round((sal*0.1-105),2);elsif(sal-3500)between4501and9000thentex=round((sal*0.2-555),2);elsif(sal-3500)between9001and35000thentex=round((sal*0.25-1005),2);elsif(sal-3500)between35001and55000thentex=round((sal*0.30-2755),2);elsif(sal-3500)between55001and80000thentex=round((sal*0.35-5505),2);else(sal-3500)>80001thentex=round((sal*0.45-13505),2);endif;end;/错误信息:PROCEDUREGETTEX已编译Errors:checkcompilerlog有没大神帮忙看看哪错了?

解决方案

解决方案二：
tex:=0;

Oracle中赋值语法：变量:=值;