Skip to Main Content

APEX

Announcement

Testing banner

How to send an email with attachment using apex (PL/SQL) without storing the attachment in server

User_C5V77Nov 22 2022

Hi all, I wanted to send an email with attachment from the oracle apex workspace, currently i am using the APEX_MAIL package which includes (APEX_ATTACHMENT, APEX_EXPORT functions). But the issue is, we are creating an CSV file and adding it as a mail attachment while sending the email and the attachments are sometimes larger in size which are getting stored in server each time the mail is triggered. This issue is causing a regular maintenance for the DBA to clear the data in the server.
Can anyone suggest is there any alternative for the current approach in order to come out of the issue.
Thanks in advance.

Comments
Post Details
Added on Nov 22 2022
4 comments
97 views