Na, Kyung-tae (나경태) wrote:
>
> Hi~
> Question is inside SQL...
>
> create or replace procedure p_fixed_vardata_list
> (arg_paykind in char,
> arg_pbkind in char,
> arg_fvkind in char,
> arg_workym in date,
> arg_allowcode in char,
> outrec in out pmis02.cur_p_fixed_vardata_list)
> is
> begin
> if arg_fvkind = 'F' then
> open outrec for
> select pay_master.empno,
> pers_master_view.empname,
> pers_master_view.deptname,
> pers_master_view.gradename,
> pers_master_view.gradecode,
> pay_fixed_allowance.amount
> from pay_master, pers_master_view, pay_fixed_allowance
> where pay_master.empno = pers_master_view.empno and
> pay_master.empno = pay_fixed_allowance.empno (+) and
> pay_master.paykind = arg_paykind and
> pay_fixed_allowance.pbkind = arg_pbkind and
> pay_fixed_allowance.allowcode = arg_allowcode
> order by pay_master.empno;
> else --if arg_fvkind = 'V' then
> -- I want 'elseif arg_fvkind = 'V' then'
> -- But, PLS:001013 Error occurs. Why?
> open outrec for
> select pay_master.empno,
> pers_master_view.empname,
> pers_master_view.deptname,
> pers_master_view.gradename,
> pers_master_view.gradecode,
> pay_monthly_vardata.amount
> from pay_master, pers_master_view, pay_monthly_vardata
> where pay_master.empno = pers_master_view.empno and
> pay_master.empno = pay_monthly_vardata.empno (+) and
> pay_master.paykind = arg_paykind and
> pay_monthly_vardata.workym = arg_workym and
> pay_monthly_vardata.pbkind = arg_pbkind and
> pay_monthly_vardata.allowcode = arg_allowcode
> order by pay_master.empno;
> end if;
> end;
>
> Am I wrong?
> Thanks...
>
> mailto:hotchild_at_iitcorp.co.kr
Try elsif (that is, only one "e")
--
Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..."
Received on Tue Feb 02 1999 - 04:07:27 CST
