At 04:52 PM 08-12-01 +0100, you wrote:

>I've got more information on this:
>
>I tried to examin the problem with calling several times the same storedproc in the same conditions and the result is weird:
>
>When I first call the storedprocedure I get this 'Error Creating Cursor Handle'. Calling it again doesn't gives me that error anymore.
>
>What's happening?

Without knowing anything about your SP, it is impossible to pinpoint exactly. However, you might be encountering the "XSQLDA bug" which exists in all versions of InterBase and all but the most recent builds of Firebird. (Claudio can tell you which Firebird build fixed this bug). Many of us have gotten so used to working around this bug that we sometimes forget it is there.

In short, the workaround is that you need to call Unprepare and Prepare explicitly EVERY TIME you make a call and pass input parameters to an "execute" style of SP.

For some comments about this bug, see the online FAQ (search on XSQLDA bug) and also the article by Jason on the News page of the ibo website.

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________