Forum Stats

  • 3,876,265 Users
  • 2,267,083 Discussions


emails not sending in regular interval from oracle



  • Cookiemonster76
    Cookiemonster76 Member Posts: 3,410 Gold Trophy
    edited Feb 28, 2017 6:38AM

    In much the same way you're logging errors. Have an autonomous procedure that inserts into a table. Call it at various places to see what's going on.

    I'd start with: before each call to send_mail_smtp, in send_mail_smtp just before the exception handler.

  • user12251389
    user12251389 Member Posts: 335 Blue Ribbon
    edited Feb 28, 2017 6:42AM

    Ok i will try this usecase

  • BluShadow
    BluShadow Member, Moderator Posts: 42,591 Red Diamond
    edited Feb 28, 2017 7:17AM
    Cookiemonster76 wrote:In this case apparently the process is a job, not anything with direct user interaction. In which case rollback is probably irrelevant.

    Not necessarily, it depends if the emailing is just part of a larger process that 'does stuff' which could be transactional.

This discussion has been closed.