Hello All
Just thought of checking with you all on the issue which i encountered while executing the below statement ..
exec contact_utils.utils.p_send_email_direct( 'subject in test email' , 'body in test email' , 'mike@contact.com' , 'mike@contact.com' , 'mike@contact.com' );
-- Errors received
ORA-24248: XML DB extensible security not installed
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 267
ORA-06512: at "SYS.UTL_SMTP", line 161
ORA-06512: at "SYS.UTL_SMTP", line 197
ORA-06512: at "CONTACT_UTILS.UTILS", line 213
ORA-06512: at line 1
Checked the dba_Registry and found some invalid status .
| Oracle XML Database | INVALID |
| Oracle Application Express | VALID |
| OLAP Catalog | VALID |
| Spatial | INVALID |
| Oracle Multimedia | INVALID |
| Oracle Text | VALID |
| Oracle Expression Filter | VALID |
| Oracle Rules Manager | VALID |
| Oracle Workspace Manager | VALID |
| Oracle Database Catalog Views | VALID |
| Oracle Database Packages and Types | INVALID |
| JServer JAVA Virtual Machine | INVALID |
| Oracle XDK | VALID |
| Oracle Database Java Packages | INVALID |
| OLAP Analytic Workspace | INVALID |
| Oracle OLAP API | INVALID |
I've uninstalled the xml db and then installed it . expecting it may resolve it . but still have the same problem .
Any Expert suggestion is highly appreciated ....
Thanks in advance .