When you open a file in write-only mode ( PLVfile.c_write ) or append mode ( PLVfile.c_append ), you usually then want to write or put a line into that file. To do this, you will call the PLVfile.put_line procedure, whose header is shown below:
PROCEDURE put_line (file_in IN UTL_FILE.FILE_TYPE, line_in IN VARCHAR2);
Notice that you must provide a file handle to put a line in a file. You must, therefore, have already opened the file using one of the function versions of fopen .
PROCEDURE append_line (file_in IN VARCHAR2, line_in IN VARCHAR2);
You provide the file and the line you want appended on the end of the file. PLVfile automatically opens the file in append mode, writes the line using put_line , and then closes the file.
Copyright (c) 2000 O'Reilly & Associates. All rights reserved.