REP-1419:'Afterreport': PL/SQL program aborted [message #470642] |
Tue, 10 August 2010 06:42 |
|
stalin4d
Messages: 226 Registered: May 2010 Location: Chennai, Tamil Nadu, Indi...
|
Senior Member |
|
|
Dear,
I have given the below code for a report, report runs good, but after closing report window i m receiving the error code:
Quote:REP-1419: 'afterreport': PL/SQL program aborted.
function AfterReport return boolean is
cnt number;
begin
select count(*) into cnt
from opcl
where fiscal_yr_cd = :P_Fiscal_Yr
and Period_no = :P_Period;
if cnt > 0 then
raise SRW.PROGRAM_ABORT;
else
insert into opcl (fiscal_yr_cd,Period_no,Col1,Col2,Col3,Col4,Col5,Col6)
Values (:P_Fiscal_yr,:P_Period,nvl(:total_credit,0), nvl(:total_cess_cf,0),
nvl(:total_sec_cess_cf,0), nvl(:cf_tot_serv_tax1,0), nvl(:cf_tot_serv_tax2,0),
nvl(:cf_tot_serv_tax3,0));
commit;
end if;
return (TRUE);
end;
can you help to resolve this?
Thanks in Advance.
Stalin Ephraim...
|
|
|
|
|
Re: REP-1419:'Afterreport': PL/SQL program aborted [message #470672 is a reply to message #470667] |
Tue, 10 August 2010 07:26 |
|
vamsi kasina
Messages: 2112 Registered: October 2003 Location: Cincinnati, OH
|
Senior Member |
|
|
Quote:SRW.PROGRAM_ABORT
Description: This exception stops the report execution and raises the following error.
message: REP-1419: PL/SQL program aborted.
SRW.PROGRAM_ABORT stops report execution when you raise it. If you want come out from the procedure/function, why can't you just use RETURN?
By
Vamsi
|
|
|