Good morning fellow members
I'm having this situation where our application is trying to select into from a table and oracle returns ORA-01403: no data found in a randomly fashion(most of the time the query finish ok, but sometimes the error is thrown). We have tested executing the same select from SQL Developer with the same values and the query always retrieves data, so i don't know why sometimes i get the error but since this is the first time i'm facing this error i want to ask to experts on the matter.
Here a few details:
db version: Oracle RAC 11gr2
Application Languaje: Cobol
This is the query that gets the error:
select F1 ,F2 ,F3 ,F4 ,F5 into :b1,:b2,:b3,:b4,:b5 from MYTABLE where (((F1=:b6 and F3=:b7) and F4=:b8) and F5=:b9);
As always, any help will be really appreciated.
Regards