Re: How to properly manage listener on a DBMS_PIPE

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Tue, 02 Feb 1999 17:37:24 +0800
Message-ID: <36B6C754.67B2@bhp.com.au>

Rainer Leidner wrote:
>
> I use DBMS_PIPE to send messages to an external listener/daemon.
> I experience occasional problems to start the listener or to keep it
> running.
>
> What is a good method to make sure that the listener is always up and
> running?
>
> This is in Oracle 7.3.4 on Solaris 2.5.1.
>
> Tnx
>
> Rainer

A quick hack in the unix world

script: listener.sh

#!/bin/sh
sqlplus blah/blah <<EOF >/tmp/error_output declare
  .. vars ..
begin
  x := dbms_pipe....
end;
EOF
#
mail support_staff_at_blah.blah.com < /tmp/error_output exec listener.sh

Cheers

--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..." Received on Tue Feb 02 1999 - 03:37:24 CST