Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Updating a Time / Date stamp on a record

RKDMay 16 2011 — edited May 24 2011
Hello:

I am currently using the following logic to place a sysdate stamp on a record when it is changed. However, I'd like to update this field each time the record is modifieds. However, the logic I am using is only capturing and retaining the first change date. Can someone please help me to understand how I can overwrite the old information with a current date stamp?

Set the Source of the Item as:
Source Used: "Always, replacing any existing value in session state"
Source Type: "Database Column"
Maintain Session State: Per Session
Source value or expression: Last_Updated_On (This is the name of the DB Column)
Default Value: sysdate
Default Value Type: PL/SQL Expression

Thank you very much for your help.

Regards,
RKD
This post has been answered by TexasApexDeveloper on May 16 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 21 2011
Added on May 16 2011
2 comments
515 views