Re: Test data link in PL/SQL

"Scott Hamlin" <srxyz2003_at_go.com> wrote in message news:<btjln1$808ao$1_at_ID-147295.news.uni-berlin.de>...
> 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

Try this google: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&th=a3ca3b4dae128cf5&rnum=5

jg

--
@home.com is bogus.
Black hole sun, won't you come, won't you come.