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!

Validations - Check Against Database Table

Jay Campos4 hours ago

Hello everyone,

I am reaching out as I wanted to ask how everyone would approach the following:

It seems like the APEX Value Required validation performs a check on the client/browser side but does not actually check if the value is not null from within the database table.

I put a value on a field, did not save changes, and the validation passed.

Only ideas that come to mind is a validation per item checking if it is not null in the db table itself or probably via a procedure/function.

Context: I have the columns as nullable to allow users to return and save progress.

Overall looking for a solution:

  1. Validates if the field is not null from the table itself
  2. Doesn't impact performance too much

Thanks,

Jay

Comments
Post Details
Added 4 hours ago
0 comments
15 views