My Oracle Support Banner

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

Last updated on JANUARY 08, 2020

Applies to:

Oracle Forms - Version 10.1.2.0.2 to 10.1.2.0.2 [Release Oracle10g]
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

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