help - proc functions in cursor fetch error

From: Stephen Fensom <stephen.fensom_at_barclaycard.co.uk>
Date: Fri, 06 Nov 1998 11:36:04 +0000
Message-ID: <3642DF24.1D32D80B@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:

   ; , : indicator,

EXEC SQL DECLARE getnextStatement STATEMENT; EXEC SQL DECLARE getnextCursor CURSOR FOR getnextStatement; /* shared */

char stString[500];
EXEC SQL VAR stString IS STRING(500);

sprintf(stString, "SELECT trocrd.status, trocrd.crd_attr,"

"trocrd.acct_nbr, "
"trocrd.xpry_dt, troappl.forenm, troappl.surnm, "
"troappl.addr_line1, troappl.pstcd, "
"troappl.id, trocrd.id, trocrd.mdfy_uid,
trocrd.mdfy_dt_tm, "

"troappl.mdfy_uid, troappl.mdfy_dt_tm,
trocrd.insrt_dt_tm, "

"trocrd.insrt_uid "
"FROM trocrd , troappl "
"WHERE UPPER(troappl.surnm) = :surname "
"AND troappl.id = trocrd.appl_own_id "
"ORDER BY troappl.surnm, troappl.forenm,
trocrd.insrt_dt_tm");

    EXEC SQL PREPARE getnextStatement FROM :stString;     EXEC SQL OPEN getnextCursor USING :surname;

    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;

I hope the code fragment is not to large. Any comments on how I can use functions in this way are appreciated. Thanks,

    Steve F Received on Fri Nov 06 1998 - 05:36:04 CST