Unable to send Email From apex app?

CHAITANYASHAH

I'm trying to send mail from oracle apex application,But i'm getting following error

ORA-04063: package body "APEX_190100.WWV_FLOW_MAIL" has errors ORA-06508: PL/SQL: could not find program unit being called: "APEX_190100.WWV_FLOW_MAIL"'

i have given ACL Priviliges also and if i try to compile i cannot compile because it has error and as it package body is wrapped i'm not able to solve error..

Thanks in advance.

MannyR

If the package has errors, you might try copying the package, dropping the package and re-installing it.

InoL

Check with your DBA. Maybe the APEX installation had errors, maybe there are invalid objects in the SYS schema, like UTL_SMTP etc.

The ACL privilege has nothing to do with an invalid package. A properly configured ACL is necessary when sending mails.

CHAITANYASHAH

https://community.oracle.com/tech/developers/discussion/comment/16805424#Comment_16805424

yes thank you

CHAITANYASHAH

https://community.oracle.com/tech/developers/discussion/comment/16805413#Comment_16805413

Thank you as package was Wrapped i cannot copy nor reinstalled nor can i recompile .

MannyR

Is this using the free APEX on OCI?