SQL> DECLARE
  2  h1 number;
  3  errorvarchar varchar2(100):= 'ERROR';
  4  tryGetStatus number := 0;
  5  begin
  6  h1 := dbms_datapump.open (operation => 'IMPORT', job_mode => 'FULL', job_name => 'IMPORT_JOB_SQLDEV_73', version => 'COMPATIBLE');
  7  tryGetStatus := 1;
  8  dbms_datapump.set_parallel(handle => h1, degree => 1);
  9  dbms_datapump.add_file(handle => h1, filename => 'IMPORTtest2.LOG', directory => 'DATA_PUMP_DIR', filetype => 3);
 10  dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0);
 11  dbms_datapump.add_file(handle => h1, filename => 'ORAEU_COPIED.DMP', directory => 'DATA_PUMP_DIR', filetype => 1);
 12  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL\APT_SYS_DATA01.DBF') , value => UPPER('/rdsdbdata/db/ORAEU_A/datafile/APT_SYS_DATA01.DBF') );
 13  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL\APT_SYS_IDX01.DBF') , value => UPPER('/rdsdbdata/db/ORAEU_A/datafile/APT_SYS_IDX01.DBF') );
 14  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL\DATA_MART_DATA01.DBF') , value => UPPER('/rdsdbdata/db/ORAEU_A/datafile/DATA_MART_DATA01.DBF') );
 15  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL\DATA_MART_IDX01.DBF') , value => UPPER('/rdsdbdata/db/ORAEU_A/datafile/DATA_MART_IDX01.DBF') );
 16  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL/DATA_STORE_DATA01.DBF') , value => UPPER('/rdsdbdata/db/ORAEU_A/datafile/DATA_STORE_DATA01.DBF') );
 17  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL\DATA_STORE_IDX01.DBF') , value => UPPER('/rdsdbdata/db/ORAEU_A/datafile/DATA_STORE_IDX01.DBF') );
 18  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL\RNET2_DATA01.DBF') , value => UPPER('/rdsdbdata/db/ORAEU_A/datafile/RNET2_DATA01.DBF') );
 19  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL\RNET2_IDX01.DBF') , value => UPPER('/rdsdbdata/db/ORAEU_A/datafile/RNET2_IDX01.DBF') );
 20  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL\DATA_AMA_DATA01.DBF') , value => UPPER('/rdsdbdata/db/ORAEU_A/datafile/DATA_AMA_DATA01.DBF') );
 21  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL\DATA_AMA_IDX01.DBF') , value => UPPER('/rdsdbdata/db/ORAEU_A/datafile/DATA_AMA_IDX01.DBF') );
 22  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL\DATASERVICES_DATA01.DBF') , value => UPPER('/rdsdbdata/db/ORAEU_A/datafile/DATASERVICES_DATA01.DBF') );
 23  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL\DATASERVICES_IDX01.DBF') , value => UPPER('/rdsdbdata/db/ORAEU_A/datafile/DATASERVICES_IDX01.DBF') );
 24  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL\ARC_DATA01.DBF') , value => UPPER('/rdsdbdata/db/ORAEU_A/datafile/ARC_DATA01.DBF') );
 25  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL\MCSS_DATA01.DBF') , value => UPPER('/rdsdbdata/db/ORAEU_A/datafile/MCSS_DATA01.DBF') );
 26  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL\MCSS_IDX01.DBF') , value => UPPER('/rdsdbdata/db/ORAEU_A/datafile/MCSS_IDX01.DBF') );
 27  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL\IPAS_DATA01.DBF') , value => UPPER('/rdsdbdata/db/ORAEU_A/datafile/IPAS_DATA01.DBF') );
 28  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL\IPAS_IDX01.DBF') , value => UPPER('/rdsdbdata/db/ORAEU_A/datafile/IPAS_IDX01.DBF') );
 29  dbms_datapump.metadata_remap(handle => h1, name => 'REMAP_DATAFILE', old_value => UPPER('C:\ORACLE\ORADATA\ORCL\PFIZERCMS_DATA01.DBF') , value =>
 30  dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 1);
 31  dbms_datapump.set_parameter(handle => h1, name => 'DATA_ACCESS_METHOD', value => 'AUTOMATIC');
 32  dbms_datapump.set_parameter(handle => h1, name => 'REUSE_DATAFILES', value => 0);
 33  dbms_datapump.set_parameter(handle => h1, name => 'TABLE_EXISTS_ACTION', value => 'REPLACE');
 34  dbms_datapump.set_parameter(handle => h1, name => 'SKIP_UNUSABLE_INDEXES', value => 0);
 35  dbms_datapump.start_job(handle => h1, skip_current => 0, abort_step => 0);
 36  dbms_datapump.detach(handle => h1);
 37  errorvarchar := 'NO_ERROR';
 38  EXCEPTION
 39  WHEN OTHERS THEN
 40  BEGIN
 41  IF ((errorvarchar = 'ERROR')AND(tryGetStatus=1)) THEN
 42  DBMS_DATAPUMP.DETACH(h1);
 43  END IF;
 44  EXCEPTION ----> it causes error here
 45  WHEN OTHERS THEN
 46  NULL;
 47  END;
 48  RAISE;
 49  END;
 50  /
dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 1);
                                                                                 *
ERROR at line 30:
ORA-06550: line 30, column 82:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
. ( ) , * % & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like like2
like4 likec between || multiset member submultiset
The symbol ")" was substituted for ";" to continue.

SQL> DECLARE 
    h1           NUMBER; 
    errorvarchar VARCHAR2(100) := 'ERROR'; 
    trygetstatus NUMBER := 0; 
BEGIN 
    trygetstatus := 1; 

    errorvarchar := 'NO_ERROR'; 
EXCEPTION 
    WHEN OTHERS THEN 
      BEGIN 
          IF ( ( errorvarchar = 'ERROR' ) 
               AND ( trygetstatus = 1 ) ) THEN 
            dbms_datapump.Detach(h1); 
          END IF; 
      EXCEPTION ----> it causes error here 
          WHEN OTHERS THEN 
            NULL; 
      END; 

      RAISE; 
END; 

/   2    3    4    5    6    7    8    9   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24  

PL/SQL procedure successfully completed.

SQL>