Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
The moose likes JDBC and Relational Databases 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


Win a copy of The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 760
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: 760
oh ok.. thanks for the reply... it helped me a lot...
 
Have you tried LearnNowOnline? http://www.learnnowonline.com/
 
subject: ORA-01403: no data found + Oracle + Trigger