Groups | Search | Server Info | Login | Register

Groups > comp.databases.gupta > #8

909 (Invalid character)

Show all headers | View raw

Hello,

i have migrated an application from TD2.0 to TD5.2.

when i try to call a stored procedure, i receive error 909 (Invalid character).

    Select all
    Set strSqlPrepare = '{call ' || DACS99001 || ' ( :spBufferIN )}'
    If OdrPrepareProc( hSqlixxx, strSqlPrepare, ':siValue' )
    ...

The exact error is:

     The SQL parser has determined an invalid character while searching for
     quoted strings, numbers, keywords, and identifiers

My SQL request is:

 SELECT A.CLEBENEF,A.DTRAD, A.CLESEC, A.NUMADH
 FROM V004 a
 INTO :spClebenef, :dpDtrad, :spClesec, :spNumadh
 WHERE A.NUMSSB =:spNumss
       AND A.CODMUT = :cgGlobal.siGLO_Mutuelle
       AND A.CLEBENEF =A.CLEASS 


This works fine with TD2.0.

spBufferIN is a Long String (I tried String but it did not change anything).

I hope anybody face this problem previously. So please guide me to solve this.

Regards

Léa M.

Back to comp.databases.gupta | Previous | Next | Find similar

Thread

909 (Invalid character) leticia.mahammed@gmail.com - 2014-02-28 07:28 -0800

csiph-web