Script errors display as 1 line for each script in the Error tab of the Script Output window even though the message has mulitple errors with newlines. Is it possible to format the errors as a treeview with a node for each error?
I currently copy the output to another editor to read the error easier.
Thanks
Hi Raymond,
Could you provide a sample script and a screenshot of the Error tab?
Thanks
Same test PL/SQL script run twice. I get 1 line per script. Each line contains 8 errors formatted with line breaks
[Warning] ORA-24344: success with compilation error
3/1 PLS-00103: Encountered the symbol "BEGIN" when expecting one of the following:
( ;
The symbol ";" was substituted for "BEGIN" to continue.
4/34 PLS-00103: Encountered the symbol ";" when expecting one of the following:
( - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
continue avg count current exists max min prior sql stddev
sum variance execute forall merge time timestamp interval
date <a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character set specification>
<an alternatively
5/34 PLS-00103: Encountered the symbol ";" when expecting one of the following:
( - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
continue avg count current exists max min prior sql stddev
sum variance execute forall merge time timestamp interval
date <a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character set specification>
<an alternatively
6/34 PLS-00103: Encountered the symbol ";" when expecting one of the following:
( - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
continue avg count current exists max min prior sql stddev
sum variance execute forall merge time timestamp interval
date <a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character set specification>
<an alternatively
7/34 PLS-00103: Encountered the symbol ";" when expecting one of the following:
( - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
continue avg count current exists max min prior sql stddev
sum variance execute forall merge time timestamp interval
date <a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character set specification>
<an alternatively
8/34 PLS-00103: Encountered the symbol ";" when expecting one of the following:
( - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
continue avg count current exists max min prior sql stddev
sum variance execute forall merge time timestamp interval
date <a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character set specification>
<an alternatively
9/34 PLS-00103: Encountered the symbol ";" when expecting one of the following:
( - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
continue avg count current exists max min prior sql stddev
sum variance execute forall merge time timestamp interval
date <a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character set specification>
<an alternatively
10/34 PLS-00103: Encountered the symbol ";" when expecting one of the following:
( - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
continue avg count current exists max min prior sql stddev
sum variance execute forall merge time timestamp interval
date <a string literal with char (1: 0): Warning: compiled but with compilation errors
Mouse over the line shows a popup with the entire message but display is inconsistent. Sometimes I can trigger the popup sometimes I can't.
Now I'm getting an Access violation error when I click on the Errors tab pane.
Here is the call stack info:
Steps to reproduce:
------------
8.1 Text:
Call Stack Information:
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Methods |Details|Stack |Address |Module |Offset |Source |Unit |Class |Procedure/Method |Line |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|*Exception Thread: ID=22400; Parent=0; Priority=0 |
|Class=; Name=MAIN |
|DeadLock=0; Wait Chain= |
|Comment= |
|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|7FFFFFFE|03 |0000000000000000|00000000043559C1|Toad.exe |00000000001C59C1|System.Classes.pas |System.Classes |TComponent |RemoveNotification | |
|00000040|03 |00000000007FE628|0000000004355A42|Toad.exe |00000000001C5A42|System.Classes.pas |System.Classes |TComponent |RemoveFreeNotification | |
|00000040|04 |00000000007FE668|000000000A874372|Toad.exe |00000000066E4372|frmSyntaxEditor.pas |frmSyntaxEditor |TSyntaxEditorForm |SetSelectedMessage |8689[2] |
|00000040|04 |00000000007FE6B8|0000000009BB6D72|Toad.exe |0000000005A26D72|frmMOEScriptOutput.pas|frmMOEScriptOutput|TMOEScriptOutputForm|ShowSelectedMessage |1802[7] |
|00000040|04 |00000000007FE708|0000000009BB2A28|Toad.exe |0000000005A22A28|frmMOEScriptOutput.pas|frmMOEScriptOutput|TMOEScriptOutputForm|lbErrorsClick |547[1] |
|00000040|03 |00000000007FE738|00000000045213A1|Toad.exe |00000000003913A1|Vcl.Controls.pas |Vcl.Controls |TControl |Click | |
|00000040|03 |00000000007FE778|000000000455ED65|Toad.exe |00000000003CED65|Vcl.StdCtrls.pas |Vcl.StdCtrls |TCustomListBox |CNCommand | |
|00000040|03 |00000000007FE7B8|00000000041A12B2|Toad.exe |00000000000112B2|System.pas |System |TObject |Dispatch | |
|00000040|03 |00000000007FE818|0000000004520C8D|Toad.exe |0000000000390C8D|Vcl.Controls.pas |Vcl.Controls |TControl |WndProc | |
|00000040|03 |00000000007FE988|0000000004527A9B|Toad.exe |0000000000397A9B|Vcl.Controls.pas |Vcl.Controls |TWinControl |WndProc | |
|00000040|03 |00000000007FEA58|000000000455EA83|Toad.exe |00000000003CEA83|Vcl.StdCtrls.pas |Vcl.StdCtrls |TCustomListBox |WndProc | |
|00000040|03 |00000000007FEAC8|0000000004520780|Toad.exe |0000000000390780|Vcl.Controls.pas |Vcl.Controls |TControl |Perform | |
|00000040|03 |00000000007FEB28|0000000004527C89|Toad.exe |0000000000397C89|Vcl.Controls.pas |Vcl.Controls | |DoControlMsg | |
|00000040|03 |00000000007FEB68|0000000004528E43|Toad.exe |0000000000398E43|Vcl.Controls.pas |Vcl.Controls |TWinControl |WMCommand | |
|00000040|03 |00000000007FEBA8|00000000041A12B2|Toad.exe |00000000000112B2|System.pas |System |TObject |Dispatch | |
|00000040|03 |00000000007FEC08|0000000004520C8D|Toad.exe |0000000000390C8D|Vcl.Controls.pas |Vcl.Controls |TControl |WndProc | |
|00000040|03 |00000000007FED78|0000000004527A9B|Toad.exe |0000000000397A9B|Vcl.Controls.pas |Vcl.Controls |TWinControl |WndProc | |
|00000040|03 |00000000007FEE48|0000000004526CDA|Toad.exe |0000000000396CDA|Vcl.Controls.pas |Vcl.Controls |TWinControl |MainWndProc | |
|00000040|03 |00000000007FEE98|0000000004358EB4|Toad.exe |00000000001C8EB4|System.Classes.pas |System.Classes | |StdWndProc | |
|00000040|03 |00000000007FEEE8|00007FF8D618E852|user32.dll |000000000000E852|user32.dll |user32 | | (possible CallWindowProcW+1010) | |
|00000040|03 |00000000007FF078|00007FF8D618E3D7|user32.dll |000000000000E3D7|user32.dll |user32 | | (possible DispatchMessageW+919) | |
|00000040|03 |00000000007FF0D8|00007FF8D61A0BBD|user32.dll |0000000000020BBD|user32.dll |user32 | | (possible SendMessageTimeoutW+317)| |
|00000040|03 |00000000007FF138|00007FF8D6430B9F|ntdll.dll |00000000000A0B9F|ntdll.dll |ntdll | |KiUserCallbackDispatcher | |
|00000040|03 |00000000007FF1C0|00007FF8D3AE1124|win32u.dll |0000000000001124|win32u.dll |win32u | |NtUserMessageCall | |
|00000040|03 |00000000007FF1C8|00007FF8D618DF2D|user32.dll |000000000000DF2D|user32.dll |user32 | | (possible SendMessageW+2429) | |
|00000040|03 |00000000007FF268|00007FF8D618D685|user32.dll |000000000000D685|user32.dll |user32 | |SendMessageW | |
|00000040|03 |00000000007FF2B8|00007FF8B2C02694|comctl32.dll|0000000000132694|COMCTL32.dll |COMCTL32 | |TaskDialog | |
|00000040|03 |00000000007FF2E8|00007FF8B2C00FB8|comctl32.dll|0000000000130FB8|COMCTL32.dll |COMCTL32 | |TaskDialog | |
|00000040|03 |00000000007FF328|00007FF8B2C0324C|comctl32.dll|000000000013324C|COMCTL32.dll |COMCTL32 | |TaskDialog | |
|00000040|03 |00000000007FF3D8|00007FF8B2B76BFB|comctl32.dll|00000000000A6BFB|COMCTL32.dll |COMCTL32 | |ImageList_Read | |
|00000040|03 |00000000007FF518|00007FF8D618E852|user32.dll |000000000000E852|user32.dll |user32 | | (possible CallWindowProcW+1010) | |
|00000040|03 |00000000007FF6A8|00007FF8D618E4E9|user32.dll |000000000000E4E9|user32.dll |user32 | |CallWindowProcW | |
|00000040|03 |00000000007FF6F8|0000000004527C22|Toad.exe |0000000000397C22|Vcl.Controls.pas |Vcl.Controls |TWinControl |DefaultHandler | |
|00000040|03 |00000000007FF738|0000000004521A4C|Toad.exe |0000000000391A4C|Vcl.Controls.pas |Vcl.Controls |TControl |WMLButtonUp | |
|00000040|03 |00000000007FF7B8|00000000041A12B2|Toad.exe |00000000000112B2|System.pas |System |TObject |Dispatch | |
|00000040|03 |00000000007FF818|0000000004520C8D|Toad.exe |0000000000390C8D|Vcl.Controls.pas |Vcl.Controls |TControl |WndProc | |
|00000040|03 |00000000007FF988|0000000004527A9B|Toad.exe |0000000000397A9B|Vcl.Controls.pas |Vcl.Controls |TWinControl |WndProc | |
|00000040|03 |00000000007FFA58|000000000455EA83|Toad.exe |00000000003CEA83|Vcl.StdCtrls.pas |Vcl.StdCtrls |TCustomListBox |WndProc | |
|00000040|03 |00000000007FFAC8|0000000004526CDA|Toad.exe |0000000000396CDA|Vcl.Controls.pas |Vcl.Controls |TWinControl |MainWndProc | |
|00000040|03 |00000000007FFB18|0000000004358EB4|Toad.exe |00000000001C8EB4|System.Classes.pas |System.Classes | |StdWndProc | |
|00000040|03 |00000000007FFB68|00007FF8D618E852|user32.dll |000000000000E852|user32.dll |user32 | | (possible CallWindowProcW+1010) | |
|00000040|03 |00000000007FFCF8|00007FF8D618E294|user32.dll |000000000000E294|user32.dll |user32 | | (possible DispatchMessageW+596) | |
|00000040|03 |00000000007FFD78|00000000046E180E|Toad.exe |000000000055180E|Vcl.Forms.pas |Vcl.Forms |TApplication |ProcessMessage | |
|00000040|03 |00000000007FFDF8|00000000046E1883|Toad.exe |0000000000551883|Vcl.Forms.pas |Vcl.Forms |TApplication |HandleMessage | |
|00000040|03 |00000000007FFE68|00000000046E1CD1|Toad.exe |0000000000551CD1|Vcl.Forms.pas |Vcl.Forms |TApplication |Run | |
|00000040|04 |00000000007FFEA8|000000000AE713CE|Toad.exe |0000000006CE13CE|Toad.dpr |Toad | |initialization |2028[154] |
|7FFF7FFE|03 |00000000007FFF28|00007FF8D45C702E|kernel32.dll|000000000001702E|KERNEL32.DLL |KERNEL32 | |BaseThreadInitThunk | |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Thank you. We've logged a roadmap ticket.
