iv_filepath := '/gboss/just28/writefiles/batdeal';
iv_filename := iv_rec_trade_batdeal.subscribe_id||'.txt';
iv_filehandle := sys.UTL_FILE.FOPEN(iv_filepath,iv_filename,'a',5000);
iv_queryresult := iv_queryresult||','||iv_cust_name||','||iv_brand||','||iv_product_name||','||iv_all_state_name||','||iv_all_discnt_name||','||iv_accountFee;
UTL_FILE.PUT_LINE(iv_filehandle,iv_queryresult);
sys.UTL_FILE.FCLOSE(iv_filehandle);