Hi All,
we have requirement , i have created the procedure inside there will be updated statement. if update statement peform more thatn 3 minutes ,Need to skip the statement and proceed futher.
Ex.
Begin
Update Emp set emp_sal = emp_sal * 100
where emp_id = '12234';
INSERT INTO DEP (ID, NAME) VALUES ('01','ADSFAS');
COMMIT;
END;
above update statement perform more than 3 minutes , need to skip the statement and proceed insert statement in the following.
Need your help to adivise how to write the program.