The FREMOVE stored procedure deletes a specified file.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
UTL_FILE.FREMOVE (
location IN VARCHAR2,
filename IN VARCHAR2);
Parameters
| Parameter | Description |
|---|---|
| location | The path of the file, which is case-sensitive. |
| filename | The name of the file to be deleted. |
Exceptions
ACCESS_DENIEDDELETE_FAILEDINVALID_FILENAMEINVALID_OPERATIONINVALID_PATH
Considerations
The FREMOVE stored procedure does not verify privileges before deleting a file. However, the OS verifies the file and directory privileges.