Re: help - proc functions in cursor fetch error

From: Alan D. Mills <alanm_at_uk.europe.mcd.mot.com>
Date: Fri, 6 Nov 1998 13:08:34 -0000
Message-ID: <71usav$d5d$1@schbbs.mot.com>

It looks like you've put the TO_CHAR on the INTO variable. You should TO_CHAR the values as they come off the database and not as you attempt to push them into host variables. Put the TO_CHARs into your SELECT and use simp[le host variables in the INTO clause.

--
Alan D. Mills

Stephen Fensom wrote in message <3642DF24.1D32D80B_at_barclaycard.co.uk>...
>Please - somebody help!
>Using ProC with Oracle Enterprise 7.3, I have problems porting my
>application from Informix ESQL/C on Solaris 2.5 Sparc. The following
>error occurs for the following code. How can I get around this.
>
>Syntax error at line 536, column 12, file rosedb.pc:
> TO_CHAR(:m->expiryDate, 'YYYY/MM/DD'),
>.......................................1
>(1) PCC-S-02201, Encountered the symbol "(" when expecting one of the
>following:
>
> EXEC SQL FETCH getnextCursor INTO :m->presentStatus,
>:card_attribs:i_attr,
> :m->cardNumber,
> TO_CHAR(:m->expiryDate, 'YYYY/MM/DD'),
> :m->firstname, :m->surname, :m->addr1,
> :m->postcode, :citizenId, :m->cardID,
> :cardModBy,
> TO_CHAR(:cardModAt, "YYYY/MM/DD
>HH24:MI:SS,"),
> :applModBy,
> TO_CHAR(:applModAt, "YYYY/MM/DD
>HH24:MI:SS,"),
> TO_CHAR(:m->createdAt,"YYYY/MM/DD
>HH24:MI:SS,"),
> :m->createdBy;
>
Received on Fri Nov 06 1998 - 07:08:34 CST