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!

Pass A Parameter to Public Page

APEX4EBSJul 2 2021

Apex : 20.2
I have a process where a pl/sql procedure that is called to insert data into a table with a unique code, then emails the user with a apex application url and the unique code.
This url and unique code will open a apex public form page with No Authenicationto allow the a user to confirm the information is correct. eg username etc... By using the the unique code in the URL to query back the data from the table. When the user presses the confirm button. A table update is done and the registration is completed. The unique will never be able to be used again, the apex page will check the table that the unique code flag is null.
My question :
The apex application that I am wanting to use to confirm the user information is correct should be public. I would like to pass unqiue code using parameters in the URL and the apex user registration application reads the url param eg. ....f?p=108:1:0::::P1_CODE:uniquecode
The apex form page item P1_CODE should have a value of "uniquecode" when the page opens in the browser. The the page items in the page should have data from the table showing.
How can I get a public page to open and display in a page item using the contents of the parameters in the URL ?
I have set the page "Authentication" to Page Is Public.
I get an error ERR-1002 Unable to find item ID for item "P" in application "108"
Any help would be appreciated.

Thanks

Comments
Post Details
Added on Jul 2 2021
6 comments
950 views