关于spl中case用法问题请各位大侠帮忙

yjw__yjw__

create procedure case_exam_1221(dm int)
returning char(20);
define tran_dm char(20);
       case  dm
         when 1 then let tran_dm ="1 is para";
         when 2 then let tran_dm ="2 is para";
         when 3 then let tran_dm ="3 is para";
         when 4 then let tran_dm ="4 is para";
         when 5 then let tran_dm ="5 is para";
         when 6 then let tran_dm ="6 is para";
       end case;
        return tran_dm;
end procedure;
说在case处有语法错

霏飞

去掉let 试试~

wenlq

case 不能象c里面那样当语句来用，该当表达式来用。
      let tran_dm = case  dm
         when 1 then "1 is para"
         when 2 then "2 is para"
         when 3 then "3 is para"
         when 4 then "4 is para"
         when 5 then "5 is para"
         when 6 then "6 is para"
       end     ;
        return tran_dm;

也可以用decode ( dm , 1,"1 is para",2,"2 is para", ... , 6 , "6 is para" )