Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2010
    Posts
    24

    Question Unanswered: Programming with buttons in mail body

    Dear All,

    Have seen such cases in mails. Just thought of implementing it in PL/SQL.

    Assume, an employee's leave request mail will be sent to manager. Manager can approve/reject the request in the mail itself, by clicking on Approve or Reject button.
    Can such action buttons be implemented using PL/SQL ?
    If yes, please provide the details.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I don't know.

    Also, note that I don't know much about all this stuff.

    However, thinking about how it might look like, I don't like the idea. In order for those button to do "something" (either approve or reject the request), you would have to connect to the database and update certain table(s). It means that you need to provide login credentials (somewhere behind the button click). Are you sure that it is a good idea (sending such an information in an e-mail)?

    Hopefully, there are certain "security" options you might use and nullify my previous statement. As I said, my knowledge is less than zero here.

    You should probably wait for another, smarter opinion.

  3. #3
    Join Date
    Jul 2010
    Posts
    24
    Thanks for the reply!

    I just had this idea to implement in my application. Security problems may arise, but this can be taken case I think, as we see such examples in mails nowadays.

    Also whether this can be done through oracle forms ? ( I dont know even basics of oracle forms, just thought so! )

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Nothing is impossible for the person who does not actually have to do it.
    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.

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Quote Originally Posted by sunilmp
    whether this can be done through oracle forms
    What is "this"? Sending an e-mail using Forms or creating a form with two buttons (Approve and Reject)? As far as I can tell, both is possible.

    The latter one is obvious - that's what Forms is there for; no problem in creating such a form.

    The first one would utilize the same UTL_MAIL (or UTL_SMTP, whichever you meant to use) as your (stored?) PL/SQL procedure in order to create and send an e-mail.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Manager can approve/reject the request in the mail itself, by clicking on Approve or Reject button.
    to what exactly is this "button" in email connected.
    How does this button reach out & eventually touch the DB?
    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.

  7. #7
    Join Date
    Oct 2002
    Location
    Cape Town, South Africa
    Posts
    253
    Guys, why not implement the Accept/Reject "buttons" as hyperlinks. The hyperlinks could point back to a web resource that would process the action (make db connection, implement business rules).

    That would simply require that the email be sent as HTML which is very do-able using PLSQL.

    Just an idea.

Tags for this Thread

Posting Permissions

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