Re: How to execute HOST command from strored procedure

In Article<Pine.SOL.3.91.960313072103.11026A-100000_at_freenet.grfn.org>, <ragun_at_grfn.org> write:
> Path: news.NetVision.net.il!psinntp!psinntp!psinntp!howland.reston.ans.net!newsfeed.internetmci.com!newsxfer2.itd.umich.edu!newsxfer.itd.umich.edu!gumby!newsserv.grfn.org!freenet.grfn.org!ragun
> From: Ragun Chandra <ragun_at_grfn.org>
> Newsgroups: comp.databases.oracle
> Subject: How to execute HOST command from strored procedure
> Date: Wed, 13 Mar 1996 07:22:57 -0500
> Organization: Grand Rapids Free-Net
> Lines: 13
> Message-ID: <Pine.SOL.3.91.960313072103.11026A-100000_at_freenet.grfn.org>
> NNTP-Posting-Host: freenet.grfn.org
> Mime-Version: 1.0
> Content-Type: TEXT/PLAIN; charset=US-ASCII
>
> I wanted to execute a host command from stored procedure.
> I tried using host(command) inside a stored procedure, it's giving compilation
> error. Help me how I can go about this.
>
> Regards
> Ragun Chandra
>
>
> ====================================
> Mail me at
> ragun_at_freenet.grfn.org
> ====================================
>

of course you can't use host, think of client-sever and than think "what host ?"

one way to do it is to use dbms_pipe build-in package Write a Pro*C program that waits on that pipe and send the "start" message in the pipe from your stored procedure

good luck on that,

                        Yoram Z.