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!

Execute validation

FC60Mar 10 2017 — edited Mar 11 2017

Hi,

I create a validation for holidays availability.

I have the fields f1, f2, f...

I use pl/sql function body return boolean and my algorithm is ok when I update the record. If the employee asks days <= total days I can update, if not I have an error message.

When I create a new record, I can type 1000 days but I don't have the error.

Why?

pastedImage_1.png pastedImage_0.png

This post has been answered by mark123 on Mar 11 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2017
Added on Mar 10 2017
1 comment
193 views