Hello,
I'm testing out applications on XE 18C on a Windows 10 platform. In testing a mail procedure in SQL Developer 18.4 I receive an error: ORA-04063: package body "SYS.UTL_SMTP" has errors. When I open the SYS as SYSDBA connection and look at the procedure, sure enough, the package body has a red X on it. When I right-click on the package body and try to recompile it, the compiler log gives another error: PLS-00753: malformed or corrupted wrapped unit.
My access to other system utilities is fine. Did anything change in UTL_SMTP from release 11 to 18? How do I go about fixing the SYS.UTL_SMTP package body?
Thanks for looking at this.