Re: -- how to check if database link is active
From: Jusung Yang <JusungYang_at_yahoo.com>
Date: 11 Jul 2003 09:26:10 -0700
Message-ID: <130ba93a.0307110826.55717463_at_posting.google.com>
Date: 11 Jul 2003 09:26:10 -0700
Message-ID: <130ba93a.0307110826.55717463_at_posting.google.com>
avanrossem_at_hotmail.com (Andre) wrote in message news:<4d32d1be.0307102214.74ab96e5_at_posting.google.com>...
> Hello all,
>
> How can I check (within a pl/sql-procedure) if a database link is active or not??
> I am using oracle 8.1.7
>
> Thanks and regards,
> Andre van Rossem
Look up v_$dblink. Make sure you can select from it within the stored procedure though.
- Jusung yang