Toad World® Forums

PL/SQL Question

I realise this is not the corrrect forum, but I am unable to raise questions in the correct one.

HOW do I display error messages from an Oracl session in READABLE format in TOAD ?

On 11/10/13 00:18, d.james wrote:

I realise this is not the corrrect forum, but I am unable to raise
questions in the correct one.

HOW do I display error messages from an Oracl session in READABLE format
in TOAD ?
I use DBMS_UTILITY.FORMAT_ERROR_STACK to give me a formatted error stack of the trail of errors/exceptions that led my PL?SQL to abort. I don’t know if it’s what you need, but it’s a start.
Translating all the Oracle error codes into something resembling English, for example, would be a horrendous task.
You can also use SQLERRM to get the error message for the most recent error and SQLCODE to get the actual error code.
HTH
– Cheers,
Norm. [TeamT]