| Error Messages Handling in Report [message #489629] |
Tue, 18 January 2011 03:33  |
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 #489644 is a reply to message #489640] |
Tue, 18 January 2011 05:09  |
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
|
Senior Member |
|
|
MAVRIC wrote on Tue, 18 January 2011 04:50BEGIN
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 #489662 is a reply to message #489654] |
Tue, 18 January 2011 06:56 |
cookiemonster
Messages: 13962
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
