displaying user defined error message [message #345293] |
Tue, 02 September 2008 18:45 |
gautamvv
Messages: 254 Registered: June 2005
|
Senior Member |
|
|
function AfterPForm return boolean is
begin
if :eno1 is not null and :eno2 is not null then
:lpe:= ' and a.eno between :eno1 and :eno2';
elsif (:eno1 = :eno2) then
:lpe:=' and a.eno = '|| :eno1;
elsif :eno1 is null and :eno2 is not null then
:lpe:=' and a.eno <= '||:eno2;
elsif :eno1 is not null and :eno2 is null then
:lpe:=' and a.eno >= '||:eno1;
elsif :eno1 is null and :eno2 is null then
message(' enter the values propoerly');
raise form_trigger_failure;
else
:lpe:=null;
end if;
return (TRUE);
end;
i have the above code in my after parameter form trigger
here i am validating the parameters entered, it says
"message" must be declared, and form_trigger_failure must be
declared..
|
|
|
|