Home » Developer & Programmer » Reports & Discoverer » Error Messages Handling in Report (Report 6i , XP)
Error Messages Handling in Report [message #489629] Tue, 18 January 2011 03:33 Go to next message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
Dear All

I am generating a report with parameter form.

I do not want users to leave a parameter value null
so I applied after parameter form trigger

function AfterPForm return boolean is
begin
IF ( :my_no IS NULL ) THEN
srw.message(101, 'Please enter proper No.');
return (FALSE);

END IF;
return (TRUE);
end;
it is working fine, it displays proper message but after my message, a default message is displayed
REP-0771: After Form Trigger Failed.
I want to avoid this message.

if i comment out return(false) then it displays message and runs the report.....
I want to avoid default oracle message and stop running report also.

waiting for some solution.

regards.
Re: Error Messages Handling in Report [message #489632 is a reply to message #489629] Tue, 18 January 2011 03:42 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
I don't believe there is a way of suppressing the message. Reports, unlike forms, doesn't appear to have that concept.
Re: Error Messages Handling in Report [message #489638 is a reply to message #489629] Tue, 18 January 2011 04:43 Go to previous messageGo to next message
MAVRIC
Messages: 3
Registered: January 2011
Junior Member

Use raise srw.program_abort

Wink

Re: Error Messages Handling in Report [message #489640 is a reply to message #489638] Tue, 18 January 2011 04:50 Go to previous messageGo to next message
MAVRIC
Messages: 3
Registered: January 2011
Junior Member

BEGIN
IF (:my_no IS NULL)
THEN
srw.MESSAGE (101, 'Please enter proper No.');
RAISE srw.program_abort;
END IF;

RETURN (TRUE);
END;
Re: Error Messages Handling in Report [message #489641 is a reply to message #489638] Tue, 18 January 2011 04:55 Go to previous messageGo to next message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
MAVRIC wrote on Tue, 18 January 2011 04:43
Use raise srw.program_abort

Wink




now this message is being displayed.
REP-1419:'afterpform':PL/SQL Program Aborted.

i want to suppress all default messages. I just want to display my own message, no other message.
Re: Error Messages Handling in Report [message #489644 is a reply to message #489640] Tue, 18 January 2011 05:09 Go to previous messageGo to next message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
MAVRIC wrote on Tue, 18 January 2011 04:50
BEGIN
IF (:my_no IS NULL)
THEN
srw.MESSAGE (101, 'Please enter proper No.');
RAISE srw.program_abort;
END IF;

RETURN (TRUE);
END;


REP-1419:'afterpform':PL/SQL Program Aborted.
and now this message is appearing after my message.
Re: Error Messages Handling in Report [message #489654 is a reply to message #489644] Tue, 18 January 2011 06:33 Go to previous messageGo to next message
MAVRIC
Messages: 3
Registered: January 2011
Junior Member

According to Oracle documentation on Reports, one can not neither trap nore change Report Builder error messages.
Re: Error Messages Handling in Report [message #489662 is a reply to message #489654] Tue, 18 January 2011 06:56 Go to previous message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
Which'd be what I said in the first place.
@myclassic - if it bothers you that much use oracle forms to create a form where the users can enter the parameters. Have that call the report. You can control messages with that. Otherwise you're going to have to live with it.
Previous Topic: Report 6i help
Next Topic: reports 10g
Goto Forum:
  


Current Time: Thu Jul 02 10:38:34 CDT 2020