iBatis CLOB BLOB (예제)

<resultMap id="COMMON_SEARCH_REPORT_INFO" class="java.util.HashMap">
  <result property="COMP_LOCAL_NM" column="COMP_LOCAL_NM" />
  <result property="COMP_FOREIGN_NM" column="COMP_FOREIGN_NM" />
  <result property="COMP_FOREIGN_ADDR_1" column="COMP_FOREIGN_ADDR_1" />  
  <result property="COMP_FOREIGN_ADDR_2" column="COMP_FOREIGN_ADDR_2" />
  <result property="COMP_TEL_NO" column="COMP_TEL_NO" />
  <result property="COMP_FAX_NO" column="COMP_FAX_NO" />
  <result property="COMP_EMAIL" column="COMP_EMAIL" />
  <result property="COMP_CI" column="COMP_CI" jdbcType="BLOB" javaType="[B"/>    
 </resultMap>
-- CLOB 인경우 String  
<result property="COMP_CI" column="COMP_CI" jdbcType="CLOB" javaType="String"/>    

<select id="COMMON_SEARCH_REPORT_INFO" resultClass="java.util.HashMap" resultMap='COMMON_SEARCH_REPORT_INFO'>
  SELECT (SELECT CHR_VAL
                   FROM GFIS.TFIS_B_CFG
                  WHERE CORP_ID = #CORP_ID#
                    AND JOB_CCD = #SHPNG_TCD#
                    AND FIELD_CD LIKE 'COMP_LOCAL_NM'
                 <isNotEmpty property="BRANCH_CD">
                     || '_' || #BRANCH_CD#
                 </isNotEmpty>
                     || '%'
             AND DEL_YN = 'N')
             AS COMP_LOCAL_NM
       , (SELECT CHR_VAL
                   FROM GFIS.TFIS_B_CFG
                  WHERE CORP_ID = #CORP_ID#
                    AND JOB_CCD = #SHPNG_TCD#
                    AND FIELD_CD LIKE 'COMP_FOREIGN_NM'
                 <isNotEmpty property="BRANCH_CD">
                     || '_' || #BRANCH_CD#
                 </isNotEmpty>
                     || '%'
             AND DEL_YN = 'N')
             AS COMP_FOREIGN_NM
       , (SELECT CHR_VAL
                   FROM GFIS.TFIS_B_CFG
                  WHERE CORP_ID = #CORP_ID#
                    AND JOB_CCD = #SHPNG_TCD#
                    AND FIELD_CD LIKE 'COMP_FOREIGN_ADDR_1'
                 <isNotEmpty property="BRANCH_CD">
                     || '_' || #BRANCH_CD#
                 </isNotEmpty>
                     || '%'
             AND DEL_YN = 'N')
             AS COMP_FOREIGN_ADDR_1
       , (SELECT CHR_VAL
                   FROM GFIS.TFIS_B_CFG
                  WHERE CORP_ID = #CORP_ID#
                    AND JOB_CCD = #SHPNG_TCD#
                    AND FIELD_CD LIKE 'COMP_FOREIGN_ADDR_2'
                 <isNotEmpty property="BRANCH_CD">
                     || '_' || #BRANCH_CD#
                 </isNotEmpty>
                     || '%'
             AND DEL_YN = 'N')
             AS COMP_FOREIGN_ADDR_2
       , (SELECT CHR_VAL
                   FROM GFIS.TFIS_B_CFG
                  WHERE CORP_ID = #CORP_ID#
                    AND JOB_CCD = #SHPNG_TCD#
                    AND FIELD_CD LIKE 'COMP_TEL_NO'
                 <isNotEmpty property="BRANCH_CD">
                     || '_' || #BRANCH_CD#
                 </isNotEmpty>
                     || '%'
             AND DEL_YN = 'N')
             AS COMP_TEL_NO
       , (SELECT CHR_VAL
                   FROM GFIS.TFIS_B_CFG
                  WHERE CORP_ID = #CORP_ID#
                    AND JOB_CCD = #SHPNG_TCD#
                    AND FIELD_CD LIKE 'COMP_FAX_NO'
                 <isNotEmpty property="BRANCH_CD">
                     || '_' || #BRANCH_CD#
                 </isNotEmpty>
                     || '%'
             AND DEL_YN = 'N')
             AS COMP_FAX_NO
       , (SELECT CHR_VAL
                   FROM GFIS.TFIS_B_CFG
                  WHERE CORP_ID = #CORP_ID#
                    AND JOB_CCD = #SHPNG_TCD#
                    AND FIELD_CD LIKE 'COMP_EMAIL'
                 <isNotEmpty property="BRANCH_CD">
                     || '_' || #BRANCH_CD#
                 </isNotEmpty>
                     || '%'
             AND DEL_YN = 'N')
             AS COMP_EMAIL
       , (SELECT IMG
            FROM GCOM.TADM_IMG
           WHERE IMG_CD = (SELECT CHR_VAL
                             FROM GFIS.TFIS_B_CFG
                            WHERE CORP_ID = #CORP_ID#
                              AND JOB_CCD = #SHPNG_TCD#
                              AND FIELD_CD LIKE 'COMP_CI'
                                  <isNotEmpty property="BRANCH_CD">
                                      || '_' || #BRANCH_CD#
                                  </isNotEmpty>
                                      || '%'
                              AND DEL_YN = 'N'))
             AS COMP_CI
    FROM DUAL    
 </select>