Skip to Main Content
Forums

SQL & PL/SQL

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!

Question about UTL_SMTP.RSET

Jeff ChircoSep 28 2010 — edited Sep 29 2010
I am trying to use the RSET command to terminate an email message that I have started to generate. The smtp connection has been open and data has been written but instead of sending the email I want to terminate it, and UTL_SMTP.RSET should it but it get this error:
ORA-29277: invalid SMTP operation when it tries to call RSET. I tried calling CLOSE_DATA first and then RSET and the runs successfully but it still sends out the email. Anybody know the proper use of this call?
Database version is 11.1.0.7

Thanks,
Jeff
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 27 2010
Added on Sep 28 2010
#11g, #email
3 comments
512 views