Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-24247 with apex_pwa.send_push_notification

LKTGMay 25 2023 — edited May 25 2023

Env: OCI ADW
APEX: 23.1

I am trying to use the new (amazing) feature of Push Notification

Code:
apex_pwa.send_push_notification (
p_application_id => :APP_ID,
p_user_name => <USER>
p_title => 'Notification Title2',
p_body => 'Notification Body2' );
Code is working well.
However, all the notifications are queuing up with ORA-24247

I've done the security code in the PWA app

declare
    l_principal varchar2(20) := 'APEX_230100'; -- Replace with current APEX user
    l_hosts apex_t_varchar2  := apex_t_varchar2(
                                    '*.push.apple.com',
                                    '*.notify.windows.com',
                                    'updates.push.services.mozilla.com',
                                    'android.googleapis.com',
                                    'fcm.googleapis.com' );
begin
    for j in ( select column_value as hostname from table(l_hosts) ) loop
        dbms_network_acl_admin.append_host_ace (
            host       => j.hostname,
            lower_port => 443,
            upper_port => 443,
            ace        => xs$ace_type(
                              privilege_list => xs$name_list('connect'),
                              principal_name => l_principal,
                              principal_type => xs_acl.ptype_db) );

        dbms_network_acl_admin.append_host_ace (
            host       => j.hostname,
            ace        => xs$ace_type(
                              privilege_list => xs$name_list('resolve'),
                              principal_name => l_principal,
                              principal_type => xs_acl.ptype_db) );

        dbms_network_acl_admin.append_host_ace (
            host       => j.hostname,
            lower_port => 443,
            upper_port => 443,
            ace        => xs$ace_type(
                              privilege_list => xs$name_list('http'),
                              principal_name => l_principal,
                              principal_type => xs_acl.ptype_db) );
    end loop;
end;

But the issue still exists… I cannot figure out a way to solve it.

Any ideas about what I am doing wrong here?

Again, this is an ADW Free plan env.

Thanks,

Lior

This post has been answered by cjb83 on Jun 14 2023
Jump to Answer
Comments
Post Details
Added on May 25 2023
52 comments
3,634 views