aspose file tools*
The moose likes JDBC and the fly likes ORA-01403: no data found + Oracle + Trigger Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ORA-01403: no data found + Oracle + Trigger" Watch "ORA-01403: no data found + Oracle + Trigger" New topic
Author

ORA-01403: no data found + Oracle + Trigger

Jigar Naik
Ranch Hand

Joined: Dec 12, 2006
Posts: 759
Hi i have created the following trigger in Oracle



but when i make insert on the following table reportincomingsms
it gives me following error



Jigar Naik


Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1135

Jigar,
The error message is telling you that the SELECT statement in your trigger did not return any rows.
I suggest you add an exception handler to your trigger.
No offence, but I fail to see how your question is related to this forum's topic: JDBC.
There is an Oracle forum, which is more appropriate, in my opinion.

Good Luck,
Avi.
Jigar Naik
Ranch Hand

Joined: Dec 12, 2006
Posts: 759
oh ok.. thanks for the reply... it helped me a lot...
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: ORA-01403: no data found + Oracle + Trigger