Passing an Oracle SP error message to Informatica Email Task

[sa0309]

I have an unconnected Oracle Stored Procedure that I'm running in a workflow.

In the Stored Procedure I have logic to invoke RAISE_APPLICATION_ERROR based upon a condition:


if nDupRows > 0 then

v_Err_Msg := 'Duplicate rows exists between Table_A and Table_B. Processing stopped until a resolution is found.';

RAISE_APPLICATION_ERROR(-20001, V_ERR_MSG);

else

........



Is there a way that I can pass v_Err_Msg back to an email task in the workflow. I can see this error in the attached session log that gets sent upon failure. However I'd like to display the v_Err_Msg in the body of the email as well.

Any thoughts and / or suggestions would be appreciated.

Thank you!