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.
posted 8 years ago
oh ok.. thanks for the reply... it helped me a lot...