GET_FILE_ID Function
This function obtains the primary key of a file in the Oracle Application Express file repository.
Syntax
APEX_UTIL.GET_FILE_ID (
p_name IN VARCHAR2)
RETURN NUMBER;
Parameters
Table 35-41 GET_FILE_ID Parameters
Parameter | Description |
---|---|
|
The NAME in |
Example
The following example shows how to use the GET_FILE_ID
function to retrieve 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