Oracle Extract using slplus and Load using sql*loader

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Oracle Extract using slplus and Load using sql*loader</name>
     <script>oracle_sql_loader</script>
     <driver>com.toolsverse.etl.driver.oracle.OracleDriver</driver>
     <allow>EXTRACT_LOAD</allow>
     <variables>
        <NAME label="Property Name:" value = "name" />
     </variables>
     <tasks>
          
          <task>
               <name>drop_staging_table</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <sql>
                   DROP TABLE config_property_stage;
               </sql>
               <onexception action="ignore"/>
          </task>

<task>
               <name>create_staging_table</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <sql>
                   create TABLE config_property_stage
                   (
                     CONFIG_PROPERTY_NUM	NUMBER(18),
                     NAME	VARCHAR2(255),
                     DESCRIPTION	VARCHAR2(255)
                   );
               </sql>
          </task>

<task>
               <name>config_property_extract</name>
               <connection>source</connection>
               <class>com.toolsverse.etl.core.task.oracle.OracleExtractTask</class>
               <sql>
                   select CONFIG_PROPERTY_NUM || '|' ||
                          NAME || '|' ||
                          DESCRIPTION
                   from config_property
                   where upper(name) like upper('%{NAME}%')
               </sql>
          </task>

<task>
               <name>load</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.oracle.OracleLoadTask</class>
               <sql>
                       LOAD DATA
                       INFILE '{DATA_FOLDER}config_property_extract.dat'
                       APPEND INTO TABLE config_property_stage
                       FIELDS TERMINATED BY "|"
                       trailing nullcols
                       (
                          CONFIG_PROPERTY_NUM,
                          NAME,
                          DESCRIPTION
                       )
               </sql>
          </task>
          
     </tasks>
     
     <destinations>
          <destination>
               <name>cfg_props</name>
               <metadata>true</metadata>
               <cursor table="config_property_stage" onfinish="drop" />
          </destination>
     </destinations>
</scenario>