8.28 GET_REMOTE_SERVER_DEFAULT_DB Function

This function gets the default database to be used for a given remote server during application import.

Syntax

APEX_APPLICATION_INSTALL.GET_REMOTE_SERVER_DEFAULT_DB (
    p_static_id IN VARCHAR2 )
    RETURN VARCHAR2;

Parameters

Parameter	Description
p_static_id	Static ID to reference the remote server object.

Example

DECLARE
    l_default_database varchar2(255);
BEGIN
    l_default_database := apex_application_install.get_remote_server_default_db( 'MY_REMOTE_SERVER' );
END;

Note:

SET_REMOTE_SERVER Procedure