Re: Temporary table and autonomous transaction

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Sat, 14 Feb 2004 21:34:30 +0100
Message-ID: <c0m04l$g8v$1@news1.tilbu1.nb.home.nl>

Daniel Morgan wrote:

> 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.
> 

GTT's were not in V6 (guessing here, as they weren't in 5, nor in 7). Glad to be of service ;-)

Now for something completely different:
1) no need for a GTT: pass the value(s) to the procedure B. 2) Make sure B/C can operate - your 3113 could be a sign of

   B, or C crashing, causing the 3113.

Did you check the alert log file on the remote site?

-- 

Regards,
Frank van Bortel

Received on Sat Feb 14 2004 - 14:34:30 CST