Send Email from Oracle 11g using UTL_SMPT
Hello everyone,
I am trying to send email from Oracle 11g standard edition using UTL_SMPT, but I got the error messages:
system@TEST>DECLARE
2 mailhost VARCHAR2(64) := '127.0.0.1';
3 sender VARCHAR2(64) := 'sender@xxxxx.com';
4 recipient VARCHAR2(64) := 'recipient@xxxxx.com';
5 mail_conn UTL_SMTP.CONNECTION;
6
7 BEGIN
8
9 mail_conn := UTL_SMTP.OPEN_CONNECTION(mailhost, 25); -- 25 is the port
10 UTL_SMTP.HELO(mail_conn, mailhost);
11 UTL_SMTP.MAIL(mail_conn, sender);
12 UTL_SMTP.RCPT(mail_conn, recipient);
13 UTL_SMTP.OPEN_DATA(mail_conn);
14 UTL_SMTP.WRITE_DATA(mail_conn, 'This is a test message.' || chr(13));
15 UTL_SMTP.WRITE_DATA(mail_conn, 'This is line 2.' || chr(13));
16 UTL_SMTP.CLOSE_DATA(mail_conn);
17
18
19 UTL_SMTP.QUIT(mail_conn);
20
21 END;
22 /
DECLARE
*
ERROR at line 1:
ORA-24248: XML DB extensible security not installed
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 246
ORA-06512: at "SYS.UTL_SMTP", line 115
ORA-06512: at "SYS.UTL_SMTP", line 138
ORA-06512: at line 9
Do I have to install XML DB and JVM in order to send email using UTL_SMPT in Oracle 11g SE?
Could anyone please give me the guideline.
Thanks in advance!!!