declare
  v_job_no   number;
begin
  dbms_job.submit( v_job_no,
DECLARE
extrac_file_name varchar2(27);
StartDate date;
EndDate date;

BEGIN

select ''EXTR_''||to_char(trunc(add_months(sysdate, -1), ''MM''),''mmyy'')||''.txt'' into  extrac_file_name from dual;
select to_char(trunc(add_months(sysdate, -1), ''MM''),''dd-Mon-yyyy'') into StartDate from dual;
select to_char(trunc(sysdate, ''MM'') - 1,''dd-Mon-yyyy'') into EndDate from dual;

  ops$asy.EUTR_CSV(TO_DATE(StartDate,''dd-Mon-yyyy''),TO_DATE(EndDate,''dd-Mon-yyyy''),extrac_file_name );

EXCEPTION
WHEN OTHERS THEN
  dbms_output.put_line(SubStr(''Error ''||TO_CHAR(SQLCODE)||'': ''||SQLERRM, 1, 255));
RAISE;
END;
, TRUNC(LAST_DAY(SYSDATE) + 1), 'TRUNC(LAST_DAY(SYSDATE) + 1)');
  commit;
end;
/