2 Replies Latest reply: Sep 2, 2013 7:59 AM by Ahmed Alsaied RSS

    Open scanner using DBMS_SCHEDULER in oracle apex

    Ahmed Alsaied

      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