Hello Sir,
I am sorry to bothering you with this again..
But I'm just not getting anywhere with the following.
The issue is that a user logs in and should be redirected to the corresponding page when clicking the 'Go to last status' button.
The corresponding page is stored in a table together with the ID and is always updated when the status changes.
In order to know which page should be redirected to for this form ID, I use a function that outputs the page as a return value.
I use this result to build the URL and save it in a page element.
I use URL Identified by Item as the type for the branching process.
Unfortunately I always get an error no data found.
Here I am not sure how to pass on the ID of the form.
I tried these both methods:
- Building own url
DECLARE l_branch_page number; l_id number; begin select ID into l_id from TABLE1 where ID=:P8_ID; l_branch_page:= FORWARDING_TO_PAGE(:P8_ID); :P8_URL :='f?p=&APP_ID.:l_branch_page'|| ':&APP_SESSION.::NO::l_id'|| ':'||:P8_ID; END;
2. apex_page.get_url
DECLARE l_branch_page number; l_id number; begin select ID into l_id from TABLE1 where ID=:P8_ID; l_branch_page:= FORWARDING_TO_PAGE(:P8_ID); :P8_URL :=apex_page.get_url(p_page => l_branch_page,p_items=>l_id)||:P8_ID; end;
Perhaps an important note, the :P8_ID is set, so the value is known here.
Can you please help me here?
Vinish Kapoor
If you are getting no data found error then it means P8_ID is not having the value. You need to double-check on this.
Ana
Hello Vinish,
this is how I set the P8_ID.
I created a pre-rendering process with the following PL/SQL Code:
I checked it by viewing the session in the debug tool bar.
And the value is set.
By using this function:
I get the error:
ERR-1002 Unable to find item ID for item "5" in application "100".
The number 5 is the ID of the form.