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: checking a database link in PL/SQL

Re: checking a database link in PL/SQL

From: Andreas Ballenthin <ballenth_at_gmx.de>
Date: Thu, 06 Dec 2001 17:35:42 +0100
Message-ID: <3C0F9E5E.B5ED0679@gmx.de> 





Hi,



try to select dummy from dual_at_db_link.



If select is ok, then insert into remote table,
if exception occurs, insert into local table.



cu


Andreas
Received on Thu Dec 06 2001 - 10:35:42 CST












Original text of this message













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