Re: pl/sql and os

From: Mark D Powell <mark.powellNOmaSPAM_at_eds.com.invalid>
Date: 2000/07/06
Message-ID: <272406c0.ea4786c2@usw-ex0104-032.remarq.com>#1/1

To the best of my knowledge there is no native way to issue an OS command from pl/sql. You can use an external procedure or a combination of dbms_pipe to a daemon type program that does the OS level processing.

From sqlplus you can use the host command to pass single line commands to the OS which can be OS scripts, commands, or programs in the search path. The host command can be abbreviated as ! on most UNIX systems:
!my_shell_script
or
host my_shell_script

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Thu Jul 06 2000 - 00:00:00 CDT