Re: What's the error ?

> 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);

try to_char(plan_cd) here

> 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 ?
Received on Tue Feb 18 2003 - 09:44:52 CST