This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan 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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 751
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: 751
oh ok.. thanks for the reply... it helped me a lot...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ORA-01403: no data found + Oracle + Trigger
 
Similar Threads
Error calling stored procedure !!
JDBCRealm Oracle Error ORA-01403 - no data found
How to set the limit for primary keys
Problem with Pl/Sql function when calling in java
modifing data when Trigger fires