• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ORA-01403: no data found + Oracle + Trigger

 
Jigar Naik
Ranch Hand
Posts: 762
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi i have created the following trigger in Oracle



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

 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 762
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
oh ok.. thanks for the reply... it helped me a lot...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic