Top "Utl-file" questions

Oracle PL/SQL UTL_FILE.PUT buffering

I'm writing a large file > 7MB from an Oracle stored procedure and the requirements are to have no line …

oracle plsql put fflush utl-file

How to output extended ascii characters using Oracle utl_file

I was writing files using l_file := utl_file.fopen('OUT', 'a.txt', 'w'); utl_file.put_line(l_file, …

oracle utl-file

UTL_FILE, UTL_FILE_DIR and DIRECTORY, how do they affect UTL_FILE.FREMOVE?

FREMOVE is failing with an error "ORA-29280: invalid directory path" It works fine when I add the path to the …

oracle oracle10g directory utl-file

beginner in oracle trying to read text file

I am a beginner in oracle. I have been trying to read text file and insert its data in utl_…

oracle plsql utl-file

How to generate .csv file from oracle table data?

I have generated a csv file using the below query, but all column data are coming in one column in …

plsql utl-file

How to create zip folder in plsql (Oracle)

I am creating a file in a directory which i am specifying. I want for each run a different folder …

oracle plsql utl-file