SQL & PL/SQL

Hi,

I am trying to call a shell script from a procedure. when i execute the procedure the shell script is not being called and there is no exception raised.
The test.sh has all the execute permissions. when i run the shell script separately it works fine.
The shell script is having execute permissions and the user is having create job and create rjob grants.

Could you please let me know where am i going wrong.
Thanks

CREATE OR REPLACE PROCEDURE DBREPORT.PRC_GATE
 
begin
 
DBMS_SCHEDULER.create_program (
   program_name => 'gate1',
   program_type => 'EXECUTABLE',
   program_action => '/home/cobr_sftp/var/download/test.sh',
   number_of_arguments => 0,
  enabled => TRUE,
   comments => 'CREATE_PROGRAM test using a schell script.');
 
exception when others then
     dbms_output.put_line(sqlcode||sqlerrm);
     
end;

Edited by: user11942774 on Sep 21, 2012 10:44 PM

Edited by: user11942774 on Sep 23, 2012 5:57 AM