Re: Too many cursors?

In <5d935e$6t2@cssun.mathcs.emory.edu> peter_neilson@lendlease.com.au ("Peter Neilson") writes: >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.* > ... > >There is no syntax error in the select statement, nor any of the >statements. Sometimes I get core dumped! > >I'm using RDS 6.03.UC1, SE 7.12.UC1 on SCO OpenServer Desktop Rel. 5.0.0 >on an AST Bravo MS-T P/166 with 16MB RAM and no other programs in >progress. Any ideas? > Dont know about your problem, but I had quite a number of frustrations with the mix you list above. All but one of them went away when we moved to SCO 5.0.2d, and most importantly RDS 6.04 Not a solution to your posting, just a friendly warning. Bryan Tonnet batonnet@zeta.org.au