URGENT (MENUE PARAMETER)
Can any one solve my problem that is
I create a menu parameter named "MA" in menu Module and
i use this code in
BEGIN
QUERY_PARAMETER('&MA');
if TO_NUMBER(:MA)= 1 then
EXIT_FORM;
else
next_record;
end if;
END;
When i execute this the error FRM-21011 Unhandled Exception ORA-06502
I KNOW THAT ORA-06502 is a numeric conversion error AND I TRIED EVERYTHING BUT NO SUCCESS.
what SHOULD i do
Help me
thanks