Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Form Based On Procedure

UdayRaju-User477265Mar 13 2017 — edited Mar 14 2017

Hi All,

I have started exploring apex to know its features and today , I registered for an account on apex.oracle.com and got all the details.

I am trying to built a form using "form on procedure" .

I have a small procedure which I am using to build the form

======================================

create or replace procedure contact_us

  (

  p_from IN VARCHAR2,

  p_body IN VARCHAR2

  )

AS

BEGIN

apex_mail.send(

  p_from => p_from,

  p_to => 'duday@yahoo.co.in',

  p_subj => 'Message from the APEX Application',

  p_body => p_body,

  p_body_html => p_body);

END contact_us;

=======================================

But when all the details are created I do not see the textbox appearing for me to enter the from and body details.

When I was navigating through the wizard , I did see the two parameters but on the end result those are missing.

Could you please guide me if there is anything different that needs to be done to get the details.

I

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2017
Added on Mar 13 2017
3 comments
306 views