Something wrong! - elsif

From: Na, Kyung-tae (³ª°æÅÂ) <hotchild_at_iitcorp.co.kr>
Date: Tue, 2 Feb 1999 11:53:21 +0900
Message-ID: <795p9t$ki6$1@news.nuri.net>

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 Received on Mon Feb 01 1999 - 20:53:21 CST