DBMS_SCHEDULER PROBLEM!!!
orawissSep 15 2006 — edited Aug 10 2007Hi all,
I use DBMS_SCHEDULER to execute one SH program,
When i excecute my Procedure PL I have this error message :
ORA-27369: job of type EXECUTABLE failed with exit code: Operation not permitted STANDARD_ERROR="XY7_LOG: Permission denied"
My procedure is :
CREATE OR REPLACE PROCEDURE PROC_GET_WEB_PAGE
IS
p_rep VARCHAR2(400);
p_url VARCHAR2(400);
p_cookies param_get_file_converter.url_cookies%TYPE;
p_name_cookies param_get_file_converter.cookie_name%TYPE;
p_name_file_log param_get_file_converter.name_file_log%TYPE;
p_nom_fichier param_get_file_converter.file_name_converter%TYPE;
p_user_site param_get_file_converter.user_converter%TYPE;
p_pwd param_get_file_converter.pwd_converter%TYPE;
BEGIN
SELECT p.url_converter, p.rep_converter,p.url_cookies,p.cookie_name, p.name_file_log, p.file_name_converter , p.user_converter,p.pwd_converter
INTO p_url, p_rep, p_cookies, p_name_cookies, p_name_file_log, p_nom_fichier, p_user_site, p_pwd
FROM param_get_file_converter p;
DBMS_SCHEDULER.CREATE_JOB(
job_name=>'testjob3',
job_type=>'EXECUTABLE',
job_action=>'/tmp/wget_XY7.sh',
number_of_arguments => 7,
enabled => FALSE);
dbms_output.put_line('p_name_file_log'||p_name_file_log);
dbms_scheduler.set_job_argument_value('testjob3',1,p_name_file_log);
dbms_scheduler.set_job_argument_value('testjob3',2,p_name_cookies);
dbms_scheduler.set_job_argument_value('testjob3',3,p_user_site);
dbms_scheduler.set_job_argument_value('testjob3',4,p_pwd);
dbms_scheduler.set_job_argument_value('testjob3',5,p_cookies);
dbms_scheduler.set_job_argument_value('testjob3',6,p_rep||p_nom_fichier);
dbms_scheduler.set_job_argument_value('testjob3',7,p_url);
dbms_scheduler.enable('testjob3');
dbms_scheduler.run_job('testjob3');
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line(SQLERRM);
end;
and in my sh program i have :
#!/bin/bash
/usr/bin/wget -O $1 user-agent='Mozilla/5.0' keep-session-cookies save-cookies $2 post- data='USERNAME=$3PASSWORD=$4&next=%2F' $5
/usr/bin/wget -O $6 user- agent='Mozilla/5.0' load-cookies $2 --referer=$7
Thanks for ur Help