Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DML through DBLink

DML through DBLink

From: <d.mincheva_at_gmail.com>
Date: 15 May 2006 01:57:38 -0700
Message-ID: <1147683458.861450.168490@j33g2000cwa.googlegroups.com> 





Hi all,


I have a job which executes a stored procedure "A" in database "D1".
"A" calls the procedure "B" stored in database "D2" through DBLink. "B"
is compiled with autonomous_transaction pragma. My question is does "A"
know if "B" has finished its execution? The reason to ask this question
is that sometimes "A" never ends eventhough "B" has finished.
Thanks in advance!
Received on Mon May 15 2006 - 03:57:38 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US