48.50 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

Table 48-43 GET_FILE_ID 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;