FSEEK

The FSEEK stored procedure is used to move the file access position in bytes.

Syntax

UTL_FILE.FSEEK (
file               IN   OUT  UTL_FILE.FILE_TYPE,
absolute_offset    IN   PL_INTEGER DEFAULT NULL,
relative_offset    IN   PLS_INTEGER DEFAULT NULL);

Parameters

Exceptions

• INVALID_FILEHANDLE

• INVALID_OFFSET

• INVALID_OPERATION

• READ_ERROR

Considerations

• You can directly read the first few lines of a file by using FSEEK, without closing and reopening the file.

• For relative_offset, if the specified number of bytes is reached at the beginning of the file, the file pointer will be placed at the beginning of the file. If the specified number of bytes is reached at the end of the file, the INVALID_OFFSET error will be triggered.

• The file must be opened in r mode; otherwise, the INVALID_OPERATION exception will be triggered.