ORA-29273: HTTP request failed

 

select * from dba_host_acls;

select * from dba_host_aces;

-- Run as SYS or DBA user
declare
    l_principal varchar2(20) := apex_application.g_flow_schema_owner;
    l_proxy varchar2(100)    := null; -- e.g. 'proxy.example.org'
    l_proxy_port number      := 80;
    l_hosts apex_t_varchar2  := apex_t_varchar2(
                                  '*.openai.com'
                                --
                                -- Commenting out domains needed for push
                                -- notification, but leave uncommented if
                                -- you plan to also use Push Notification 
                                -- features in apex
                                --
                                --'*.push.apple.com',
                                --'*.notify.windows.com',
                                --'updates.push.services.mozilla.com',
                                --'android.googleapis.com',
                                --'fcm.googleapis.com'
                                );
    procedure add_priv(p_priv varchar2, p_host varchar2, p_port number) is
    begin
        dbms_network_acl_admin.append_host_ace (
            host       => p_host, 
            lower_port => p_port,
            upper_port => p_port,
            ace        => 
                xs$ace_type(privilege_list => xs$name_list(p_priv),
                            principal_name => l_principal,
                            principal_type => xs_acl.ptype_db));
    end;
begin
    if l_proxy is not null then
        add_priv('connect',l_proxy,l_proxy_port);
    end if;
    for j in (select column_value as hostname from table(l_hosts)) loop
        add_priv('connect',j.hostname,443);
    end loop;
    commit;
end;

참고

https://apex.oracle.com/pls/apex/r/apex_pm/apex-pwa-reference/push-notifications