From: anacedent@hotmail.com   
      
   dave@skillbuilders.com (Dave Anderson) wrote in   
   news:a0dc4048.0409070851.72c30c39@posting.google.com:   
      
   > Has anyone encountered this error when running a job using the 10g job   
   > scheduler?   
   >   
   > SQL> exec dbms_scheduler.run_job('daily_backup')   
   > BEGIN dbms_scheduler.run_job('daily_backup'); END;   
   >   
   > *   
   > ERROR at line 1:   
   > ORA-27369: job of type EXECUTABLE failed with exit code: Incorrect   
   > function.   
   > ORA-06512: at "SYS.DBMS_ISCHED", line 148   
   > ORA-06512: at "SYS.DBMS_SCHEDULER", line 374   
   > ORA-06512: at line 1   
   >   
   > This is a Windows 2000 server.  The job was successfully created:   
   >   
   > SQL> BEGIN   
   >   2  DBMS_SCHEDULER.CREATE_JOB (   
   >   3     job_name           =>  'daily_backup',   
   >   4     schedule_name      =>  'dave.backup_schedule',   
   >   5     job_type           =>  'executable',   
   >   6     job_action         =>  'C:\OracleScripts\10g\full_backup.bat',   
   >   7     enabled            =>  true,   
   >   8     comments           =>  'Daily full backup');   
   >   9  END;   
   >  10  /   
   >   
   > PL/SQL procedure successfully completed.   
   >   
   > I have configured external job support by starting the   
   > OracleJobScheduler[sid] and tested the bat file from OS prompt and   
   > from within SQL*Plus using HOST.   
   >   
   > thanks   
   > dave   
   >   
      
   IIRC, DBMS_SCHEDULER.CREATE_JOB  is a FUNCTION as the error message   
   indicates. If so, then why are you calling it as a procedure?   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)