DECLARE
  ind NUMBER;              -- Loop index
  JobHandle NUMBER;
  job_state VARCHAR2( 30 );  -- To keep track of job state
  le ku$_LogEntry;         -- For WIP and error messages
  js ku$_JobStatus;        -- The job status from get_status
  sts ku$_Status;          -- The status object returned by get_status
  ERROR NUMBER;
BEGIN
  BEGIN
    JobHandle := SYS.DBMS_DATAPUMP.ATTACH(job_name=>'SYS_EXPORT_FULL_04', job_owner=>'SYSTEM');
    ERROR :=  0 ;
  EXCEPTION
    WHEN OTHERS THEN
      ERROR :=  1 ;
      DBMS_OUTPUT.put_line('ERROR');
      dbms_datapump.get_status(NULL,
        dbms_datapump.ku$_status_job_error +
        dbms_datapump.ku$_status_job_status +
        dbms_datapump.ku$_status_wip, 0 ,job_state,sts);
      js := sts.job_status;
      DBMS_OUTPUT.put_line(job_state);
      if (bitand(sts.mask,dbms_datapump.ku$_status_wip) !=  0 ) then
        le := sts.wip;
      elsif (bitand(sts.mask,dbms_datapump.ku$_status_job_error) !=  0 ) then
        le := sts.error;
      else
        le := null;
      end if;
      if le is not null then
        ind := le.FIRST;
        while ind is not null loop
          dbms_output.put_line(le(ind).LogText);
          ind := le.NEXT(ind);
        end loop;
      end if;
  END;  
--  IF ERROR = 0 THEN
    SYS.DBMS_DATAPUMP.STOP_JOB(JobHandle,  1 ,  0 );
    SYS.DBMS_DATAPUMP.detach(JobHandle);
--  END IF;  
END;
/

ERROR

ORA- 39002 : недопустимая операция
ORA- 39068 : недопустимые данные главной таблицы в строке с PROCESS_ORDER=- 59 
ORA- 39150 : неверное время flashback
ORA- 00907 : отсутствует правая скобка