This content has been marked as final. Show 2 replies
Let me explain in simple.
Create an hidden item p1_date
Create a computation in the page processing section that is the middle block of the frame work
SELECT SYDATE FROM DUAL on the item P1_DATE and it should work.
Populating an item like this from the page processing section means that the value won't be placed in the item until the page is submitted. If the value is needed before then, the OP would be out of luck. Besides that, it's more complex than is really required.
Set the 'Source Used' of the hidden item to 'Always, replacing any value in session state'
Set the 'Source Type' to PL/SQL Function Body
Set the 'Item Source Value' to:
If you want the date to be in the field in a specific format, then use TO_CHAR in your RETURN statement.
BEGIN RETURN SYSDATE; END;