Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2009
    Posts
    46

    Unanswered: send e-mail useing oracal job

    hi
    i want know the process to send the e-mail useing oracale job
    every day.
    what will be the process is it possible to send mail using oracale or not.
    i meeting with dead line pls'e give reploy at early't

    regards
    Prasad

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Post Operating System (OS) name & version for DB server system.
    Post results of
    SELECT * from v$version

    I am sorry to see that both SEARCH of this forum & GOOGLE are broken for you.
    Please wait while repairs are completed.
    Additional information will be posted as it becomes available.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    There are various ways to do this depending on the version. For example in oracle 10 and above, check out the utl_mail oracle package. It needs to be installed, but works very nicely.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Jun 2009
    Posts
    46
    Hi,

    I am using oracle10g and 9i.
    regards
    prasad

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    If you have a database link, then you could use ora_mail on the 10g and the same installation through a database link. for example

    utl_mail.send@db_link('fromme','billG@microsoft.co m',null,null,'Subject','message text');
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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