Re: Problem with autonomous transaction - it isn't

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:1012323687.23147.0.nnrp-13.9e984b29_at_news.demon.co.uk...
>
> Do you not have access to Metalink ?
>

*now* I have, it took a while to find the access data.

> I typed in 'autonomous transaction fetch out of sequence'
> in the advanced search section there, and got the bug
> reference from the first page of results.
>
> The bug is exactly what you see - the COMMIT of the
> autonomous transaction appears to close the cursor
> of the loop so you get ORA-01002.
>

It is even more specific: the bug only appears when the cursor is defined "FOR UPDATE".

Hans Kesting Received on Wed Jan 30 2002 - 04:57:16 CST