DISPLAY ONLY CUSTOM MESSAGE WITH SRW.MESSAGE
39713Jul 1 2004 — edited Apr 16 2010Hi.I created a report with Report Builder 9i.I also created two form parameters of type date.I put inside the validation trigger in the property inspector the following plsql code.
function FROM_DATEValidTrigger return boolean is
v_date VARCHAR2(12);
date1 date;
begin
v_date := :from_date;
date1:=TO_DATE(v_date, 'DD/MM/YYYY');
return (TRUE);
EXCEPTION
WHEN OTHERS THEN
SRW.MESSAGE(546,'My Message');
return (FALSE);
end;
This code works fine.Supose the user input wrong data for example 29/02/2003 displays an alert message
with my custom message.But after this displays an another message from the Report Builder like this:
Rep-0546:Invalid parameter input.
My question is .Is it possible display only my custom message with the SRW.MESSAGE built in procedure?
Thanks in advance Panagiotis.