oracle-apexoracle-apex-20.2

Oracle APEX: Dynamic SetValue is not working

On Page Load I need to set a value of page item P1_ITEM2 based on the value of the application item APP_ITEM1

I created the following DA on page load:

Action: SetValue

Set Type: PL/SQL Expression 

PL/SQL Expression: package1.my_function(:APP_ITEM1)

Items to submit: APP_ITEM1

Affected Elements
Selection type: Items
Items: P1_ITEM2

Nothing gets set. Not sure what is going on

Solution

    1. Create an After Header Computation for the page item.(In your case P1_ITEM2)

    2. Select the Type as Function Body and paste your function call (In your case package1.my_function(:APP_ITEM1))