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.