exception message box limits text to 1024 characters

[Worker]

With the following in a test window:

begin
	raise_application_error(-20000, rpad('x',999,'x') );
end;

I copy the following text from the pop-up message:

ORA-20000: [999 x-es]
ORA-06512: a

The message text is being truncated to 1024 characters, even though you can get much more from an Oracle exception. raise_application_error() alone accepts messages up to 2048 bytes long.

 

[Marco Kalter]

This stack dump (including the ORA-06512) is returned by the Oracle Server as a single string, so there is not much chance that we can enhance this. We'll check it out though.

 

[Worker]

My apologies, I assumed this was something PL/SQL Developer was doing. I see now that SQL*Plus has the same behavior.