1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Procedure to send notifications to users in pl/sql

Discussion in 'SQL PL/SQL' started by sellyh19, Mar 2, 2011.

  1. sellyh19

    sellyh19 Active Member

    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    80
    Helo, I urgently need help to create a procedure that will send notification to users
    mainly the admin user once a record is inserted or updated. the notification should be through email. please help.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You'll need much more of a description than what you have provided to get any useful assistance on this.
     
  3. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
  4. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
  5. sellyh19

    sellyh19 Active Member

    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    80
    Thanks a lot but I dont understand, can you mabe give me an example how i can do this?
     
  6. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Here is one example for Sent mail by using trigger-

    And for DBMS_SHEDULER way, here are teh steps to follow.

    1. Give execute previlege on utl_mail to the schema
    2. Set smtp_out_server using alter system command
    3. Create a procedure to scan the table and send the email as per the record present.
    4. Create a schedule by referring this procedure name along with scheduling parameters

    You are done. I prefer DBMS_SHEDULER over the trigger method.
     
  7. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455