>Hi,
>
>I am suddenly getting a strange problem. This problem occurs only on
>one Oracle Database.
>
>The problem is the previously working code:
>
>lcsql='{Call UpdateColors(?lcBv)}'
>SQLEXEC(h,lsql)
>
>today returns the error 1526 : Syntax Error Or Access Violation
>
>But the code:
>lcsql="{Call UpdateColors('test')}"
>SQLEXEC(h,lsql)
Both times you stored it into l
csql, and then call SQLExec with lsql. Are you sure it's spelled correctly in your code (I assume you retyped it here)?
Second, what is the exact content of lcBv? You may need a breakpoint before the first line just to see what is really there.