Calling LOV programmatically
433935Dec 26 2010 — edited Dec 27 2010Dear Friends
I have two LOV from the same field I am calling the LOV inside the KEY-LISTVAL trigger as the following :
declare
dummy boolean;
begin
IF :MAN_BILL_OF_MATERIAL_HEADER.FINISH_PROD_TYPE = 1 THEN
dummy :=show_lov('PROD_LIST',15,30);
ELSIF :MAN_BILL_OF_MATERIAL_HEADER.FINISH_PROD_TYPE = 2 THEN
dummy :=show_lov('SEMI_FINISHED',15,30);
END IF;
end;
I am getting this message Frm-40502 oracle error unable to read list of values and this
Frm-40733 pl/sql built-in show-lov failed
Waiting for your valuable answer
Best regards
Jamil