Re: Possible bug in Oracle?

My *guess* is that there is a trigger on the table which is trying to look up another table and returning the 'No records found' error back.

Check for triggers on the table and handle the 'no data found' error.

select trigger_body, TRIGGERING_EVENT
from user_triggers
where upper(table_name) = upper(<table>)

HTH, M

p_byrne76_at_hotmail.com (Pascal Byrne) wrote in message news:<c1d21c59.0110260612.79b90b12_at_posting.google.com>...
> I am getting inconsistant results when accessing a table. When I
> select from the table I get two rows. When I try deleting or inserting
> I get 'ORA-01403' e.g.
>
> SQL> select count(*)
> 2 from log;
>
> COUNT(*)
> ----------
> 2
>
> SQL> delete from log;
> delete from log
> *
> ERROR at line 1:
> ORA-01403: no data found
>
> SQL> insert into log values (sysdate,'','',1,'',1,'');
> insert into log values (sysdate,'','',1,'',1,'')
> *
> ERROR at line 1:
> ORA-01403: no data found
>
> Is this a bug in Oracle? I am using 8.0.5 on Linux.
>
> Thanks,
> pascal
Received on Wed Oct 31 2001 - 14:41:19 CET