You want to use the session state value of a page item in the SELECT statement for a report on another page. What is the correct way to reference the value of a page item in a SQL statement?
A.
&PAGE_ITEM
B.
v("˜PAGE_ITEM')
C.
APEX_UTIL.GET_SESSION_STATE(p_item => "˜PAGE_ITEM)
In release 23.1 is still D the correct answer. We are talking about SQL not PL/SQL I guess
https://docs.oracle.com/en/database/oracle/apex/23.1/htmdb/managing-session-state-values.html#GUID-AC0C208D-61DF-40F6-8CC9-F3D59D24E5D0:~:text=3.9.1-,About%20Referencing%20Session%20State,-Reference%20item%20values
D ":MY_ITEM" is correct (in SQL!): https://docs.oracle.com/en/database/oracle/application-express/21.1/htmdb/managing-session-state-values.html#GUID-AC0C208D-61DF-40F6-8CC9-F3D59D24E5D0
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
SuperDabicho
1 year, 6 months agoTiribobba007
3 years, 3 months agoNakhala
3 years, 3 months agogeri1590
3 years, 5 months agousmanchaudhy
3 years, 5 months agosbrand
3 years, 11 months ago