| Oracle Reports 6i Error "REP-0771: AFter Form trigger failed. [message #430803] |
Thu, 12 November 2009 06:35  |
cornwall
Messages: 36
Registered: June 2009
|
Member |
|
|
I have created a simple report with a parameter which i would like to validate and only display the report if the value is a valid value.
If the parameter value is null or does not exist on a table then i would like to display a message "Please Supply a valid reference".
I am validating the parameter by using a function to return a true or false value if the reference exists.
However when the value is not valid, my message correctly appears but also an error message appears ":REP-0771: After Form trigger failed'".
My code is as follows:
function AfterPForm return boolean is
begin
If XXWMS.xxwm_transportation.validate_trailer(:Ptrailerref) Then
return (TRUE);
else
srw.message(101,'Please enter a valid Trailer Reference');
return (False);
--raise SRW.PROGRAM_ABORT;
end if;
end;
Any help to progress this would be APPECIATED.
|
|
|
|
|
|
|
|
| Re: Oracle Reports 6i Error "REP-0771: AFter Form trigger failed. [message #430830 is a reply to message #430822] |
Thu, 12 November 2009 07:45  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
I don't think that you can avoid a message.
You could, though, return TRUE (but that would run the report anyway). Or, use SRW.PROGRAM_ABORT which would, in turn, cause REP-1419 (PL/SQL program aborted) but leave the Parameter Form open.
So the question is: do you prefer REP-0771 over REP-1419 or not?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
