Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Executing Operating system commands from within a stored procedure
It's about time the answer to this question makes it to a FAQ.
It shows up every few days :)
Basic options
Oracle 7.3.4:
Use the dbms_pipe package or use PLEX downloadable from the Oracle
Government web-site
Oracle 8 and higher: use the external procedure mechanism. Just write a DLL
or whatever is available in Unix,
modify your listener.ora to work with the procedure, and that's it.
Hth,
Sybrand Bakker, Oracle DBA
Andrew Hendrickson wrote in message ...
>Hey all,
>
>I am looking for a way to execute a unix command from within a stored
>procedure. I don't need anything that gets produced by the command, I just
>need to be able to execute it.
>
>Any ideas?
>
>Thanks in advance.
>Andy
>
>
Received on Sat Jun 19 1999 - 03:50:44 CDT