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!

The NULL value of a POPUP LOV

Christian PitetApr 15 2016 — edited Apr 20 2016

Hi,

I try to validate a Popup LOV item P41_CD_NOM to check if it is populated. Unfortunately, when I test it for a NOT NULL value, the validation is not triggered. I have been googling for the null value Popup LOV problem and found that '%null%' or 'undefined' was returned. I tried to test for these values but could not trigger the validation as well.

For example :

:P41_CD_NOM = '%null%' ORĀ  :P41_CD_NOM = 'undefined' OR :P41_CD_NOM = 'null';

is not working

How to solve that problem ? I cannot go for a simple LOV because there are too much values in the select list.

Thank you for your kind help !

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2016
Added on Apr 15 2016
5 comments
1,582 views