Using PL/SQL in the etl scenario

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Using PL/SQL in the etl scenario</name>
     <script>plsql</script>
     <driver>com.toolsverse.etl.driver.oracle.OracleDriver</driver>
     <allow>EXTRACT_LOAD</allow>
     <sources>
          <source>
               <name>employee</name>
               <extract>
                    <sql>select EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX from employee</sql>
               </extract>
          </source>

</sources>
     <destinations>
          <destination>
               <name>employee</name>
               <tablename>employee_plsql</tablename>
               <metadata>true</metadata>
               <load>
                   <variables>
                       <EMPNO /> 
                        
                       <TEST type="DATE" sql="{TEST}:= sysdate;" /> 
                       <FIRSTNME />
                       <MIDINIT />
                       <LASTNAME />
                       <SEX />
                   </variables>
                   <sql>
                       if {SEX} = 'M' then
                           insert into employee_plsql (EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX)
                           values ({EMPNO},{FIRSTNME},{MIDINIT},{LASTNAME},{TEST},'M');
                       end if;
                   </sql>
               </load>
          </destination>

</destinations>
</scenario>