PUT_LINE

The PUT_LINE procedure writes a specified number of characters to a file and adds a newline character.

The PUT_LINE procedure is similar to the PUT procedure, but adds a newline character after writing the data. The autoflush parameter specifies whether to immediately flush the written data to the file system.

Syntax

UTL_FILE.PUT_LINE (
file            IN  FILE_TYPE,
buffer          IN  VARCHAR2,
autoflush       IN  BOOLEAN DEFAULT FALSE);

Parameters

Exceptions

• INVALID_FILEHANDLE

• INVALID_OPERATION

• WRITE_ERROR

Considerations

• If the maximum number of bytes is not specified in FOPEN, the maximum size of the buffer parameter is 32767 bytes. The default value is 1024. The total of all sequential calls to PUT cannot exceed 32767 bytes without intermediate buffer flushes.

• If the file is opened in byte mode, the INVALID_OPERATION exception is raised.