The proc loads multiple tables using a file at a time. I have try catch bloc for the whole proc. If an error occurs anywhere in the proc, i rollback and trap the error in the catch and mark that file with an error and the process exits. But i need to find a way to continue the process despite the error. Due to sensitivity of the data i am unable to post my code here.Thanks.