SET_REMOTE_SERVER Procedure

4.36 SET_REMOTE_SERVER Procedure

Use this procedure to set the Base URL and the HTTPS Host attributes for remote servers of the imported application. Remote Servers are identified by their Static ID.

Syntax

APEX_APPLICATION_INSTALL.SET_REMOTE_SERVER (
    p_static_id        IN VARCHAR2,
    p_base_url         IN VARCHAR2,
    p_https_host       IN VARCHAR2 DEFAULT NULL,
    --
    p_default_database IN VARCHAR2 DEFAULT NULL,
    p_mysql_sql_modes  IN VARCHAR2 DEFAULT NULL,
    --
    p_ords_timezone    IN VARCHAR2 DEFAULT NULL )

Parameters

Table 4-17 SET_REMOTE_SERVER Parameters

Parameter	Description
`p_static_id`	Static ID to reference the remote server object.
`p_base_url`	New Base URL to use for this remote server object.
`p_https_host`	New HTTPS Host Property to use for this remote server object. Only relevant when the base URL is `https://` and the database version is 12.2 or greater.
`p_default_database`	Default database to use when connecting. Currently only supported for MySQL databases.
`p_mysql_sql_modes`	SQL modes to use when connecting to a MySQL database.

Example

BEGIN
    apex_application_install.set_remote_server(
        p_static_id => 'MY_REMOTE_SERVER',
        p_base_url => 'http://production.company.com' );
END;