> I have found that many times when you exit a cursor abnormally, it leaves a > lock. Do LIST CURSORS and if there is one, then DROP CURSOR > your_cursor_name.
I tried that -- anyway, it was a fresh connection. But is it possible for a different session (on another machine) to leave that lock around? If so, that's probably what happened. Do you know what constitutes an "abnormal" exit from a cursor? I always DROP my cursors, but this table is under development and something may have happened. -- Larry
