Home » Developer & Programmer » Forms » FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403  () 1 Vote
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403 [message #186524] Tue, 08 August 2006 05:52 Go to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member
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 :PARTYNAME 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



Re: FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403 [message #186555 is a reply to message #186524] Tue, 08 August 2006 08:27 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
mfa786 wrote on Tue, 08 August 2006 06:52


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

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



Padwan:

Without using exception handling, this is the expected result.
Re: FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403 [message #186633 is a reply to message #186555] Tue, 08 August 2006 15:55 Go to previous messageGo to next message
Littlefoot
Messages: 20899
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Although exception handlers are the right way to deal with errors, there's yet another way to avoid NO-DATA-FOUND - use an aggregate function in the select statement.

This ends with an error:
SQL> declare
  2    l_name emp.ename%type;
  3  begin
  4    select ename into l_name from emp where deptno = 100;
  5  end;
  6  /
declare
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 4

But this will be OK:
SQL> declare
  2    l_name emp.ename%type;
  3  begin
  4    select max(ename) into l_name from emp where deptno = 100;
  5  end;
  6  /

PL/SQL procedure successfully completed.

SQL>
sir how I avoid I this error FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403 [message #186760 is a reply to message #186633] Wed, 09 August 2006 06:52 Go to previous messageGo to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member
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


Re: sir how I avoid I this error FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403 [message #186902 is a reply to message #186760] Thu, 10 August 2006 02:05 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Put an exception into your code.
BEGIN
   SELECT nvl (CHARTOFACC.title, ' ')
     INTO :chqbank
     FROM CHEQMASTER, CHEQDETAIL, CHARTOFACC
    WHERE CHEQDETAIL.serialid = CHEQMASTER.serialid
      AND CHEQMASTER.accid = CHARTOFACC.accid
      and CHEQDETAIL.CHEQNO = :CHEQNO;
EXCEPTION
   when others then
      message (sqlerrm);
END;
Also you have NOT specified the 'block' for ':chqbank' or ':CHEQNO'.

David
Previous Topic: Form Design
Next Topic: Open external applications
Goto Forum:
  


Current Time: Wed Dec 07 14:19:26 CST 2016

Total time taken to generate the page: 0.08980 seconds