Toad World® Forums

More detail on error messages returned to TOAD

Is there a way of getting TOAD to report back more detail on error messages? We have seen Oracle’s SQL Developer report back more information than we are getting by default in SQLPlus and TOAD.

TOAD and SQLPlus report back what is shown below, but only down to “ORA-06512: at line 1”. SQLDeveloper adds the bottom three lines. Can TOAD also report these additional lines?

Error starting at line 1 in command:
execute mytest
Error report:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at “OE.MYTEST”, line 4
ORA-06512: at line 1
01422. 00000 - “exact fetch returns more than requested number of rows”
*Cause: The number specified in exact fetch is less than the rows returned.
*Action: Rewrite the query or change number of rows requested