I'm returning to APEX development after an absence. I'm hitting a problem that I can't remember how to solve. I have an item which gets its value from a computation. DEBUG output shows that the computation is saving the proper value. Then there is a RESULT = line and another line where the New Value is empty. Where does the RESULT come from and why is there the second line, how do I get rid of them?
| 0.74073 | 0.00037 | ...Perform computation of item: P2_FIT_EXPRESS_DECOMM_CD, type=FUNCTION_BODY | 4 | 
|
| 0.74110 | 0.00097 | ...Performing function body computation | 4 |
|
| 0.74209 | 0.00284 | ...Execute Statement: declare function x return varchar2 is begin BEGIN IF :P2_QUIESCENT_CD = 'Y' AND :P2_REALLY_HAVE_DBMS_DATA = 'Y' AND :P2_SINGLE_DISPOSAL = 'Y' AND :P2_ONGOING_MIGRATION = 'N' AND :P2_LEGAL_HOLD = 'N' AND :P2_SATISFY_DATA_RETENTION = 'Y' AND :P2_ALTERNATIVE_IN_USE = 'N' AND :P2_APPLICATION_DEPENDENT = 'N' AND :P2_DBMS_SUPPORTED = 'Y' AND :P2_EXTENSIVE_ARCH_REPORTING = 'N' THEN :P2_FIT_EXPRESS_DECOMM_CD := 'Y'; ELSE :P2_FIT_EXPRESS_DECOMM_CD := 'N'; END IF; END; return null; end; begin wwv_flow.g_computation_result_vc := x; end; | 4 |
|
| 0.74492 | 0.00170 | ...Session State: Saved Item "P2_FIT_EXPRESS_DECOMM_CD" New Value="Y" | 4 |
|
| 0.74661 | 0.00072 | ......Result = | 4 |
|
| 0.74733 | 0.00037 | ...Session State: Saved Item "P2_FIT_EXPRESS_DECOMM_CD" New Value="" |