Hello,
I try sen mail by plsql(I took advantage of https://oracle-base.com/articles/misc/email-from-oracle-plsql first procedure) but altough I am sure that everything is true I get this error > Network Access Denied by Access Control List (ACL)
I searched this error in internet. I found this code block everywhere
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
acl =>'SCOTT.xml',
description => 'ACL for users to send mail.',
principal => 'SCOTT',
is_grant => TRUE,
privilege => 'connect',
start_date => null,
end_date => null
);
END;
/
but I get this error > Identifier 'DBMS_NETWORK_ACL_ADMIN' must be declared
I looking for DBMS_NETWORK_ACL_ADMIN in my database system but I didn't find this procedure or function. It is in public but I don't understand anything.
There is in database sys closest DBMS_NETWORK_ACL_ADMIN > SYS.DBMS_NETWORK_ACL_UTILITY because I don't look inside public.
What should I do?
Thanks for your interest.
Best regards