909 (Invalid character)

[leticia....@gmail.com]

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.