909 (Invalid character)

comp.databases.gupta (1995-2015)
leticia....

909 (Invalid character)

Post by leticia.... » 28 Feb 2014, 16:28

 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.

Return to “comp.databases.gupta”

Who is online

Users browsing this forum: [Ccbot], [Semrush] and 0 guests