Re: Problems when opening cursor for prepared statement twice

Hi Paul, P> I may be wrong, but are you creating a temporary table somewhere else P> within your program. If this is the case then change the create command P> to read i'm not explicitly creating a temporary table. The OPEN CURSOR will itself create a temporary table because of the SELECT contains a GROUP by statement. I solved the problem for the moment by not using a prepared statement. Just put a declare cursor in the function. This works. But because the function was called very often, i want to avoid the extra parsing of the command for every invocation. Greetings, Joerg