This content has been marked as final. Show 10 replies
Yes, it is possible. You need to create a process (probably On Submit - After Computations and Validations), and in this process you can write PL/SQL code that can do whatever you want.
Do you want it to be possible or do you want assurance that it is not possible?
If your application requires authentication then I'd say that it's not possible.
If your application is public, then it might be possible, but it would be cumbersome.
I need to understand your exact requirements to be able to give you a more specific and detailed answer.
I am looking for the same answer, but with a NO Authentication page. I believe the key is putting the right URL in front of the wwv_flow.accept call in the <form ...> tag, but not sure what to use in finding that URL. /stephen
You stated your requirements in more detail in your email to the help mailing list. For the benefit of others I'm posting them here:
"I have a simple insert form with 4 input elements. The application has NO authentication. I want to be able to take the html form and input tags, etc. and move them into an existing plain html page on a generic web site (not the Apex site). So, that when the use clicks the submit button the data then the form action post the info to the apex db.
I have put the URL for the form in front of the wwv_flow.accept form action, but that did not work.
My guess is that I need to put a DAD url in front of the wwv_flow.accept form action, but....
1. I'm not sure that's correct or all I need to do.
2. I'm not sure how to identify the correct url to use on the wwv_flow.accept
I would prefer to stay with html in the new page instead of using an iFrame call."
Found an answer - hope this is what the first person was looking for.
You can embedded the Apex code within HTML with the following key steps:
1. Java scripts need to reference the correct URL paths. For example on apex.oracle.com they would be
2. The <form...> tag needs to have the DAD URL in it. Such as:
<form action="http://apex.oracle.com/pls/otn/wwv_flow.accept" method="post" name="wwv_flow" id="wwvFlowForm" >
Any other references need to point to the right URLs.
Finally, the action that will occur after submission is defined by the Apex Form, so you will need to set the appropriate Branch action in the application, such as going back to the same URL currently on, etc.
Hai all so sorry for the late response
Now i can able to Post data from HTML (NO Authentication) .
i've reached this one with the help of "Stephen" information thank you so much Stephen also thanks for all who are all replied for this thread.
I have a similar requirement. Could you please post your external form's html so I can see how you've managed to do this.
instead of send the Heavy HTMl i'll tell the eay way to meet your requirement.
1) Create a insert Form in APEX Application for which table you want to insert.
2) Save that Form as HTML
3) On that HTML change all /i/.. folders to relative path like D:/apex/images/...
4) Change the Form Action to like
<form action="http://LOCALHOST:7777/pls/apex/wwv_flow.accept" method="post" name="wwv_flow" id="wwvFlowForm" >
now click the create button the form will post you data to table .
Why i explained the above steps are for each form contains the application id and few hidden fields. If you try like above you can see all that informations based on that you can change the HTML to your taste.
How did you retrieve the values from your apex application?
ex: i had 4 fields in the html form.
how were you able to access the field values?
what if the post was an xml stream?
Can you explain how you got this to work