At 06:57 PM 6/06/2004 +0000, you wrote:

> >
> > Did you see my SP_3 test proc? I have reproduced the error with
> > IB_STORECPROC and IBOQUERY.
> > I also tested with IBX's IBSTOREDPROC and its MONITOR didn't show any
> > error.
>
>Nobody with a clue were this error comes from?
>
>I've reduced the problem to a sp with 1 returnparameter and 1
>statement. I've tested several components in my app and I've tested
>this sp with IB_SQL. All tests show this error.
>The error messages is not consistent. Below two messages from two runs
>in IB_SQL:
>
>/*---
>[ 6-6-2004 20:47:13 ]
>CLOSE ROW CURSOR
>STMT_HANDLE = 14380232
>
>ERRCODE = 335544569
>----*/
>/*---
>[ 6-6-2004 20:47:30 ]
>CLOSE ROW CURSOR
>STMT_HANDLE = 14380516
>
>SECONDS = 0,010
>
>ERRCODE = 335544569
>----*/
>
>Sometimes timing is included, sometimes not.
>
>Every executable procedure in my app returning a singleton result show
>this error.
>
>It was assumed that I probably do something wrong with preparing,
>whatever. Why do I get correct results then?

That exception is a DSQL error...all of your procedures work on my setup
and don't return any exceptions. You're getting a result back, right? So
apparently the SPs are executing and then something is happening afterwards
that's causing this exception.

So let's see the code: the exact SQL statement, your app code that calls
it and your app code that reads the result. Not a vague description, but
actual code.

Helen