GET_FILE_STORAGE Function

5.11 GET_FILE_STORAGE Function

This function retrieves the static ID of the file storage remote server of an application.

If database file storage is used, returns NULL.

Syntax

APEX_APPLICATION_ADMIN.GET_FILE_STORAGE (
    p_application_id    IN  NUMBER )
RETURN VARCHAR2;

Parameters

Parameter	Description
`p_application_id`	The ID of the application.

Returns

The static ID of the file storage remote server, if OCI file storage is used. NULL otherwise.

Example

The following example prints the static ID of application file storage remote server setting.

   select apex_application_admin.get_file_storage(100) from sys.dual