Oracle-L: RE: Data Base Link

From: Kimberly Smith <ksmith2_at_myfirstlink.net>
Date: Sat, 20 Apr 2002 10:33:19 -0800
Message-ID: <F001.0044A440.20020420103319@fatcity.com>

You can trap individual errors messages in PL/SQL and then make decisions based on that. If Oracle or the listener is down its a specific error message. So you can setup your code to trap when those are returned and do what you want, whether it be display a custom message or whatever.

Look up PRAGMA EXCEPTION_INIT

-----Original Message-----
Sent: Saturday, April 20, 2002 2:43 AM
To: Multiple recipients of list ORACLE-L

Hi ,

Kindly help me to solve folowing problem.

I need to Update a Table in Another database using a Procedure thru Database Link.

The problem is other database or may be Listner is not always running when

User Runs the procedure.

Can I Check whether the Database/Listner is running or Not ?

TIA, Naba

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: N J Neog
INET: njneog_at_oil.asm.nic.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kimberly Smith
INET: ksmith2_at_myfirstlink.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------