Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DISPLAY ONLY CUSTOM MESSAGE WITH SRW.MESSAGE

39713Jul 1 2004 — edited Apr 16 2010
Hi.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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2010
Added on Jul 1 2004
2 comments
7,446 views