hi

I start a SQL stored proc to update some tables from a java program but i want that if that takes a long time say more than 3 hrs then the processing of that proc is stopped and the control moves on to the next proc.

How can i do this ?

regards 
saurabh gaur