This discussion is archived
2 Replies Latest reply: Sep 2, 2013 5:59 AM by Ahmed Alsaied RSS

Open scanner using DBMS_SCHEDULER in oracle apex

Ahmed Alsaied Newbie
Currently Being Moderated

Hi Expert ,

please i am try to open executable file (scanner) from apex , i use  DBMS_SCHEDULER in database xe 11g

this steps that i try :-

 

CONN SYS/SYS@XE AS SYSDBA 
GRANT SCHEDULER_ADMIN TO TEST ;
CONN TEST/1@XE
begin
dbms_scheduler.create_job(   job_name      => 'JOB1'
  , job_type      => 'EXECUTABLE'
  , job_action    => 'C:\Windows\System32\wiaacmgr.exe');
end;

 

after that i create html page in apex and add button create on this button i make dynamic action execute plsql code

 

begin
  dbms_scheduler.enable('job1');
 dbms_scheduler.run_job('job1');
 dbms_scheduler.disable('job1'); 
end;

 

when i click on the button display this error :-

 

AJAX call returned server error ORA-27476: "TEST.JOB1" does not exist for Execute PL/SQL Code..

 

i need help

 

Regards

Ahmed

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points