Re: Temporary table and autonomous transaction

szalas wrote:

> Hi,
> I have such problem in pl/sql procedures:
>
> Procedure "A" first inserts one row to the remote global temporary table
> TABLE_T
> and then calls remote procedure "B" .
> Procedure "B" operate on this row in TABLE_T and calls function "C" which
> starts autonomous transaction. And this autonomous transaction is a very big
> problem. Procedure "B" hangs when tries to execute function "C" and I get
> ora-03113. Function "C" doesn't do anything special (inserts one row to
> table TABLE_1)
> If function "C" does not start autonomous transaction everything goes well.
> I thing the problem is that I use global temporary table and one function
> tries to start autonomous transaction, but I don't know why and how to solve
> this.
> Thank you very much for your help
> Szalas

No Oracle version or edition
No PL/SQL
How do you expect anyone to help you?

It might be a bug but I don't know if you have version 6 or 10g.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)