I
don't know if this is related to what we are going through here, apparently
Oracle treats transactions via db link as 2-phase commit transactions unless SET
TRANSACTION READ ONLY is used.
Check
dba_2pc_pending to see if you have hung 2-phase commit
transactions.
If you
do, do a search
Let the outer-most calling process handle COMMITs
and ROLLBACKs. Astoredprocedure should concentrate only on
passing back error conditions appropriately.
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, April