Re: Host commands on server via JDBC link

I suggest you have a look at the external proc method to call a lame c function that just exec ur input parameter.

HTH,
Vinayak

"Bastiaan Schaap" <-nospam-bschaap_at_desyde.nl> wrote in message news:7PhV6.1$TO1.257_at_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 - 22:18:53 CDT