Unanswered: Global temporary table and autonomous_transaction
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 hangs during execution function "C" and I get ora-03113.
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 starts autonomous transaction but I don't know why.
Thank you very much for your help