GET_FILE_ID Function

59.53 GET_FILE_ID Function

This function obtains the primary key of a file in the Oracle APEX file repository.

Syntax

APEX_UTIL.GET_FILE_ID (
    p_name    IN VARCHAR2 )
RETURN NUMBER;

Parameters

Parameter	Description
`p_name`	The NAME in `APEX_APPLICATION_FILES` of the file to be downloaded. `APEX_APPLICATION_FILES` is a view on all files uploaded to your workspace.

Example

The following example retrieves the database ID of the file with a filename of F125.sql.

DECLARE
    l_name VARCHAR2(255);
    l_file_id NUMBER;
BEGIN
    SELECT name
        INTO l_name
        FROM APEX_APPLICATION_FILES
        WHERE filename = 'F125.sql';
        --
        l_file_id := APEX_UTIL.GET_FILE_ID(p_name => l_name);
END;

Parent topic: APEX_UTIL