Toad for Oracle 16.1 - Release Notes

Editor: Unable to run unit tests created with Code Tester for Oracle

Schema Browser: Unable to view results of unit tests created with Code Tester for Oracle

Ping: Unable to use Ping tool when Toad's Internet access has been disable

Export DDL: Trigger scripts omit DISABLE in some cases

Alter Job: ORA-01858 encountered when changing the next execution time when locale settings are set to Korean

Desktop: Dock panels set to auto-hide are not restored when restarting Toad

Dark Mode: Windows lack borders and shadows when connection colors are used

Window Bar: Button order is incorrect when the Connection Bar option "Save positions" is enabled

Schema Browser: The right side display when viewing a trigger is too small

Dark Mode: Cursor output colors are not good

Administer Tablespaces: Access Violation occurs when refreshing the Objects tab quickly

Log Miner: The final step in the wizard is missing its toolbar

Editor: Auto Replace may apply within strings and comments incorrectly when typing quickly

Schema Browser: Out of Memory exception occurs when filtering synonyms to include both Private and Public

Editor: "Field not found" error occurs during execution with a cursor output variable in some cases

Editor: Describe (F4) fails in the Navigator panel when the text is set to lowercase

Session Browser: Changing Current Statement subtabs cause a refresh when the "Refresh" option is unchecked

Editor: Access Violation occurs when dragging files from Windows Explorer in some cases

Describe: Size and position are not remembered

Editor: Applying Auto Debugger generates code that will not compile in some cases

Editor: Data Grid commits when it should not if the cached edits option is enabled (View | Options | Data Grids | Data)

Alter Scheduler Job: Changes made to notifications are not committed

Schema Browser: Caption changes made to scheduler object tabs are not remembered

Schema Browser: Splitter between the left and right sides does not work when dark mode is in use

Rebuild Table: Script excludes the backup table name when the source table name is longer than 30 characters

Schema Browser: ORA-29275 is raised when selecting a scheduler job if data in the GLOBAL_UID column of DBA_SCHEDULER_JOBS is corrupt

Explain Plan: Plan table is created in the login schema when selecting a schema other than TOAD or the login schema

Editor: The code section becomes inaccessible if the bottom splitter is positioned near the top and the Editor is resized smaller

Alter Table: Cannot add a primary key constraint

Editor: Save dialog uses .SQL extension instead of .sql

Compare Table Data: Error occurs when comparing external tables

Session Browser: Splitter position is lost after minimizing Toad when the form layout is oriented with the detail tabs at the bottom

Compare Multiple Tables: Unable to compare LOBs in different databases by LOB length

Schema Browser: Quick filter does not allow selecting the only item in the dropdown

Editor: Active tab text is lost when using the windows "pop out" feature

Schema Browser: Table columns tab does not allow adding a virtual column

Data Grids: Popup Editor is slow to appear when using Dark Mode

Schema Browser: Adding a constraint to the selected table causes the table to become deselected on the left side

Data Grids: Save dialog in popup editor opens in the background

Data Grids: Posting edits to CLOB data visualizes the data as corrupt despite it being sent to the database properly

Editor: Automatic backups of tab text do not stay up to date as the text is modified

Explain Plan: Error image is used incorrectly for some plan steps

Schema Browser: Expanding indexes in multiple schemas leads to Access Violation when the browser style is set to treeview

Editor: "Operation aborted" error message is shown in cases where an ORA-06503 is the error returned by the database

Login: The Database dropdown of the TNS tab is slow to load if the tnsnames.ora file contains thousands of entries

Schema Browser: ORA-00904 is raised when editing data using the Foreign Key lookup feature if the column name requires double quotes

Export Dataset: Exporting a new sheet to an existing Excel File which contains a pivot table causes file corruption

Editor: Toad is truncating data when opening a file with an embedded 'NUL' character.

Editor: Query Builder removes the 'connect by' in a sql statement when trying to reverse engineer a hierarchy statement.

Toad Options: The Toad Improvement Program cannot be disabled if the internet connection is restricted.

Connections: Oracle client version 12.1.0.1 corrupts data received via output bind variables because Toad for Oracle does not support Oracle client 12.1.0.1.

Editor: The nested table dialog does not display the first character of VARCHAR2 nested tables.

Editor: Executing a query that includes a table with an XMLTYPE column results in ORA-00904.

Automation Designer: Using a system variable name in a query iterator does not work when scheduled.

Export DDL: Toad creating incorrect scripts from PL/SQL objects which exist in different versions in container and pluggable databases.

Connections: In the toolbar, Reconnect and Reconnect All use the same icon and have no tooltip.

Rebuild Table: Script includes "ALTER TABLESPACE {Tablespace Name} COALESCE;" command even if user does not have the alter tablespace privilege.

Connections: The Transactions window auto-refresh fails if a connection is lost and then recovered.

Editor: When an error occurs executing a script Toad highlights the first line of the statement instead of the line where the error actually occurs.

Explain Plan: ORA-00905 is raised when PUBLIC is specified as the plan table schema in Toad options

DBMS Output: Looks enabled after ORA-04068 is raised when it is actually disabled.

Schema Browser: ORA-00904 is raised when trying to browse the "Data" tab for SYS, TABLES, SYSTEM_PRIVILEGE_MAP.

Editor: HTML is incorrectly displayed in the error message when ORA-2000 is raised.

Editor: Variables are incorrectly flagged as unused when utilizing Refactor - Find Unused Variables.

Editor: When using an ANSI JOIN clause Code Assist is not listing the packages that are available.

Editor: Navigating between procedures in the package spec using the keyboard shortcut: Ctrl+Shift+Up/Down fails in some cases.

Editor: Ctrl+Click does not always find variable declarations.

Schema Browser: Tables with identity columns are not found in "Sequences -Used By" tab.

Data Grids: The keyboard short cut Ctrl+X does not cut.

Workspaces: When a window is minimized and the Workspace is then saved and re-loaded the window is no longer minimized.

Unit Test: The right click menu for entries in the tree view of UTPLSQL Manager is prevented from displaying by a tooltip.

Schema Browser: Hidden columns still display after they are unchecked via the "Scheduler Jobs - Run Log" tab.

Compare Data: In specific cases when comparing data, Toad incorrectly identifies rows as "source only" and "target only".

Unit Test: If a database's decimal separator does not match Toad's, then UTPLSQL's execution time incorrectly displays as zero after the test is complete.

Connections: TNSNames entries with leading spaces do not appear in the login window

Editor: The [F3] Shortcut for find is not highlighting the correct text if Greek letters are present.

General: When copying and pasting the clipboard fails in some cases.

Schema Browser: When logged into a database using Team Coding the refresh option is not visible in Materialized View.

Connections: The login window does not always remember the last connection.

Schema Browser: Execute Procedure returns "Invalid field size" error when "Scientific Notation" is unchecked.

SGA Trace/Optimization: SGA/Trace is missing some fields in newer Oracle versions.

Trace File Browser: The new trace file browser transfer mode (compress, transfer, decompress) sometimes fails.

Compare Schemas: Views are showing differences in column size when they should be identical.

Export Dataset: "Excel Instance" is not exporting strings as strings, which affects the exported data in some cases.

Rebuild Multiple Objects: ORA-00900 is raised when rebuilding LOB Segments via "Load LOB Segments of Checked Tables".

Administer Tablespaces: Files tab incorrectly shows 0 free space for some datafiles.

Editor: Auto-replace only replaces whole words.

Editor: Large NUMBER bind variables are incorrectly converted to scientific notion.

Datagrids: BLOB editor dialog has no "Clear" button.

Session Browser: Nothing happens when filtering parallel slaves.

Copy data to another schema: Number precision is lost if Scientific Notation is checked.

Session Browser: ORA-00029 is raised when clicking "​Cancel SQL for selected session" for parallel processes.

Editor: Ctrl+PgUp/Down does not navigate correctly to package bodies.

QSR: Q-quotes do not work in QSR.

Import Table Data: Using expressions when importing table data fails in some cases.

Editor: The "replace" functionality in the "Find/Replace" dialog is case sensitive even if the case sensitive box is not checked.

Automation Designer: Multiple connections cannot be selected after using the "Change Connections" option.

Automation Designer: The Query Iterator forces its connection on child actions.

Editor: Ctrl+D always launches Quick Describe from Editor even when Ctrl+D is configured for other shortcuts.

Schema Browser: Using a Foreign Key look up on large tables sometimes causes out of memory errors.

Connections: Sometimes when an Oracle DB is connected the Connection Bar Icon shows it as disconnected.

Schema Browser: Alter Table displays incorrect values for PCTFREE and PCTUSED in some cases.

Editor: Toad Script Runner (TSR) throws an error when substitution variables are used.

SQL Recall: The [F8] keyboard shortcut briefly displays the Right Hand Side Dock panels when opening the SQL Recall dialog.

Schema Browser: ORA-00904 is raised when accessing the Schema Browser Favorites "Data" tab after altering a view.

Export DDL: Toad produces an incorrect script when creating a table on 11gR2 in some cases.