Oracle Application Express 5: Developing Web Applications — Question 16

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?

Answer options

• A. &PAGE_ITEM
• B. v("˜PAGE_ITEM')
• C. APEX_UTIL.GET_SESSION_STATE(p_item => "˜PAGE_ITEM)
• D. :PAGE_ITEM

Correct answer: C

Explanation

The correct answer is C, as APEX_UTIL.GET_SESSION_STATE is the appropriate method to retrieve the session state value of a page item. Options A and D are incorrect because they do not properly call the session state function, while option B uses the wrong syntax for accessing the session state value.