autonomous transaction ORA-00600 internal error

From: <ricorieger_at_my-deja.com>
Date: Fri, 18 Aug 2000 08:11:59 GMT
Message-ID: <8nir47$4tq$1@nnrp1.deja.com>

Hi,

i have a problem using autonomous transactions and dynamic SQL. I have two procedures, p1 makes some database changes inside a loop at the local database and on an other database via dblink. at start of loop every time it calls a procedure p2 wich is created with PRAGMA
AUTONOMOUS_TRANSACTION. this procedure p2 updates (an commit after update) simple a local table with the loop counter, so that i
can see progress of p1.

the internal error ORA-00600 [18186] occurs at the commit call in p2 after p1 has made a dynamic sql call.

thanks for your time

Rico Rieger

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Aug 18 2000 - 03:11:59 CDT