Handling Multiple Error Messages

[ToddL]

There are times when I'm testing a stored procedure from SQL*Plus and an error occurs. What is returned, at times, are multiple errors from different stored procedures since I have sp's calling other sp's and functions. So, I end up with a chain of errors.

How can I get the complete chain of errors using EOracleError so I can log them to a file or display to the user?

Thanks,
Todd

 

[Marco Kalter]

There is always just one exception that is propagated to the client, regardless if this is SQL*Plus or your application. This may of course be a call stack if the PL/SQL exception occurs within a stored program unit that was called from another stored program unit or trigger. In that case the EOracleError.Message will contain the error message with the complete call stack.