Re: Fetch on unopen cursor problem

Richard Moon <100517.3377@CompuServe.COM> wrote: >Can anyone give me an insight into a Fetch on unopen cursor >problem. 4.1 RDS and SE on HP-UX 9.04. A very simple cursor >'SELECT * FROM fred' immediately followed by a FOREACH which >gives -400 Fetch on unopen cursor. In another part of the program >we do inserts to table fred (not in a cursor). The problem occurs >after we have done the inserts. If we exit the program, re-enter >and run the SELECT without doing the inserts there is no problem. Are you doing a COMMIT WORK after inserting into table fred? This will close all cursors not declared WITH HOLD and you get the behavior you described. Paul Kapp ----> PLKapp@aol.com -OR- plk@usorder.com