native sql里模糊查询

       CONCATENATE  '%' tmp_vbap-tmp_vbeln '%' INTO l_pattern_order.
*          CONCATENATE tmp_vbap-koa_id '%' INTO l_pattern_id.

*          l_pattern_order不能为'%|0000100081|%'，应该为如下形式，%|0000100081|%
      try.

          EXEC SQL PERFORMING collect_data_b.

            select utl_raw.cast_to_raw(fl.node_name),fa.sap_number,fl.koa_flow_id,fa.order_type
            into :wa_vbap-node_name,:wa_vbap-tmp_vbeln,:wa_vbap-koa_id,:wa_vbap-order_type
            from  ecc_oc.koa_log fl, ecc_oc.koa_header_log fa
            where
            fa.order_type = :'F' and
            fa.SAP_NUMBER   like :l_pattern_order and
            fa.koa_flow_type    = :'A'     AND
            fl.koa_flow_id   = fa.koa_flow_id    and
            fl.koa_flow_id   = :tmp_vbap-koa_id  and
            fl.node_name     = utl_raw.cast_to_varchar2(:l_hex_node_name) and
            fl.approval_action  = utl_raw.cast_to_varchar2(:l_hex_approval_action)

          ENDEXEC.

        catch cx_sy_native_sql_error into l_obj_sqldb.
          call method l_obj_sqldb->get_text
            RECEIVING
              result = l_error_text.

      endtry.

 

*& 去除前导0

   trim(leading 0 from :l_pr_date)