Home » SQL & PL/SQL » SQL & PL/SQL » ORA-1403: ORA-01403: no data found
ORA-1403: ORA-01403: no data found [message #114985] Wed, 06 April 2005 12:29 Go to next message
Habeeb
Messages: 57
Registered: August 2000
Member
I got this error on the code below, I know this is only for select, I cannot recreate the error as the data is lost.
Below is the error:
A fatal error occured at RS003f
ORA-1403: ORA-01403: no data found

Code:

IF l_active = 'Y'
AND l_ssn <> ' ' THEN
BEGIN
l_procedure := 'RS003f';
INSERT INTO rti_intrf(tran_id,
ssn_id,
tran_cd,
add_dt,
add_id)
VALUES(l_tran_id,
l_ssn_nbr,
'B',
SYSDATE,
'RS003');
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE = -1 THEN
BEGIN
UPDATE rti_intrf
SET tran_cd = 'B',
add_dt = SYSDATE,
add_id = 'RS003'
WHERE tran_id = l_tran_id
AND ssn_id = l_ssn_nbr;
END;
ELSE
l_rtncode := SQLCODE;
l_rtntext := SQLERRM;
RAISE e_call_exception;
END IF;
END;
END IF;

Thanks to all!
Re: ORA-1403: ORA-01403: no data found [message #114999 is a reply to message #114985] Wed, 06 April 2005 14:01 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Not the cause of the exception, but that exception handling should be:

when dup_val_on_index then
  update ...
when others then
  l_rtncode := SQLCODE;
  l_rtntext := SQLERRM;
  RAISE e_call_exception;
end;


Is there a trigger on this table that is firing on insert and/or update?
Previous Topic: Tough sql : dare to solve this?
Next Topic: Run SP inside another SP
Goto Forum:
  


Current Time: Fri Jan 19 18:14:52 CST 2018

Total time taken to generate the page: 0.01482 seconds