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:
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