I would like to send an email from my apex application that has a form embedded with a submit button to send the filled out form back to intended email address. I've tried the following in the sql workshop but got an error
DECLARE
l_body clob;
l_to varchar2(50);
l_from varchar2(50);
l_sub varchar2(75);
begin
l_body := '<html><body><form method="post" action="mailto:balvey27@email.com" enctype="text/plain"> Name: <input type="text" name="Name" size="30"> <p> Address: <input type="text" name="Address" size="30"> <p> <input type="submit" value="Submit"> </form></body></html> ';
l_to := 'balvey27@email.com';
l_from := 'balvey@email.com';
l_sub := 'Test Form';
apex_mail.send(
p_to => l_to,
p_replyto => l_from,
p_from => l_from,
p_body_html => l_body,
p_subj => l_sub);
APEX_MAIL.PUSH_QUEUE;
end;
ORA-06550: line 12, column 5:
PLS-00306: wrong number or types of arguments in call to 'SEND'
ORA-06550: line 12, column 5:
PL/SQL: Statement ignored
*1. DECLARE*
2. l_body clob;
3. l_to varchar2(50);
Edited by: PktAces on Apr 12, 2010 12:30 PM
Also, ideally I wanted to be able to submit an update from an email that I sent, but I'm not sure that is possible or desirable on a security sense. Any thoughts on this?
Edited by: PktAces on Apr 12, 2010 12:32 PM