Re: Execute shell script unix from stored procedure

There is a way to do it and it is not all that simple and not sure if this solves your requirement. Its skeleton logic goes as follows

1. Write a PRO*C program to be run as a daemon server process which has calls to oracle supplied DBMS_PIPE package (which can send and receive messages between two Oracle sessions. the daemon process has to be in msg read mode to serve the incoming requests)
2. Call the same DBMS_PIPE package from a stored procedure with appropriate parameters such as the pathname of the script and if the script requires any parameters etc.,

Hope this helps.
Nanduri

> Hi.
> How can I execute a shell script unix from a stored procedure?
>
> --
> <><><><><><><><><><><><><><><>
>
> Orsano Alessandro
>
> Tel: 06/55271424
> 0347/6258763
>
> e-mail: orsano_at_dia.uniroma3.it
> orsano_at_hotmail.com
>
> <><><><><><><><><><><><><><><>
>
> --------------DCEC1416EB7573B134259A88
> Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for orsano
> Content-Disposition: attachment; filename="vcard.vcf"
>
> begin: vcard
> fn: orsano
> n: ;orsano
> email;internet: orsano_at_inf.uniroma3.it
> x-mozilla-cpt: ;0
> x-mozilla-html: FALSE
> end: vcard
>
> --------------DCEC1416EB7573B134259A88--
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 16 1998 - 14:35:50 CDT