Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01403 No data found on INSERT

456892Sep 29 2005 — edited Jun 28 2006
Hello,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 26 2006
Added on Sep 29 2005
7 comments
5,244 views