I have question on the remote database using db_link.
If the select statement from the remote database is cannot select due to the db link is down.
Is it possble I can Trap the error message just like the select local object does.
FROM obj; <<- This is able to trap if this is local object.
WHEN OTHERS THEN
If the obj is remote database object, error couldn't trap in the WHEN EXCEPTION....
The error will display asa following
ORA-02068: following severe error from ORA8I
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Any idea ?