Hi All,
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.

BEGIN
SELECT xxx
FROM obj; <<- This is able to trap if this is local object.

EXCEPTION
WHEN OTHERS THEN
do_something_for_me;
END;

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 ?

Thanks.

Regards,
ckwan