Mark;

I had this happen with a major application I delivered about 2 years ago. A process was called several thousand times a day and created a cursor and then Used In to kill the cursor at the end of the method. On occasion the cursor would still exist so I just entered the code below before the Select statement used to create the cursor. Two years later the system is still working so I did not touch the code.

Having worked in the Aerospace Industry I like this approach - kill the cursor twice if necessary. Redundancy sometimes gets the job done.

If used("mycursor")

used in mycursor

endif

Tom