At 01:42 PM 5/04/2004 +0000, you wrote:

>Hi,
>
>It's the first time in several years I saw this error : "Declared cursor
>already exists" after doing a prepare of a normal parameterized query.

Instead of Prepare, do
if not prepared then prepare

>When I later close and reopen the query again, I get the following error :
>"Attempt to reopen an open cursor".

Probably because the query hadn't finished fetching - it has to do this
before it can close. You can catch this exception and do a retry.

If the problem is not a slow network (e.g. a dialup line) then better
reduce the size of your return sets.

Helen