Re: pl/sql & shell commands

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 1996/11/23
Message-ID: <32977ef0.1302022_at_dcsun4>#1/1

On Fri, 22 Nov 1996 02:05:46 GMT, nop24893_at_mail.telepac.pt (Bruno Martins) wrote:

>Does anybody know how can i execute a system command from a pl/sql
>procedure?
>I've tried the ! and host command they they don´t seem to work. They
>just work in the sqlplus environment.
>
>thanks in advance.
>
> Bruno Martins

You can't do it directly. You can however do it using database pipes. For a white paper and utilities that make doing this trivial, goto http://govt.us.oracle.com and follow the link to tech center/downloadable utilities. You'll be looking for PLEX.

Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com                          

http://govt.us.oracle.com

• Check out Oracle Governments web site! ----- Follow the link to "Tech Center" and then downloadable Utilities for some free software...

  ---

statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Sat Nov 23 1996 - 00:00:00 CET