リモート・サーバーを構成する

config_remote_server.sql

procedure config_remote_server( 
    p_info    in  apex_plugin.t_remote_server_info
    ,p_config out apex_plugin.t_remote_server_config
)
is
begin
    p_config.base_url := '#proto#://#host#:#port#/ords/#workspace#';
    p_config.substitutions := apex_t_varchar2();
    apex_string.plist_put(p_config.substitutions, 'proto',     nvl(v('P1_PROTO'),'http'));
    apex_string.plist_put(p_config.substitutions, 'host',      nvl(v('P1_HOST'),'localhost'));
    apex_string.plist_put(p_config.substitutions, 'port',      nvl(v('P1_PORT'),'8181'));
    apex_string.plist_put(p_config.substitutions, 'workspace', nvl(v('P1_WORKSPACE'),'rest1'));
end;