Hi Everyone,
In my application, a user makes changes to an interactive grid then presses submit. This will insert the changed entries into a different table with a change number based on my page item P8_CHANGE_NO. My page item shows the correct value:
This item gets the last change number and adds 1. This is the source SQL query:
SELECT NVL(MAX(CHANGE_NO)+1,1) FROM PRNDSINKCHANGE WHERE ITEM_CODE = :P8_ITEM_CODE;
When I click submit, I get
The value should be submitted when the page is submitted though:
Why would I be getting this null error and how can I avoid this?