I am trying to escape & from the prepare_url function, I use URL as a public bookmark. For insatnce: APEX_UTIL.PREPARE_URL ( p_url => 'f?p=' || :APP_ID || ':1:'|| :APP_SESSION ||'::NO::P1_ID:'|| x.ID ||'', p_checksum_type => 'PUBLIC_BOOKMARK', p_url_charset => 'UTF-8')
Discy Latest Questions
Hi! I am trying to redirect page using DA and PL/SQL and set items value. Friendly URLs is switch to on. Thanks in advance!
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?
Hello Sir, I have the following issue. I have an interactive grid, when clicking on the columns the user is directed to the form. There he can edit the form, e.g. accept or reject it. Depending on this, the user is redirected to another page. I would now like that the next time the person clicks on a column in the interactive grid, this person is redirected to the corresponding page. That is, if he has already edited the form, he should be redirected to the page to which he was redirected when he accepted or rejected the form. I have read your blog on a similar topic https://www.foxinfotech.in/2019/10/create-delete-row-button-for-interactive-report-in-oracle-apex.html and wonder if it would also work for this case or what I would have to change here. I proceeded as described in this tutorial. I use the value of the status from interactive report to redirect to the corresponding page. I use this code snippet from the blog in the interactive report. 5 case when nvl(STATUS,'APPROVED')='APPROVED' then 6 'f?p=&APP_ID.:100:8:&APP_SESSION.::::P8_ID'||ID 7 elsif nvl(STATUS,'REQUESTED')='REQUESTED' then 8 'f?p=&APP_ID.:100:9:&APP_SESSION.::::P9_ID'||ID 9 else 10 '#' 11 end LINK But I always get the error: ORA-00905: missing keyword in line 6. Is something wrong with the URL?
Hi Dear Sir ... Usually we have url like http:myapp:9090/apex/f?p=&APP_ID.:1:&SESSION. incase of ORDS http:myapp:8888/ords/f?p=&APP_ID.:1:&SESSION. now i want i just put http.myapp.com only for every page and "f?p=&APP_ID.:1:&SESSION." this must not come. i have ORDS with apache tomcat how to get this sir ...