Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What's the error ?

Re: What's the error ?

From: Gabriel Gonzalez <no-spam_at_no-spam.com>
Date: Tue, 18 Feb 2003 07:24:53 -0800
Message-ID: <3e5234f9_2@binarykiller.newsgroups.com>


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 =----- Received on Tue Feb 18 2003 - 09:24:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US