topic Re: Invalid cursor in Application Development and Automation Discussions

Invalid cursor

Former Member — Thu, 27 Mar 2008 15:56:52 GMT

hi guys,

for first time i've met short dump "invalid cursor" in NOT debugging contest.

it happens into select/endselect (...) loop, buto only into production system (not in develop and test).

the tables inquired is QUALS.

could someone help me, please?

Re: Invalid cursor

Former Member — Thu, 27 Mar 2008 16:12:29 GMT

Hi Ivan

It depends on the database and the number of the hits of the table: it can happen when it does a debug into loop SELECT/ENDSELCT: sometimes the system loses the cursor and raises that dump.

In this case u have only one solutin: skip the SELECT/ENDSELCT

SORRY I've seen only now "IN NOT DEBUGGING CONTEST"

Have you other informations?

Max

Re: Invalid cursor

franois_henrotte — Thu, 27 Mar 2008 16:14:28 GMT

in your case, that does mean that a COMMIT has been raised somewhere (probably in a routine called inside the SELECT / ENDSELECT loop)