I am in the process of designing tables to capture the errors occurred while processing a pl/sql package and compute staistics like how many errors occurred while loading a particular entity and the reason.
I am thinking of calling a stored proc in the exception handling to log
and track errors in the following table.
We have a stored package which actually does the ETL part i.e; copying the source data to the target. I would like to capture the errors at every entity level.
It would be of great help if you can give your valuable opinion, examples or suggestions.
I find more comfortable and useful to use "autonomous_transaction" feature for logging errors. So that whenever you find the error, you can log the same using a procedure which uses "autonomous_transaction". So that even if you rollback after loggin the error, only the processing part willbe rolled back and your error logging will get commited.