HI: I have a modal Dialog window and I am on Apex 5.1. One item in the modal window is a seqnumber. This is a drop down using Select List.
I am wanting to output message that when user select on their seqnumber.
So I created this validation using PL/SQL Function (returning error text). But it is doesn't return any message.
Can some one give me pointers?
Display location = Inline in Notification
Associated Item = P28_seqnumber
Always execute = no
declare
v_cnt number;
Begin
select count(*) into v_cnt
from table
where seqnumber =:P28_seqnumber;
IF v_cnt > 0 THEN
RETURN '<font color="red">THIS RELEASE # IS ASSOCIATED TO A RECALL. RECALL WILL ALSO BE DELETED.<font color="red">';
END IF;
END;