UTL_SMTP - email through store proc
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: UTL_SMTP - email through store proc

  1. #1
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    I want to send email whenever exception in my store proce which runs every night.
    does any body has used UTL_SMTL, UTL_TCP .... ?
    Please guide me or is there any other way for notifivation via email if data inserted in error_log table...


    Thanks in advance

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi

    Try this link

    http://asktom.oracle.com/pls/ask/f?p...0_P8_DISPLAYID

    You can also search

    asktom.oracle.com

    Will get all answers

    Regards
    Santosh

  3. #3
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    We are developing a email system using UTL_SMTP that sends reports every day and actually looking into these issues right now.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  4. #4
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    This should work fine in 8i aswell as 9i:

    http://www.oracle-base.com/Articles/...romPLSQL9i.asp

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  5. #5
    Join Date
    Mar 2002
    Posts
    1
    You can try our PSP_Mail product which is built on top of UTL_SMTP and provides a simple interface for sending various types of email, including email with any number of LOBs or OS files as attachments. The package can do DNS lookups and send mail directly to the mail server of recipient or it can route all mail through your local mail relay server, you can encode message text and headers using Base64 encoding to preserve national language, you can target multiple recipients in one call (using To: , Cc: and Bcc: headers) and much more. Low-level interface is also provided which hands the task of message generation over to the caller and provides only transport for message delivery. And you don't need to load JavaMail or setup any external scripts or procedures for this.
    Download your evaluation copy at http://www.dpsp-yes.com.

    hth,
    Bob.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width