Apex 5 : Dynamic action set page item value

5
votes

When using the new apex 5 release I'm encountering the following issue:

Can't get the value of page items through plsql:

nv(:P2_TO, :P2_FROM) <<< DOESN'T WORK *I Yes P@_FROM exist and verified
nv(:P2_TO, 'test') <<< DOES WORK

I have tried this both on apex.oracle.com and my own host both wont work.

Some more info:

enter image description here

enter image description here

enter image description here

2
oracle-apexoracle-apex-5
Try nv(:P3_TO, :P3_FROM) - colon before P3_FROM is missing. – Dmitriy
I am sorry I rewrote the code in here but the semi column was already there. ( APEX wont even save the page since if you make such mistake since it compiles the plsql first and this wont pass the compiler) – user1035654
Can you show more code then? Now it is impossible to say. – Dmitriy
i added the related apex screens but this is really all code there is – user1035654
And NV certainly different to NVL (you should be using COALESCE anyway) – Scott

2 Answers

15
votes

That's pretty logical. You're referencing the session state of the variables, and it is likely empty. It's not because items P2_TO or P2_FROM have a value on the page in your browser that they have a value set in session state. For example, load your page, enter a value in P2_FROM. Then click "Session" on your developer toolbar and you'll see there is no value in P2_FROM.
The value in session state can differs from the value on the actual webpage.

This is the exact reason why there are the additional property "Page Items to Submit" with actions that have to communicate with the database (ie perform an ajax request to the webserver). This allows you to define items whose value has to be sent to the server so that in effect you can use their value.

So: for this type of action, add P2_TO to the list of "Page Items to Submit"

2
votes

You could always use apex util:

APEX_UTIL.set_session_state(p_name => 'PX_MY_ITEM', p_value => 'wibble');

Example 1

APEX_UTIL.set_session_state('P1_MY_ITEM','My Text Value');

Example 2

APEX_UTIL.set_session_state('P1_MY_OTHER_ITEM', 42);

Example 3

APEX_UTIL.set_session_state('P1_MY_OTHER_OTHER_ITEM', MY_PLSQL_VARIABLE);