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
see my error frm-40735 post query
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
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
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
<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
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
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
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
Code: Select all
Begin
Ur Statments Goes here...
If :cheqno is not null then
-----
-----
End if;
Exception
When No_DATA_FOUND then
NULL;
End;
Muhammad Kashif
Who is online
Users browsing this forum: No registered users and 0 guests