Home » Developer & Programmer » Reports & Discoverer » Oracle Reports 6i Error "REP-0771: AFter Form trigger failed. (Oracle Reports 6i, DB = 9.2.5.0)
Oracle Reports 6i Error "REP-0771: AFter Form trigger failed. [message #430803] Thu, 12 November 2009 06:35 Go to next message
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 #430815 is a reply to message #430803] Thu, 12 November 2009 06:57 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
bradsj wrote on Thu, 12 November 2009 06:37
However when the value is not valid, my message correctly appears but also an error message appears ":REP-0771: After Form trigger failed'".



What is this in your post?
XXWMS.xxwm_transportation.validate_trailer

And please avoid multi postings.

Read Orafaq Guide Lines Before Posting.

Sriram
Re: Oracle Reports 6i Error "REP-0771: AFter Form trigger failed. [message #430822 is a reply to message #430815] Thu, 12 November 2009 07:26 Go to previous messageGo to next message
cornwall
Messages: 36
Registered: June 2009
Member
What is XXWMS.xxwm_transportation.validate_trailer?

This is a call to a function which returns a boolean value by checking that the entered value exists on an oracle table.
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 Go to previous message
Littlefoot
Messages: 20900
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?
Previous Topic: Disoverer workbook cant open "you don't have write permission for file"
Next Topic: Show parameter field value in margin text box
Goto Forum:
  


Current Time: Wed Dec 07 23:58:54 CST 2016

Total time taken to generate the page: 0.11693 seconds