Total Pageviews

Monday, 10 April 2023

EBS : Oracle PLSQL : File Handling using UTL

 File Handling using UTL in Oracle PLSQL


  • How to check file avilabilty in the directory

UTL_FILE.fgetattr(v_dir_path, v_file_name, v_exists, v_f_len, v_bsize);

  • remove the existing file from the directory 

 UTL_FILE.fremove (v_location,  v_file_name )

No comments:

Post a Comment

FUSION : BIP Reports Multiple Parameter Selection

How to make parameter multiple value selection in FUSION BIP REPORT    AND ( least(:P_PR_NUMBER) is null   or   prha.requisition_header_id i...