Re: Too many cursors?

Nigel Gall wrote: > > Is it possible to open too many cursors? I have a function that > declares a normal cursor, opens it, and then fetches the first row. The > program bombs at the fetch with error number -400: > > SQL statement error number -400. > Fetch attempted on unopen cursor. > > the sample code is as follows: > > ... > declare curs cursor for > <select statement> > > open curs > > fetch curs into vars.* > ... > I'm not sure which version it exists in, but I've seen a bug where a cursor is prepared and declared half a million or so (or less) times then fails with I forget what error. Is the cursor being declared only once? It should be. Douglas Wilson *** My opinions are the same as his. ***