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!

How can I force the generation of an APEX Item in Session State / Page Item when it is NULL?

DionisisNov 26 2022 — edited Nov 26 2022

Hello all,
I have an APEX page that has a classic report display some rows from a resultset. The report for each record calls a modal dialog box passing the ID (PK) of a record to the dialog box.
In the dialog box, in Before Regions I have a PLSQL Execute Code Process that fetches the content of the fields displayed rom the database. What I am trying to achieve is:
When the content fo an Item is NULL, then the Item is not created in Session State / Page Items at all. I used the feature of View Session State and there not exist there. How can I force the "creation" of this Item with the initial value of/NULL in these cases?
I have a button in the Dialog Box and I want to execute an PLSQL code (for example Apply Changes). I do not want to submit the page as it will flicker the box. The button has a Behaviour Type: Defined by Dynamic Action on it and the Dynamic Action is on Event: On Click on this button. It has a True action of Type Execute Server side code that does the update. How can I get in this scenario the values of the modified items taht the user types on the fields to utilise in the PLSQL code for the update, since there is no submitting?

Thank you In Advance!

Kindest regards,
Dionisis Kontominas

This post has been answered by Dionisis on Nov 26 2022
Jump to Answer
Comments
Post Details
Added on Nov 26 2022
1 comment
500 views