This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 753
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: 1121

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: 753
oh ok.. thanks for the reply... it helped me a lot...
 
Consider Paul's rocket mass heater.
 
subject: ORA-01403: no data found + Oracle + Trigger
 
Similar Threads
How to set the limit for primary keys
modifing data when Trigger fires
JDBCRealm Oracle Error ORA-01403 - no data found
Error calling stored procedure !!
Problem with Pl/Sql function when calling in java