ORA-1403 when trying to select after Insert [message #682537] |
Tue, 27 October 2020 18:58 |
|
pjizquierdo
Messages: 2 Registered: October 2020
|
Junior Member |
|
|
Hello,
I have two procedures in the same package, one for insert and another for process the registry first inserted. For avoiding inconsistent data in case of an error in the second procedure, I don't commit after the insert on the insert procedure, but in the process procedure I need to select data from that registry recently inserted. That used to work very well and I have many other procedures that work perfectly doing the same, but recently this one started to fail, giving me an ORA-1403 when I try to select.
The example is the following:
Procedure Insertrows
Insert into table a
(a.field1, a. field2, a.field3, a.field4)
values
(xxx,yyy,www,zzz);
Procedure Processrows
Select field1, field2, field3, field4
into vfield1, vfield2, vfield3, vfield4
from table a
where a.field1 = xxx
and a.field2 = yyy;
I hope someone can guide me why this was working and now is not.
Thank you!
|
|
|
|
Re: ORA-1403 when trying to select after Insert [message #682539 is a reply to message #682537] |
Tue, 27 October 2020 20:56 |
flyboy
Messages: 1903 Registered: November 2006
|
Senior Member |
|
|
Hello,
so, what changed recently outside Oracle?
Based on your description, the procedure PROCESSROWS is called in different database session than INSERTROWS.
I would start investigating the actual call flow - the tool which calls these procedures.
|
|
|
|
|