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

A copy of this was sent to Björn-Åke Segrell <pinne_at_pegit.se> (if that email address didn't require changing) On Sun, 02 Jan 2000 12:27:01 +0000, you 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 ?
>

that is one way but in 8.0.5 you should read about external procedures -- a method for writing stored procedures in C. See the plsql manual for some more info.

>Does someone have any experience of this
>
>/Regards

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun Jan 02 2000 - 10:13:42 CST