Not able to send email from database users
Dear All ,
We have been trying to send email from oracle database and we did successfully with the 'sys' user , but we are not able to send emails from other database users.
Can anyone help me to solve this issue.
Below mentioned is the error.
begin
dbms_network_acl_admin.assign_acl (
acl => 'sendmailone.xml',
host => 'smtp.gmail.com',
lower_port => 25);
end; 2 3 4 5 6
7 /
begin
*
ERROR at line 1:
ORA-31001: Invalid resource handle or path name "/sys/acls/sendmailone.xml"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 94
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 479
ORA-06512: at line 2
Regards
Niranjan
Edited by: 1005153 on May 9, 2013 9:58 PM