How to Run Unix Command inside an Oracle stored Procedure

[dpraharaj]

Hi,


Can any one tell how to run Unix Commands inside a stored Procedure. Basically I want to take a list of files in a Unix system directory, and do some activieties on that. So I want to call unix commands, inside the stored procedure.


Thanks.


Dillip

[santoshym]

Hi

Here is a link which will help you

http://www.orafaq.com/scripts/c_src/extproc.txt

Regards,

Santosh

[dooge]

Try the link:

http://www-rohan.sdsu.edu/doc/oracle...ocs.htm#437850

It links to chapter 10 of the pl/sql user's guide - External Procedures.

dooge.

[afshin]

Hi

This is from the GURU
http://www.oracle-base.com/Articles/...sFromPLSQL.asp



Cheers
Afshin