Re: Executing os-commands from with an procedure/function

In addition to Thomas Kyte's reply,

There was a C program which you can compile and use as an external procedure in the Jan/Feb edition of Oracle Magazine, http://www.oramag.com , from last year. It was written for Unix and does exactly what you want it to do!
The article was about Data Cartridges.

(ps If you get it compiled for Windows 95/98/NT, let me know *grin*)

Mark

In article <386F4415.5B97F8EA_at_pegit.se>, =?iso-8859-1?Q?Bj=F6rn=2D=C5ke?= Segrell <pinne_at_pegit.se> wrote:
> Hi,
> Oracle 8.0.5 on Solaris 2.6/RH Linux 5.2.
> I would like to execute some operating system commands (ie. mkdir,
> rm
> etc...) from within a stored procedure/function and get the return
> code
> of the outcome.
> But I haven't been able to find any documentation about packages
> that
> does that.
> The only thing i found was a an example-look-a-alike description
> for a
> deamon in Pro*C that listens
> on pipes (DBMS_PIPE-package), passing on whatever it gets from
> them to
> the os for execution.
> Is that the way it's done with Oracle ?
> Does someone have any experience of this
> /Regards

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!