The FGETATTR procedure is used to read the attributes of an operating system file, such as whether it exists and its size.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
UTL_FILE.FGETATTR (
location IN VARCHAR2,
filename IN VARCHAR2,
fexists OUT BOOLEAN,
file_length OUT NUMBER,
block_size OUT BINARY_INTEGER
);
Parameters
| Parameter | Description |
|---|---|
| location | The directory path or the name of the defined directory object where the file is located. |
| filename | The name of the file to be checked. |
| fexists | Indicates whether the file exists. TRUE indicates that the file exists, and FALSE indicates that it does not. |
| file_length | The size of the file in bytes. |
| block_size | The size of the data block in the file system where the file is stored, in bytes. |