Writing on same file using Oracle

Question

How can i use same file (like ABC.txt) to write using UTL_FILE.

Currently what is happening is whenever i am trying to write on ABC.txt previous entry is getting deleted or replaced with latest entry. I want all the entries I have made be present. I am using Oracle 10g PL/SQL.

Szilard Barany · Accepted Answer · 2012-02-17 08:20:30Z

7

If I understood you well, you want to append new lines to an existing file (keeping existing content). In this case you need to open the file in append mode:

file_handle = utl_file.fopen( directory, 'file_name', 'a' );

That should be it.

answered Feb 17, 2012 at 8:20

Szilard Barany

1,1337 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Writing on same file using Oracle

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related