Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: TNSPING from PL/SQL?

Re: TNSPING from PL/SQL?

From: Papa Piquillo <oraclejva_at_yahoo.es>
Date: 21 Dec 2005 09:57:15 -0800
Message-ID: <1135187835.291977.181980@g14g2000cwa.googlegroups.com>


I think i will try to connect to the dblink first and control the error with exceptions.
Something like:

select sysdate into dummy_date_var
from dual_at_dblinkx;

If this sentece works, dblinkx points to an active database. Received on Wed Dec 21 2005 - 11:57:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US