calling unix

[kris123]

Hi!


How to call unix commands from PL/SQL scripts


thanks

[rotem_fo]

Hi,
use DBMS_PIPE

[jmodic]

Well, if you are on 8.* it would be much easier (as compared to DBMS_PIPE) to use external procedures through listener's EXTPROC fascility. You should write a simple C program that executes OS command, compile and link it into .so or .dll and register it within database as database library.

If you are on 8.1.*, you can write a simple java class that executes OS command, register it within database and run it directly from the database - you don't even need to configure EXTPROC in listener in this case.