see my error frm-40735 post query

[mfa786]

Sir I use this code in post query event


:partyname :='';
:CHQBANK :='';
:repchq:='';
:chqdate:=null;
:chqbank:='';
:PARTYNAME :='';

select YEARID,TITLE,STDATE,CLDATE,CLOSINGSTATUS into :yearid,:yeartitle,:ysdate,:yedate,:YSTATUS from yeartable where stdate<=:entdate and cldate>=:entdate;
if :partyid is not null then
select title into ARTYNAME from partytable where partyid=:partyid;
end if;


:repchq :=substr(:cheqno,10,8);

if :CHEQNO is not null then
SELECT nvl(CHARTOFACC.title,' ') INTO :chqbank FROM CHEQMASTER,CHEQDETAIL,CHARTOFACC WHERE CHEQDETAIL.serialid=CHEQMASTER.serialid AND CHEQMASTER.accid=CHARTOFACC.accid and CHEQDETAIL.CHEQNO=:CHEQNO;

end if;


sir when :CHEQNO not null system give me right result but when :CHEQNO is null then system give me this error


FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403

If I revome this code

if :CHEQNO is not null then
SELECT nvl(CHARTOFACC.title,' ') INTO :chqbank FROM CHEQMASTER,CHEQDETAIL,CHARTOFACC WHERE CHEQDETAIL.serialid=CHEQMASTER.serialid AND CHEQMASTER.accid=CHARTOFACC.accid and CHEQDETAIL.CHEQNO=:CHEQNO;
end if;
then system run right
please give me idea how I solve this error

thank
aamir

[Kashif]

<b> if :CHEQNO is not null then </b>
this statement is returning true Result.
Check the Field :CHEQNO, there should be definetly any value which is causing to IF Statement to return TRUE.


Best Regards.

Muhammad Kashif

[mfa786]

thanks for your reply

Sir this is optional field is if amount less then 5000 then not pad through cheq and :cheqno must be null if garter then 5000 then pad through cheq mustbe give value in :cheqno

how i check :cheqno at navigation or query time or fatching time

if i found :cheqno have value then i run my code

if :CHEQNO is not null then
SELECT nvl(CHARTOFACC.title,' ') INTO :chqbank FROM CHEQMASTER,CHEQDETAIL,CHARTOFACC WHERE CHEQDETAIL.serialid=CHEQMASTER.serialid AND CHEQMASTER.accid=CHARTOFACC.accid and CHEQDETAIL.CHEQNO=:CHEQNO;

end if


or i found :cheqno not have value then i not run my code



i use this code
if :CHEQNO is not null then
but system not give me right result

please give me idea how i check :cheqno


thanks

aamir

[Kashif]

if :CHEQNO is not null then
<b> Message (:CHEQNO);Message (:CHEQNO); </b>
SELECT nvl(CHARTOFACC.title,' ') INTO :chqbank FROM CHEQMASTER,CHEQDETAIL,CHARTOFACC WHERE CHEQDETAIL.serialid=CHEQMASTER.serialid AND CHEQMASTER.accid=CHARTOFACC.accid and CHEQDETAIL.CHEQNO=:CHEQNO;
end if

Add this Code just for Checking Purpose that is there any value in this Field or Not

Best Regards.

Muhammad Kashif

[mfa786]

Hi master

Sir this error crate may problem for me
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403

sir how I avoid I this error and show my message
or system not show this error and bypass this error

please send me code how I avoid this error

thanks

aamir

[mirza_rehan]

Hello aamir why you are not usein exceptions????? you and making software and not using exceptions???? why????????

Use When no_Data_Found, When Too_Many_Rows, When Others.....

etc.

regards,
R E H A N M I R Z A

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family

[mfa786]

thanks for your reply

sir

please send me the sample code of

exceptions????

When no_Data_Found, When Too_Many_Rows, When Others.....

how i use exceptions, When no_Data_Found, When Too_Many_Rows, When Others..... in form

please give me idea thank

aamir

[Kashif]

Code: Select all

Begin

Ur Statments Goes here...

If :cheqno is not null then
-----
-----
End if;

Exception
  When No_DATA_FOUND then
   NULL;
End;

Best Regards.

Muhammad Kashif