Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    46

    Unanswered: Global temporary table and autonomous_transaction

    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 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
    Szałas

  2. #2
    Join Date
    Feb 2004
    Posts
    108
    That autonomous txn will cleanup your global temp table.
    Can this lock your procedure C ?
    What other tasks is this procedure doing ?
    Your error is : ORA-03113 end-of-file on communication channel

  3. #3
    Join Date
    Jul 2003
    Posts
    46
    Function "C" does not use temporary table TABLE_T so rather it can't lock it.
    Function "C" insert one row to table TABLE_1.
    Szałas

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •