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 );

Parameters

Table 3-12 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.

Example

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