Deletes a file which was intended to be used by feature attributes. Only files which were never referenced by feature attributes can be deleted.
If the filename is valid but there are references to the file, then the file is not deleted and no error message is given. The FEATURE_ATTRIBUTE_FILE_VW view can be used to check the number of references.
Input
Parameter | Type | Description |
|---|---|---|
v_filename | VARCHAR2 | The filename of the file to delete |
Example #1: Delete one unused file
exec P_FEATURE_API.DeleteUnusedFile('filename.000'); |
Example #2: Delete all unused files
DECLARE |
CURSOR c_files IS select filename from FEATURE_ATTRIBUTE_FILE_VW where reference_count = 0; |
BEGIN |
FOR REC in c_files LOOP |
p_feature_api.deleteUnusedFile(REC.filename); |
END LOOP; |
END; |
Exceptions
• File ('filename') was not found in the database.