ORACLE写文件

    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);