no raised exception on : error ORA-01403: No data found ??

  • Thread starter Thread starter toto
  • Start date Start date
T

toto

Hello,
I use oracle 9.2,
I have a trigger on a table.
When I update my table the trigger generate the error:
error ORA-01403: No data found
But no exception is generated with my System.Data.OracleClient so in
my c# code I don't know that an error occured!!
Why ?
What can I do to detect the error?
 
Hello,
I use oracle 9.2,
I have a trigger on a table.
When I update my table the trigger generate the error:
error ORA-01403: No data found
But no exception is generated with my System.Data.OracleClient so in
my c# code I don't know that an error occured!!
Why ?
What can I do to detect the error?
Click to expand...

A trigger is ran inside the update statement transaction. This means that it
will roll back the update transaction, which will result in a 0 being
returned from ExecuteNonQuery, or better: 0 rows affected. This means that
you can test if something failed by testing the returnvalue.

Frans.
 
I have found the correct answer:
This behaviour was corrected in SP1 of the framework.
Now I have my exception correctly raised!
 
Back
Top