utl file - Replacement of fnd_file with utl_file for logging in plsql -


my package code contains fnd_file.put_line logging purpose. need replace utl_file.put_line minimum lines of code should write. there 100+ occurences of fnd_file.put_line in code 14 procedures. please explain difference between utl_file , fnd_file? , give me sample code well.

my question is:

can please explain if code on server how give directory location. include server details well. please clarify example.

ps: can see package part of concurrent programming.is utl_file in scope?

fnd_file.put_line, print string in output or log file, when run concurrent program.

fnd_file.put_line(fnd_file.output, 'message'); -- print in concurrent program output fnd_file.put_line(fnd_file.log, 'message'); -- print in concurrent program log 

utl_file.put_line going print string in writable file, need open in pl-sql.

example of using utl_file

v_chr_out_file       utl_file.file_type; v_chr_out_file :=             utl_file.fopen (<directory_path>,                             <file_name>,                             'w',                             32767); utl_file.put_line (v_chr_out_file, 'this written in file'); utl_file.fclose (v_chr_out_file); 

Comments

Popular posts from this blog

html - How to set bootstrap input responsive width? -

javascript - Highchart x and y axes data from json -

javascript - Get js console.log as python variable in QWebView pyqt -