This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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


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: 761
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: 1138
    
    1

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: 761
oh ok.. thanks for the reply... it helped me a lot...
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: ORA-01403: no data found + Oracle + Trigger
 
It's not a secret anymore!