What's the error ?

From: j <perseus_medusa_at_hotmail.com>
Date: Tue, 18 Feb 2003 22:56:43 +0800
Message-ID: <3e52480a$1@newsgate.hknet.com>

Hi all ,
I have a procedure like the following :

create or replace procedure SP_BACKUP_T_PROJECT AS

    week_day VARCHAR2(10);
    cursor CUR_T_CURRENT_FCST_DATE (week_day varchar2) is

        select SFCST_PLAN_CD from T_CURRENT_FCST_DATE
        where to_char(CUTOFF_W) = week_day

    for update of SFCST_PLAN_CD;
    plan_cd T_CURRENT_FCST_DATE.SFCST_PLAN_CD%TYPE; BEGIN
    select to_char(sysdate,'w') into week_day from dual;     for plan_cd in CUR_T_CURRENT_FCST_DATE(week_day) loop

        dbms_output.put_line('plan_cd :' || plan_cd);     end loop;
    dbms_output.put_line(week_day);
END;
/
show errors procedure SP_BACKUP_T_PROJECT;

But it complains that PLS-00306: wrong number or types of arguments in call to '||'
Why's that ?
THanks.

Perseus Received on Tue Feb 18 2003 - 08:56:43 CST