Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What's the error ?
Gabriel Gonzalez wrote:
> It seems that whatever T_CURRENT_FCST_DATE.SFCST_PLAN_CD%TYPE is, it cannot
> be implitcitly converted to a string. Try explicit conversion.
>
> "j" <perseus_medusa_at_hotmail.com> wrote in message
> news:3e52480a$1_at_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
> >
> >
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----
And never rely on implicit conversion for anything.
Daniel Morgan Received on Tue Feb 18 2003 - 10:54:31 CST