Posted by: 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 charact=
er).
Select all
Set strSqlPrepare =3D '{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 =3D:spNumss
AND A.CODMUT =3D :cgGlobal.siGLO_Mutuelle
AND A.CLEBENEF =3DA.CLEASS=20
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 th=
is.
Regards
L=E9a M.