[SQL] catching errors in function

[padmanabha konkodi]

 
hello sql developers,

i have written function in which while executing it may throw error.
if the error thrown i want rollback the transaction if not i want commit.

how can i achive this task.

how can catch exception thrown in the function

plz help me


regards
konkodi