DBMS_SCHEDULER.CREATE_JOB (
   job_name           =>  :P9_JOB_NAME,
   job_type           =>  :P9_JOB_TYPE,
   job_action         =>  :P9_JOB_ACTION,
--   job_action         =>  replace(:P9_JOB_ACTION,chr(13)||chr(10),chr(10)),
   start_date         =>  :P9_JOB_START_DATE,
   end_date         =>  :P9_JOB_END_DATE,
   repeat_interval    =>  'FREQ=MINUTELY;INTERVAL=2', 
   enabled            =>  TRUE,
   comments           =>  :P9_JOB_COMMENT);