create or replace procedure mergerOrder(
v_ids in varchar2,
v_productCode in varchar2,
v_productCateCode in varchar2) is
type cur_type is ref cursor;
cur_policy cur_type;
rec_policy ecc_pln.order_detail2%rowtype;
sqlStr varchar2(500);
begin
sqlStr := 'select id ,order_number from ecc_pln.order_detail2 d where 1=1';
if v_ids is not null then
sqlStr := sqlStr || ' and d.id in( SELECT COLUMN_VALUE FROM TABLE(jomoo_oms.SPLIT('''||v_ids||''')))';
end if;
if v_productCode is not null then
sqlStr := sqlStr || ' and d.material_code=