Re: Test data link in PL/SQL

Scott Hamlin wrote:

> I need to test if a remote system is accessible via a data link. Is there a
> way in PL/SQL to test if a data link is working? We have this code in place,
> which we copied from previous Google posts:
>
> select sysdate into vTest from dual_at_devl.world;
>
> But this does not seem to work - the procedure returns a more generic error
> message instead of the specific 'server down' message we would like. (The
> error is that the package is invalid, even though the package is valid when
> I view it in DBA Studio.)
>
> We are currently using Oracle 9i.
>
> Thank you for you help,
> Scott

Not posting the actual error message dooms you to receiving an inadequate response. There is nothing wrong with your test. If you don't like the message returned consider using PRAGMA EXCEPTION_INIT.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)