OraFAQ Forum: Forms » email with checkboxes

Home » Developer & Programmer » Forms » email with checkboxes

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

email with checkboxes [message #380598]

Mon, 12 January 2009 09:14

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.

Report message to a moderator

Re: email with checkboxes [message #380600 is a reply to message #380598]

Mon, 12 January 2009 09:21

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.

Report message to a moderator

Re: email with checkboxes [message #380601 is a reply to message #380600]

Mon, 12 January 2009 09:45

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.

Report message to a moderator

Re: email with checkboxes [message #380602 is a reply to message #380598]

Mon, 12 January 2009 09:51

BlackSwan
Messages: 26766
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

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?

Report message to a moderator

Re: email with checkboxes [message #380676 is a reply to message #380605]

Mon, 12 January 2009 23:55

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: email with checkboxes [message #405890 is a reply to message #380598]

Sun, 31 May 2009 02:52

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

Report message to a moderator

Previous Topic:	how to make text item as non navigable
Next Topic:	Execute Record after 10 Second

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:48:55 CDT 2024