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!