Hello,

we are having a requirement for logging the steps in stored procedure.

However, the problem is that if any step errors out, the entire procedure, including the logging (done by calling logging procedures in main procedure) gets rolled back. Hence neither can we see the changes done by the successful steps above the error step nor is any sort of logging recorded (for earlier successful steps and the errored step).

Is ther a way to resolve this.

Can Autonomous transaction be used in Netezza?

Thanks,

Parag