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
Received on Fri Feb 13 2004 - 13:15:22 CST
