How can I send the output to a disk file from a pl/sql program?

[castlerock]

You can either use spool or UTLFILE to write into the disk

IN init.ora file, set the parameter as
UTL_FILE_DIR='E:\utlfile_dir'

Create a folder utlfile_dir in the E Drive and share the folder


Then in your pl/sql block user
lv_utldir=''E:\utlfile_dir';
lv_filename='outputfilename.txt' ;
lv_filehandler:=UTL_FILE.FILE_TYPE;


lv_filehandler :=UTL_FILE.FOPEN(lv_utldir,lv_filename,'W');

UTL_FILE.PUT_LINE(' .............')

UTL_FILE.FFLUSH(lv_filehandler);

UTL_FILE.FCLOSE(lv_filehandler);


You can save the file in .csv extension,.doc etc.

Hope this one helps you