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)
