declare
v_sql varchar2(5000);
user_id varchar2(20);
offer_id number(20);
bill_id number(20);
offer_inst_id number(20);
region_code varchar2(3);
begin
region_code:=‘240’;
bill_id :=‘187****0000’;
offer_id :=‘111130501100’;
/user_id := ‘100079432826’;
offer_inst_id :=‘30000535505378’;/
/select user_id into user_id from so1.ins_user_region_cod where bill_id = bill_id;
select offer_inst_id into offer_inst_id from so1.ins_offer_region_cod where user_id=user_id and offer_id=offer_i ;/

v_sql:=‘select user_id into user_id from so1.ins_user_’||region_code||’ where bill_id = ‘||bill_id||’ ‘;
execute immediate v_sql;
v_sql:=‘select offer_inst_id into offer_inst_id from so1.ins_offer_’||region_code||’ where user_id=’||user_id||’ and offer_id=’||offer_id||’ ‘;
execute immediate v_sql;
v_sql:=‘update so1.ins_offer_’||region_code||’ set expire_date = sysdate where user_id=’||user_id||’ and offer_inst_id = ‘||offer_inst_id||’’;

   execute immediate v_sql;
复制

commit;

end;