ORA-01403 No data found on INSERT
456892Sep 29 2005 — edited Jun 28 2006Hello,
We have a program that does a lot of inserts in a simple table. Every now and then, we get the error ORA-01403 NO DATA FOUND.
Our program is written in Delphi 7. We use the Oracle Data Access Components (ODAC, by CoreLab) to access the database.
I read in the Oracle docs that the error is generated by a select statement, but we use something like:
"insert into BLAH (BLAH_ID, BLAH_VAL, BLAH_STATUS) values (15,'Test',10)"
The table (BLAH) and all related tables do not have triggers (with "select into"). We don't use stored procedures or functions.
I activated AUDIT, but apparently this error isn't logged in the AUDIT-tables (others are, so the AUDIT works).
Anyone any suggestions?
Regards,
Gert