DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SMTP

  1. #1
    Join Date
    Aug 2001
    Location
    uae
    Posts
    21
    I Am Using Oracle 8i, with Delphi front end. I want to activate SMTP in this. As soon as i insert a value in a particular table field, i want to receive an Email message about this insertion.

    Can anybody gives you the full procedure of this.

    my email : sajidaniel@hotmail.com

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

  3. #3
    Join Date
    Aug 2001
    Location
    uae
    Posts
    21
    Thank you very much for the reply.

    Is there any parameter to be given in that sqlcode,
    what is this
    mailhost VARCHAR2(30) := 'smtp01.us.oracle.com';
    insteade of 'smtp01.us.oracle.com' , can i give anything else ?

    Procedure receipent In can i just give my sajidaniel@hotmail.com ?

    What is the server setting required for this ?
    In my server internet is activated now, what else is required ?

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    hello

    mailhost VARCHAR2(30) := 'smtp01.us.oracle.com';

    smtp01.us.oracle.com is fully qualified name of the mail server ask your system admin for a detailed explaination.

    smptp01 is host name its under the domain com under the sub domain oracle under the subdomain us.........

    yeah u can give any receipent.which is a valid email id.

    for server setting ask your sys admin.

    regards
    hrishy


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