Comment by Jari Laine on "Tips for APEX Application Constants"

Hi Martin,

I have two cases that like understand does write to database happens:

If I create hidden item P0_APP_NAME to global page and set Storage to Per Request (Memory Only). Then create application computation before header for item.
I have hidden item P1_EMPNO where Storage set Per Request (Memory Only), and I use item in classic report Page Items to Submit. Then e.g. sort report.

Thanks advance.

Martin Giffy D'Souza

Oracle APEX Developer

Jari Laine in both cases the items will be written to "APEX Session memory" in the database. Here are the reasons:

1: When you have a application computation, the processing is done in the database and therefore is saved in your APEX Session

2: When the item is set to Page Items to Submit the same occurs. It's sent via the AJAX request, stored in APEX Session then is used in the request.

Search Hashnode