SET_REMOTE_SERVER Procedure

This procedure sets the base URL, HTTPS host, and other attributes for remote servers. Remote servers are identified by their Static ID.

Syntax

APEX_APPLICATION_ADMIN.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,
    --
    p_ai_model_name    IN VARCHAR2 DEFAULT NULL,
    p_ai_http_headers  IN CLOB     DEFAULT NULL,
    p_ai_attributes    IN CLOB     DEFAULT NULL )

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.
`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.
`p_ords_timezone`	Time zone in which the remote ORDS server runs. Only relevant for REST-Enabled SQL services, when remote ORDS does not run in UTC time zone.
`p_ai_model_name`	The AI model to use when requesting a response from a generative AI service.
`p_ai_http_headers`	HTTP headers to use when making a request to a generative AI service.
`p_ai_attributes`	Attributes in JSON format to use when making a request to a generative AI service.

Example

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