Dear all,
i am using Apex 5.1 on oracle 12c R1 with windows server 2012.
i am trying to send email from apex application. i did the following;
Install utl_mail/utl_smtp
cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
SQL> @utlmail
SQL> @utlsmtp
SQL> @prvtmail.plb
SQL> GRANT EXECUTE ON utl_mail TO PUBLIC;
SQL> GRANT EXECUTE ON utl_smtp TO PUBLIC;
SQL> alter system set smtp_out_server='mail.hct.edu.om' scope=both;
ACL: Access Control List
Create ACL
begin
dbms_network_acl_admin.create_acl (
acl => 'utl_mail.xml',
description => 'Allow mail to be send',
principal => 'STD',
is_grant => TRUE,
privilege => 'connect'
);
commit;
end;
Add Privilege
begin
dbms_network_acl_admin.add_privilege (
acl => 'utl_mail.xml',
principal => 'STD',
is_grant => TRUE,
privilege => 'resolve'
);
commit;
end;
Assign ACL
begin
dbms_network_acl_admin.assign_acl(
acl => 'utl_mail.xml',
host => 'mail.hct.edu.om' );
commit;
end;
Apex Code
i create a button with dynamic action and add the following pl/sql code
BEGIN
apex_mail.send( p_to => 'Muhammad.idrees@hct.edu.om',
p_from => 'Muhammad.idrees@hct.edu.om',
p_body => 'The Body of Email',p_subj => 'My Plain text message');
END;
my instance settings are below
when i run the page, it never send me the email.
then i issue the following query
SELECT * FROM APEX_MAIL_QUEUE;
ORA-24250: No supported authentication scheme found
please note that i was able to send the email from the sqlplus using the following procedure
begin
utl_mail.send(
sender => 'Muhammad.idrees@hct.edu.om',
recipients => 'Muhammad.idrees@hct.edu.om',
message => 'My first email'
);
end;
it seems that my apex is not properly configured. i am using LDAP authentication.
any clue how to fix it?
thank you.