OraFAQ Forum: Reports & Discoverer » Displaying an Error Message

Home » Developer & Programmer » Reports & Discoverer » Displaying an Error Message

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Displaying an Error Message [message #262070]

Fri, 24 August 2007 07:44

nishasundar
Messages: 4
Registered: August 2007

Junior Member

Hai all,
In report if i enter any parameter value(in text box) that does not match any records,i should get an error message like,
"Invalid Customer Name...." and also kindly tell me how to stop the generation of report once the error message displays.

Thanks & Regards,
S.Nisha

Report message to a moderator

Re: Displaying an Error Message [message #262075 is a reply to message #262070]

Fri, 24 August 2007 07:55

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Validate parameter's value in the AFTER PARAMETER FORM trigger.
Raise an error using the SRW.PROGRAM_ABORT built-in.

Report message to a moderator

Re: Displaying an Error Message [message #262200 is a reply to message #262075]

Sat, 25 August 2007 01:11

nishasundar
Messages: 4
Registered: August 2007

Junior Member

Hai,
Thank you for your reply.Can you please give me some examples for validate parameter's value in the AFTER PARAMETER FORM trigger.

Thanks & Regards,
S.Nisha

Report message to a moderator

Re: Displaying an Error Message [message #262262 is a reply to message #262070]

Sat, 25 August 2007 13:31

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

nishasundar

If i enter any parameter value (in text box) that does not match any records,i should get an error message

How would YOU validate parameter's value? Use pure (PL/)SQL (forget about triggers), or you can write a pseudo-code if you wish. Just don't open your mouth and say "Feed me! Feed me!".

Report message to a moderator

Previous Topic:	Setting the Default Page Size for printing (Oracle Reports 10g) (merged by LF)
Next Topic:	Problem in formatting report in arabic and english

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 11 09:50:55 CDT 2026