Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error Handling with SMTP Server

User_OR6IUNov 26 2021

Hi,
I use the UTL Package for sending emails via Oracle Database Function ( Database Version 12g), sometimes
i get this error:
ORA-29278 Transient Error: 451 4.7.0 Timeout waiting for client input
question is here, how can I handle this error, I thought that I use a try catch and implement
a wait/Sleep, try catch is implemented but what is the best Practice for sleep timer ?

Added on Nov 26 2021

#general-database-discussions

7 comments

1,074 views