The FFLUSH procedure is used to flush data from the cache to the file.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
UTL_FILE.FFLUSH (
file IN FILE_TYPE);
Parameters
| Parameter | Description |
|---|---|
| file | The active file handle returned by calling FOPEN or FOPEN_NCHAR. |
Exceptions
INVALID_MAXILINESIZEINVALID_OPERATIONINVALID_FILENAMEWRITE_ERROR
Considerations
FFLUSH writes data that ends with a line terminator to the file. If the data does not end with a line terminator, it will not be written to the file and will remain in the buffer.
FFLUSH requires w permission for the file. Otherwise, it will throw the INVALID_OPERATION exception. If the length of the data in the buffer exceeds the maximum line length specified by FOPEN, it will throw the INVALID_MAXILINESIZE exception.