Hi,

I have a procedure where I have put in a simple exception body to capture the sql error (if recieved) during the execution of the procedure. For example:

exception
when others then
v_sqlerrm := sqlerrm;
... (and so on)

This eventually emails the string captured in v_sqlerrm.

However, what I find is this. If I remove the exception body and the procedure errors (on purpose), this is what I would normally get from SQLPLUS Worksheet:

ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "my.procedure", line 243
ORA-06512: at line 1

However, when the exception bidy is in place, the string that is ONLY captured is this:

ORA-01422: exact fetch returns more than requested number of rows

How do I do it so that I get all the error messages that normally appears in SQLPLUS Worksheet??