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