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!

Disabled items are null in update

Rene W.Sep 16 2011 — edited Sep 19 2011
To continue an older thread:
9705857

I am continuously having problems with disabled items. Especially in cases where some form of authorization is in place. Some users are allowed to make changes to certain items, for other users they are hidden using authorization scheme security.

As Jarola points out in the previous thread, disabled items should not be submitted.

The problem is that Apex does submit them.

Disabled items are submitted with a null value. Thus bypassing the default values that are defined in either the apex application or in the database table.

How do I get around this problem? Create my own DML processing? Database triggers to handle null values? I don't really need a 3rd place to define default values.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 17 2011
Added on Sep 16 2011
3 comments
1,261 views