Re: Host commands on server via JDBC link

From: Bastiaan Schaap <-nospam-bschaap_at_desyde.nl>
Date: Tue, 12 Jun 2001 07:36:54 +0200
Message-ID: <7PhV6.1$TO1.257@psinet-eu-nl>

Hello Filip,

I don't know if it is the best way to do it, but you *can* write a stored procedure that runs shell scripts by using dbms_pipe. Although this also requires that you write a little deamon program in pro*C, that will 'listen' to a message queue in which your stored procedure writes messages. A long time ago when we didn't have Oracle 8i, we used this method to send email directly from the Oracle 7.3 database. I remember there were excellent examples in the Oracle 7.3 Developers guide.

If there aren't any other good suggestions, try to find some good info on the dbms_pipe sys-package. I remember that with the examples from the developer's guide from Oracle I had a little email-deamon functioning in 3 hrs. I believe for just executing a shell script, there are ready made examples....

HTH, Bastiaan Schaap

---

"Happiness is a belt-fed weapon" Received on Tue Jun 12 2001 - 00:36:54 CDT