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!

How can I include "None" functionality in a LOV

376519Apr 29 2004 — edited Apr 30 2004

I am trying to setup the ability to set a value to null in a Popup LOV giving my users the None functionality. This is the SQL I use to ccreate the LOV:

select 'None'VALUE,
Null UID
from dual
UNION ALL
select VALUE,
UID
from LOOKUP_VALUE

when I select the None from the list and try to create the record I receive:

ERR ERR-1023 Unable perform validations
ORA-01722: invalid number

Any idea on how to allow None type functionality?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 28 2004

Added on Apr 29 2004

#apex-discussions

4 comments

392 views