Toad World® Forums

Display error console


#1

Hi

If I have the statement (see example bellow) and I get an error the error console in the editor and in the spool tab will show the errors in the same line (it will ignore linebreak)

–CODE Example (where TESTE makes a select that will raise a no data found exception)

DECLARE
Return_Value NUMBER;
BEGIN
Return_Value := TESTE(11);
dbms_output.put_line( Return_Value);
END;

The error will be displayed in the error console and in the spool tab as
ORA-01403: não foram encontrados dadosORA-06512: na “FUSER.TESTE”, linha 1505ORA-06512: na linha 4

But in the Output window and if you use the option copy in the error console you get

ORA-01403: não foram encontrados dados
ORA-06512: na “FUSER.TESTE”, linha 1505
ORA-06512: na linha 4

Maybe for the 6.3?
Thanks
Filipe

Message was edited by: Fsilva


#2

Filipe,

I raised a similar problem a while ago:

http://sqlnavigator.inside.quest.com/thread.jspa?messageID=28171&#28171


#3

Hi Dominique

You are right. It’s the same, also reporting the same problem in the spool tab.

thanks
Filipe


#4

Hi guys,

This bug is logged but will not be fixed in this release unfortunately. It will be fixed soon in 6.3.

Gwen

Message was edited by: Gwen