Home » Developer & Programmer » Forms » email with checkboxes
email with checkboxes [message #380598] Mon, 12 January 2009 09:14 Go to next message
athene
Messages: 11
Registered: January 2009
Junior Member
Hi,

I have created a procedure for sending an email with data from db.I have to include checkboxes ,text area and buttons in the email.
The recepient should be able to check the checkboxes and on click these data should get inserted into the db.

Can this be done using PL/SQL

Thanks in Advance.
Re: email with checkboxes [message #380600 is a reply to message #380598] Mon, 12 January 2009 09:21 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You can use Pl/Sql Server Pages to generate web pages that will do this.

Otherwise - no. Pl/Sql is a server side language with no built in GUI interface.
Re: email with checkboxes [message #380601 is a reply to message #380600] Mon, 12 January 2009 09:45 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Actually, I think I misread your question.

Do you want the email to contain some code that will update the database?

If so, you can't do it from pl/sql. You would need a POP3 email client to handle receipt of the reply to their email, and something to pass the details to the database.
Re: email with checkboxes [message #380602 is a reply to message #380598] Mon, 12 January 2009 09:51 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
>Can this be done using PL/SQL
Simply put, NO since PL/SQL run deep within Oracle RDBMS server.

Why would you want some random & remote person to be able to change data within your database from email client?

Emails can be received on cell phones.
Do you want any cell phone around the world changing data in your DB?

How do you control security & data integrity?

[Updated on: Mon, 12 January 2009 09:53]

Report message to a moderator

Re: email with checkboxes [message #380605 is a reply to message #380601] Mon, 12 January 2009 10:16 Go to previous messageGo to next message
athene
Messages: 11
Registered: January 2009
Junior Member
I am using lotus notes as the email client.How can a button click return data into my db though?
Re: email with checkboxes [message #380676 is a reply to message #380605] Mon, 12 January 2009 23:55 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
There was a time (5 years ago) that Oracle had an email client which ran inside the Oracle database. It was possible to redirect the incoming email from your corporate email handler to the Oracle email handler and the Oracle email handler could be programmed in PL/SQL to perform various operations based on information in the incoming email. It was also possible to use it to generate emails as well.

David
Re: email with checkboxes [message #405890 is a reply to message #380598] Sun, 31 May 2009 02:52 Go to previous message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Hi did you resolved your problem , anyway u can use utl_mail.send built in package of oracle
Previous Topic: how to make text item as non navigable
Next Topic: Execute Record after 10 Second
Goto Forum:
  


Current Time: Wed Dec 07 18:54:42 CST 2016

Total time taken to generate the page: 0.05879 seconds