The FCLOSE stored procedure closes a file based on the input file handle.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
UTL_FILE.FCLOSE (
file IN OUT FILE_TYPE);
Parameters
| Parameter | Description |
|---|---|
| file | The active file handle returned by the FOPEN or FOPEN_NCHAR stored procedure. |
Considerations
If any buffered data has not been written to the file when you call the FCLOSE stored procedure, the system will attempt to write the buffered data to the file, but the WRITE_ERROR error may occur.
WRITE_ERROR
INVALID_FILEHANDLE