Re: Problem with autonomous transaction - it isn't

Do you not have access to Metalink ?

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.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Now running 3-day intensive seminars
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


Hans Kesting wrote in message <3c56b6d6$0$220$4d4ebb8e_at_news.nl.uu.net>...


>

>"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message

>news:4$--$%%%%-_----$%$@news.noc.cabal.int...

>>

>> Bug 1375214 seems to fit - fixed in version 9.

>> There may be a backport to 8.1.7 by now

>>

>

>Do you have any description for this bug? Searches on otn.oracle.com

>and google come up empty ...

>

>Hans Kesting

>

>

>