In Apex ist ein kleiner Bug, der bei LOVs keine echten Nulls zurückgibt.

Erstelle einen Application-Process (OnSubmit: After Page Submissions - Before Computatoins and Validations)
Typ: PL/SQL Anonymous Block

BEGIN
FOR rItem IN
( SELECT ITEM_NAME
FROM APEX_APPLICATION_PAGE_ITEMS
WHERE APPLICATION_ID = TO_NUMBER(:APP_ID)
AND PAGE_ID = TO_NUMBER(:APP_PAGE_ID)
AND LOV_DISPLAY_NULL = 'Yes'
AND LOV_DEFINITION IS NOT NULL
AND LOV_NULL_VALUE IS NULL
)
LOOP
IF V(rItem.ITEM_NAME) = '%null%'
THEN
Apex_Util.set_session_state(rItem.ITEM_NAME, NULL);
END IF;
END LOOP;
END;

--
Best regards,
Carsten mailto:carsten.cerny@cc13.com
My blog [cc13.com]