NO RECORDS ARE INSERTED INTO A CLOSED CLIENT_TEXT_IO FILE: File Is Empty (Doc ID 390289.1)

Last updated on OCTOBER 09, 2023

Applies to:

Symptoms

Using code that opens, writes to and closes some textfile with CLIENT_TEXT_IO.
But the file created turns out to be empty: its size is 0. Opening the file in Notepad or Wordpad shows that it contains nothing.
For example, some code similar to the following has been used. (It also creates a file on the Application Server side and loads it down to the client, but this is somewhat independent of the issue.)

PROCEDURE WRITE_TXT_FILE IS

...parameter/variable declaration...

BEGIN
file_s := text_io.fopen(t_file_server, 'w');
file_c := client_text_io.fopen(t_file_client, 'w');

for index in 1..10
loop
text_io.put_line(file_s,line||index);
client_text_io.put_line(file_c,line||index);
end loop;
text_io.fclose(file_s);
client_text_io.fclose(file_c);
-- Note: The line below uses the webutil_file_transfer functionality
download_file(file_server , file_dload);
exit_form;
END;

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.