OraFAQ Forum: Forms » FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403

Home » Developer & Programmer » Forms » FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403 (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403 [message #186524]

Tue, 08 August 2006 05:52

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

Report message to a moderator

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

joy_division
Messages: 4963
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.

Report message to a moderator

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

Littlefoot
Messages: 21818
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>

Report message to a moderator

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

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

Report message to a moderator

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Previous Topic:	Form Design
Next Topic:	Open external applications

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:18:27 CDT 2024