apex_mail.send_example_code.txt (3.17 KB)Oracle APEX 20.2
Keep in mind all this code has been used a few years now with no issues, and no recent updates or patches have been applied on the DB or APEX.
When trying to send email using the APEX_MAIL.SEND api I am now receiving the following error message:
ORA-00942: table or view does not exist
I have reviewed the following Oracle Doc: 2724433.1
Based on the article above I tested using the plain text and html examples from: https://docs.oracle.com/en/database/oracle/application-express/20.1/aeapi/SEND-Function-Signature-1.html
and both worked correctly. On my code I commented out the HTML param and just used the plain text and was also able to send successfully but when I use both the plain and html params it fails with the above error message.
Both of my plain text and html variables are defined as CLOBs so it should work but I am wondering if pulling the html param from a DB table is causing me issues.
Any ideas? Any gotchas or something I have missed in my code?
I have attached a copy of my code.