UTP_SMTP email attached size limitations?
Just want to get your thoughts bout this one,
We have a custom procedure that would fetch data and dump it into a .csv file then email to a given e-address as an attachment. Emailing the file is using the
UTL_SMTP system package. While testing the custom program, at first, it successfully completed and received in the mailbox the .csv file. Until the next scenario of changing
source(param) of the data, the custom program now errors and give the below:
ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 17
ORA-06512: at "SYS.UTL_SMTP", line 96