Re: How can I open a socket in a stored procedure?

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Sat, 30 Dec 2000 16:14:03 GMT
Message-ID: <fRn36.206062$U46.6321897@news1.sttls1.wa.home.com>

You could use DBMS_pipe. Sure you could open a socked in a Java stored procedure (probably), but how would you know the IP address of the client? Or you could use the dbms_alert mechanism. Jim

--
<miki_at_sheernetworks.com> wrote in message
news:92ks1u$bbh$1_at_nnrp1.deja.com...


> I would like to know what is the best way to sent an Oracle client a

 message


> from a stored procedure on the run. The idea is that when a stored

 procedure


> is called it could send the caller a message within its run. Do I need to

> load a java stored procedure into the database which opens a socket to

 send a


> message?. Does it possible to open a socket to the outside client from the

> java stored procedure?

>

>

> Sent via Deja.com

> http://www.deja.com/

Received on Sat Dec 30 2000 - 10:14:03 CST