Re: autonomous transaction ORA-00600 internal error

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sat, 19 Aug 2000 09:02:43 +1000
Message-ID: <399dc057$1@news.iprimus.com.au>

<ricorieger_at_my-deja.com> wrote in message news:8nir47$4tq$1_at_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.
>

ORA-600 errors are nasty, and the standard advice is: don't mess about -pick up the phone and contact Oracle Worldwide Support. HJR
> thanks for your time
>
> Rico Rieger
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Aug 18 2000 - 18:02:43 CDT