Exporting a data set to Excel, from a SELECT statement with BREAK ON exports an empty spreadsheet
User loads SELECT statement with a with BREAK ON into editor.
Steps to recreate:
1) Run script with F5 key
2) Clicks on the Grid 1 tab
3) Click on corner icon, Desktop Panels, Save Grid Contents
4) Selects Excel File from drop down
5) Enable Options: Launch after creation, Hide time portion on date if zero, Auto column and include column headers
6) Clicks on (...) Specify Output file name button
7) Enter the File name in text box
8) Click on the OK button
The Excel spreadsheet window opens. No data is exported.
This problem is due to a corrupted ToadActions.dat file.
1) Close Toad for Oracle.
2) For Windows XP - Go to 'C:\Documents and Settings\<OS_USER>>\Application Data\Quest Software\Toad for Oracle\<Toad Version>\User Files' directory.
or
For Windows Vista and 7 - Go to 'C:\Users\<OS USER>\AppData\Roaming\Quest Software\Toad for Oracle\<Toad Version>\User Files' directory.
(a) Rename the ToadActions.dat file to ToadActions.dat.backup.
(b) Rename the ToadActions.log to ToadActions.log.backup
3) Launch Toad and test issue.
An EXAMPLE of a SELECT statement with a BREAK ON:
set pages 50000
set null 'No Comments'
tti 'Table Comments'
col comments format a29 wrap word
select * from user_tab_comments;
tti 'Column Comments'
col comments format a18 wrap word
break on table_name skip 1
select * from user_col_comments;
clear break
set null ''
set pages 23
