Hello.
The code attached on this post opens a cursor that load 99 dblinks from different remote databases of different version.
This captures information from those databases and stores locally on a central database (11.2.0.4.0 version) on different tables.
The problem that I have is that when a database is deleted, the dblink for that database show me "ora-3150 end of file on communication channel" error and that is correct.
But it does not go trough the exception I have created, the cursor get closed and does not continue with the cycle.
The exception I have created insert data error on DBMONITOR.DBMONITOR_LOG_ERROR_TABLE in order to trap the error (You will be able to see the entire code on the attached file)
This is the exception :
exception
when others then
INSERT INTO DBMONITOR.DBMONITOR_LOG_ERROR_TABLE (NOMBRE_DBLINK, message, info,FECHA_ERROR,TIPO_PROCEDURE) VALUES(var, SUBSTR(DBMS_UTILITY.FORMAT_ERROR_STACK, 1, 200),'ERROR DE CONEXION',SYSDATE,'CAPACITY');
commit;
end;
Could you please help me about how could i trap this exeption ?
Thanks.
Juan.