Session hangs after network problems
We are replication two equal tables on different
database servers with a PL/SQL-package.
The according package procedure is periodically activated via a database job. Because different reasons we can't use Oracle Streams or Materialized Views for the replication.
This works fine if the network connection is ok.
But when the network cable will be disconnect at the remote site, the session of
the job hangs. When will remove the job, the sessions still hangs.
When we implement a simple procedure with a
statement "select 1 from dual@remote_db
0