Toad for Oracle 17.1 - Release Notes

Connections: Timezone data is incorrect when querying some databases using "no client" mode.

Color Schemes: Some buttons on the login window lack a border when using color schemes on Windows Server 2016.

Toolbars: The window menu, shown to the left of the File menu for maximized windows, duplicates its menu items each time it is clicked.

Connections: The connection bar "Containers" menu is out of sync after an ALTER SESSION SET CONTAINER statement is executed in the Editor.

Script Execution: The elapsed time shown in the progress dialog is incorrect in some cases.

Execution: Access Violation occurs when using "no client" mode and selecting RAW datatype over a database link.

Connection Bar: The "Reconnect all" menu item is disabled at times it should be enabled.

Editor: Compiling a package having an error indicates the wrong line as having the error.

Export Dataset: The default extension for Excel should be .xlsx and for Access it should be .accdb.

Mac: Editor takes a long time to load if CAPS lock is enabled.

Editor: Goto Line (Ctrl+G) throws an exception in some cases.

Data Grids: ORA-00903 error is raised when updating data of a LONG RAW field.

Schema Browser: Tab key does not advance through all fields properly in the Filter/Sort dialog.

Debugger: Access Violation occurs in some cases if the background session is disconnected.

Connection Bar: Opening a window from the "Frequently used" menu of an inactive session's connection bar button opens the window for the active session, instead.

Export Dataset: Exporting to Excel does not include data for CLOB fields exceeding 32767 characters.

Workspaces: Access Violation occurs when loading a workspace in some cases.

Automation Designer: The Compare Schemas action uses CREATE instead of CREATE OR REPLACE in the sync script when executed using a parameter file that was created with Toad for Oracle 16.3 or older.

Code Analysis: Running Code Analysis with the SQL Scan option enabled causes Toad to disappear in some environments.

Schema Browser: The Alter Table dialog includes the schema in ALTER TABLE RENAME COLUMN statements when the "Show SQL without schema" menu item is chosen.

Toolbars/Menus: Setting a custom shortcut for Print Preview does not work.

Workspaces: Creating a new Editor tab after opening a workspace does not always activate the new tab.

Editor: The Load DB Object window has an empty, gray panel when the "Show source" checkbox is unchecked.

Connections: The Reconnect button is unavailable on the dialog shown for ORA-00045 errors.

Automation Designer: The Format Files action modifies reserved word character case and does not format the code

Automation Designer: Variable substitutions are not made to the Export Dataset action's SQL text if the SQL has been modified after mapping substitution variables to Automation Designer variables.

Session Browser: Quickly clicking on nodes in the left side navigator causes the Session Browser to process each click and slow down for a bit as it catches up.

General: Long error message text is truncated in error dialogs if using a dark color scheme.

Schema Browser: The Tables Script tab truncates constraint text longer than 4000 characters.

Master-Detail Browser: An error occurs when setting a filter having a comment on the first line.

Schema Browser: Filters set on the Invalid Objects tab do not affect indexes.

Connections: Connecting to an Oracle Cloud database without a client raises an ORA-12506 in some cases.

Statspack Browser: Copying a SQL Summary row to clipboard causes Toad to freeze for a while..

Data Import Wizard: Custom date format does not accept dot or dash as date separator.

Script Execution: DESC PACKAGE excludes functions and procedures without parameters.

Data Grids: Saving a blob to file omits the extension if it is not specified in the filename.

Data Grids: CTRL+F to find data selects wrong columns.

Project Manager: Files loaded in external application always use the default association from Windows instead of the association defined in the Project Manager settings.

Login Window: Connection made to the wrong database after editing a previously used connection's alias in the grid and selecting a different database from the right side dropdown and clicking Connect.

Data Grids: Record Count does not respect filtered records.

Automation Designer: Changing the output file extension of an Export Dataset action using Excel file format from .xlsx to .xls will change the extensions of other Export Dataset actions also exporting to Excel file format.

Script Manager: Access Violation occurs when running scripts in 64-bit Toad.

Toad for Oracle on Mac: Animation on the Script Execution dialog looks bad.

Toad for Oracle on Mac: "Task Manager not running" error on startup.

Toad for Oracle on Mac: Compiling a Team Coding controlled object in the Editor using shortcut (F9) results in endless loop.

Toad for Oracle on Mac: Cannot drag/drop files from Finder to Editor.

Alter Database Link: Incorrect username for connection is shown.

Editor Options: The Tab stop setting is not being saved when Toad closes.

Editor: The Navigator tree scrolls each time it refreshes.

Toad for Oracle on Mac: Find Next (F3) does not work properly if the find dialog is not showing.

Toad for Oracle on Mac: Grid lines are invisible in some windows.

Schema Browser: "Invalid table name" error is raised when generating scripts for Tables, Views, and Materialized Views for users lacking the SELECT ANY DICTIONARY privilege.

Import Table Data: Importing from a Fixed Field Width file raises an incorrect error regarding field size and nothing is imported.

Automation Designer: Upgrading from Toad for Oracle 16.3 to 17.0 raises an error at startup for ToadActions.dat if the 16.3 datafile contains a Data Pump Import action.

Debugger: "Invalid Oracle Home" error is raised when debugging if the session is made without a client and no clients are installed.

Toad for Oracle on Mac: Cannot save BLOB data from the data grid BLOB editor.

Toad for Oracle on Mac: Poor font quality.

Login Window: LDAP dropdown list is slow to load when in clientless mode.

Toad for Oracle on Mac: CAPS lock can get out of sync.

Toad for Oracle on Mac: The TNS_ADMIN location is not as apparent as it could be.

Editor: "Refactor > Remove Subqueries" generates invalid SQL when aggregate functions are present

Data Grids: Strings exceeding the width of the control do not show a trailing ellipsis

Triggers: Incorrect DDL is generated for disabled triggers containing a header comment and a WHEN clause

Login: When grouped by multiple columns, deleting records from an expanded group collapses all other expanded groups

Session Browser: Locks tab does not select the top row following a refresh

Schema Browser: Favorites folder cannot be renamed

Schema Browser: Scheduler Job script is invalid when the job has unnamed arguments

Alter Tablespace: Maximum size is changed to UNLIMITED in some cases

Generate Schema/Database Script: IN MEMORY and COMPRESSION options are ignored

Session Browser: Selected row in the Open Cursors tab changes after activating a different tab and returning to Open Cursors

Insert Table Data: Some rows are not imported following a constraint violation when the "Use Array DML" option is checked

Workspaces: Unicode characters in the Editor are lost

Schema Browser: Scheduler Job run log throws an error on Oracle database 10g Release 1

Export Dataset: Auto detection of schema doesn't work with a SELECT from a table across a database link containing a '.' in its name

Schema Browser: Sending a trigger to the Editor ignores the Editor option to exclude schema name when loading objects

Code Insight: Results not shown when invoked within SQL containing a subquery.

Subscription Licensing: An Access Violation occurs after upgrading Toad in some cases

Schema Browser: Incorrect script is generated for tablespaces that are encrypted, but not compressed

Schema Browser: Rebuild Table window does not allow new columns having a name longer than 30 characters on Oracle database 12g Release 2 and newer

Automation Designer: Execute Script action fails if the output file or path contains variables

Team Coding: The Team Coding Browser VCS tab hangs when using Azure DevOps Services (TFVC)

Data Grids: Sorting a column no longer focuses the sort direction radio group by default

Change Password: ORA-00922 is raised when changing password if a password verify function has been configured

Data Grids: The columns dropdown on the Filter tab of the Filter/Sort Data dialog is not wide enough to show long column names

Editor: The prompt to reload files modified externally is shown even after choosing "Yes to All" at the initial prompt and then deactivating and activating Toad

Team Coding: The compare dialog does not show Unicode characters

Trace File Browser: The modified date of some files is not displayed

Trace File Browser: Poor contrast when using a dark color scheme

Editor: Refactor | Resolve Package Constants does not work for SQL containing a single package constant reference

Code Insight: Very slow filtering of results while typing in some cases

Code Analysis: SQL Scan does not work when using proxy user authentication

Data Grids: Popup Editor throws a "Cannot modify a read-only dataset" error when formatting text

Data Grids: Using the DEL key to clear a cell throws an "Invalid value for field" error when the column has a foreign key

TNSNames Editor: Some parameters within the SECURITY section are unsupported

Color Schemes: Schemes are not fully applied to SQL Recall after changing the color scheme and restarting Toad

Compare Schemas: Schema name is excluded in the sync script if the "Include Schema in Migration DDL" and "Format before comparison" options are both checked

Script Execution: The SQL feedback text is formatted poorly or incorrect with some statements

Code Insight: PL/SQL objects are not shown in the list in some cases.

Explain Plan: Toad sometimes connects to the wrong RAC instance when the "Separate session" for Explain Plan option is set

Automation Designer: Export Dataset action changes the file extension of the results file in some cases

Color Schemes: The selected node in some tree views is difficult to see with some color schemes

Schema Browser: The left side navigator does not update its selected node to reflect the caret position after searching for text in the Script tab of a package

Team Coding: Access Violation occurs after dropping materialized views

Schema Browser: The generated script for Materialized View is incorrect when the "Add to refresh group" option is checked in the script generation options

Editor: The automatic backup feature does not clean up stale files and references which can lead to Access Violations and general performance issues in time

Test Connections: An Access Violation can occur when closing the dialog immediately after testing connections

Automation Designer: FTP action does not observe variables in filenames to download

Schema Browser: The right side/detail view when selecting a table is scaled incorrectly in same cases when using high-definition resolutions

Import Table Data: Access Violation occurs when importing from CSV files having fields with more than 32k bytes of data