Installed Oracle Linux
[root@oraclexe ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.6 (Santiago)
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
Updated APEX
SQL> COL comp_name FOR A30
SQL> SELECT comp_name, version, status FROM dba_registry WHERE comp_id='APEX';
COMP_NAME VERSION STATUS
------------------------------ ------------------------------ --------------------------------------------
Oracle Application Express 4.2.6.00.03 VALID
Enabled network services
DECLARE
ACL_PATH VARCHAR2(4000);
BEGIN
-- Look for the ACL currently assigned to '*' and give APEX_040200
-- the "connect" privilege if APEX_040200
-- does not have the privilege yet.
SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS
WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;
IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_040200',
'connect') IS NULL THEN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,
'APEX_040200', TRUE, 'connect');
END IF;
EXCEPTION
-- When no ACL has been assigned to '*'.
WHEN NO_DATA_FOUND THEN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml',
'ACL that lets power users to connect to everywhere',
'APEX_040200', TRUE, 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');
END;
/
COMMIT;
Using http://oraclexe.cgc.local:8080/apex internal, admin
Choose manage instance, instance setting
Choose mail and configured:
SMTP host address: smtp.mydomain.com
SMTP Host port: 25
SMTP Authentication username: network.mydomain.com
SMTP Authentication password: "mypassword"
Default Email From Address: network.mydomain.com
After apply, I see SMTP Authentication Password is empty, weird!
Using http://oraclexe.cgc.local:8080/apex myworspace, developeruser
SQL Worshop, Object browser, procedures
create or replace procedure contact_us
(
p_from IN VARCHAR2,
p_body IN VARCHAR2
)
AS
BEGIN
apex_mail.send(
p_from => p_from,
p_to => 'personalemail@gmail.com',
p_subj => 'Message from the APEX Issue Tracker',
p_body => p_body,
p_body_html => p_body);
END contact_us;
Sending email from APEX page built following book "beginning Oracle Application Express 4.2" first edition page 110.
Going back http://oraclexe.cgc.local:8080/apex internal, admin
Choose manage instance, mail queue
Choose manage instance, instance setting
SMTP Authentication password: (is empty)
Filled again, empty queue, sent new emails, but same result.
SMTP Authentication password continue showing anything!