Executing a shell script from a PL / SQL Block

Shell Programming and Scripting
1

Hi,

I need to call a shell script present on solaris server from within a PL / SQL block.
Kindly suggest..

Thanks
Sudhir

2

You can define an external routine and use the dbms_pipe package to call a UNIX shell script.
Here is an example of a invoking a shell script from PL/SQL using dbms_scheduler:

DBMS\_SCHEDULER.create_program

(
program_name => 'sch_program',
program_type => 'EXECUTABLE',
program_action => '/home/nobody/input/test_job.sh',
number_of_arguments => 0,
enabled => TRUE,
comments => 'Test Program'
);
end;
/

Execute a shell script from a PL/SQL procedure

1 Like