Toad for Oracle 14.2 - Release Notes

Schema Browser: Usage data shown for the selected Tablespace on the left side is cleared after refresh

Debugger: Access Violation occurs during mouse-over inspection of ":new" and ":old" variables in triggers

Create Unit Test: "not contain" matcher is missing from the list of available matchers

Create Unit Test: Incorrect suite DDL generated when accepting the default values for the "All Tests Setup/Teardown" and "Test Setup/Teardown" options

Code Snippets: Several utPLSQL matchers do not have code snippets

Code Snippets: Several annotations do not have code snippets

Editor: Bookmark gutter indicators disappear when deleting text in some cases

Editor: Access Violations occur when answering Yes to reload files that have been modified externally in some cases

Editor: Executing a valid SELECT against a table with XMLTYPE columns incorrectly results in ORA-00904 or ORA-00936

Data Grids: When CLOB data is cleared the data is updated to be zero length instead of NULL

Editor: The progress dialog counts steps incorrectly when executing as script

Automation Designer: Unable to use scripts with ampersand in their path

Schema Browser: Max size incorrectly shown as 32T instead of unlimited for a bigfile tablespace with max size set to unlimited and ORA-00740 is raised when altering such tablespaces in some cases

Team Coding: Double clicking on a package or type in the Team Coding Manager incorrectly prompts to reload the object when the "Check out object on opening" option is set

Automation Designer: Access Violation occurs when deleting apps

Export Dataset: Exporting data containing CLOB as Insert Statements can generate lines exceeding the maximum length allowed by SQL*Plus

Toolbars/Menus Shortcuts: Several features of the Editor do not respect their shortcut assignment when configured to be anything other than the default value

Editor: Executing a SELECT that utilizes a common table expression results in ORA-00942 when one or more of the tables has an XMLTYPE column

Editor: Running a SELECT that produces multiline character having LF line endings truncates each line of data when the "Newline format for character data" option is set to "Fetch as Windows format, post as Unix format"

Copy Data: Excessive error prompting when the option to enable/disable constraints is set and there are errors disabling constraints

Schema Browser: The left side tree for PL/SQL objects is missing a column header and thus cannot be easily sorted

Editor: Data Grid column width is very narrow after running a SELECT statement if the Data Grid is set to unpinned

Compare Multiple Tables: ORA-00972 is raised when generating a differences summary report in some cases

Session Browser: The splitter is oriented incorrectly after flipping the form layout

Team Coding: The "Check-in All" toolbutton and menu item are disabled even when objects are checked out

Editor: The Windows taskbar does not flash to notify of query completion when Toad does not have focus

Schema Browser: Altering the size of a tablespace datafile produces an extra, harmless ALTER statement

Create Table: Invalid floating point exception when clicking Show SQL if the Next Extent storage option has no value

Workspaces: Loading saved Workspace does not restore the Editor desktop layout properly

Connections: Making a connection using the recently used connections toolbutton does not allow updating the password when it has been changed from what was last used in Toad

Editor: Executing a SELECT that fetches ROWID produces a read-only dataset when the '@' character appears anywhere in the SQL text

Compare Multiple Tables: Excessive server memory usage when comparing tables with columns of a LOB type

Export Dataset: Unnecessary prompt to choose a table in some cases

Editor: Korean fonts are not applied

Toolbars: Custom toolbars are lost after upgrading

Editor: The Navigator is slow to load when the Code Analysis "Check rules as you type" option is set

Script Execution: Alphanumeric variable values unnecessarily require double quoting to work properly

Editor: When the word wrap option is enabled and text wraps Toad becomes unresponsive in some cases

Code Snippets: The Code Snippets datafile may become corrupt causing loss of all saved snippets

Make/Strip Code: The Make/Strip Code datafile may become corrupt causing loss of all saved templates

Toolbars/Menus Shortcuts: Several features of the Editor do not respect their shortcut assignment when configured to be anything other than the default value

Explain Plan: Invalid floating point exception is raised when viewing Single Record View of an item tree view style and locale settings are configured for thousands separator of '.' and decimal separator of ','

Administer Tablespaces: Datafile free space is incorrectly reported to be 0 in some cases

Code Analysis: Access Violation occurs when sending objects to be scanned from elsewhere in Toad, i.e. Schema Browser, when column filters are set such that the object is hidden

Schema Browser: The focused object type node loses focus after refresh when the Browser Style is set to Treeview

Code Insight: ORA-02391 is raised when the connected schema has a profile assigned that limits the number of sessions to 1

Schema Browser: Custom tab order is not always applied when using the "Tabbed (multi line tabs)" view style

Data: Large CLOB values on non-Unicode databases experience corruption when fetched

Automation: Running Toad and passing in an action and a parameter file value results in an "Unable to create directory" error when the parameter file can not be located

Schema Browser: Incorrect scripts are generated for partitioned tables with referential integrity constraints

Create Synonym: Long object names are unsupported

Data Grids: ORA-01400 is raised when trying to set a value for a CLOB column having NOT NULL constraint in a newly inserted row

Team Coding: VCS logon does not occur when attempting to compile a controlled object

Describe Objects: Access Violation occurs when loading a saved list of objects where one or more objects in the list has been dropped

Schema Browser: Access Violation occurs when closing the window while it is refreshing

Import Table Data: Import does not complete after reconnect in some cases

Connections: Error upon making a new connection if the connections datafile is locked by another process

Alter Materialized View: Access Violation occurs when changing the partitioning strategy

Reports Manager: Changes made to the Master Dataset are lost when activating the Comments tab

Toolbars: Menu animation reverts to Fade upon Toad startup when the Windows "Fade or slide menus into view" option is set

Import Table Data: When the Output option is "Create file with SQL statements" the files are always UTF-8 encoded without the ability to set it to a different encoding

Team Coding: "Cannot focus a disabled or invisible window" error occurs when editing the TFS server name in some cases

Schema Browser: Access Violation occurs when quickly navigating PL/SQL object dependencies on the right side "Deps (uses)" tab

Data Grids: Unhandled error when exporting to Excel when the Excel file is already open and locked by another application

Explain Plan: Some valid statement type cannot be explained, e.g. CREATE TABLE, CREATE INDEX, etc.

Make/Strip Code: Access Violation occurs when deleting all Make/Strip Code templates

Schema Browser: Changes made to object type visibility in the Configure Browser Tabs dialog are not saved in some cases

Compare Data: Access Violation occurs when comparing tables across different sessions if one of the sessions is terminated

Editor: Ctrl+Click on a reference to a package that has no body will open the package in the Describe window instead of opening the spec within the Editor if the "Jump to package and type body" option is set

Schema Browser: Rebuild Table excludes triggers from the generated script

Space Manager: The Setup process incorrectly checks for required privileges

Trace File Browser: Access Violation occurs when loading a trace file containing Remote Procedure Calls in some cases

Formatter: The option to ensure a trailing newline is non-functional

Team Coding: The values of Status By and Status Type are switched for Team Projects in some cases

Connections: Access Violation occurs if a reconnect fails in some cases

Data Grids: Pasting string data into a cell does not work in some cases

Execute Procedure dialog: "Cannot focus disabled or invisible window" error after hitting ESC key in the arguments grid

Code Insight: Toad hangs in some cases

Formatter: "List Arrangements" option of Wrapped is non-functional

Automation Designer: Can't add action to app if the app node has lost focus in the left side treeview

Toolbars: Connection bar does not update to identify the active session in some cases

Object Search: Table partitions and subpartitions are not found

Code Analysis: Slow to analyze some code when rule 2128 is included

Code Insight: List is blank when typing the first character of a valid column name

Application: Ctrl+Tab and Ctrl+Shift+Tab does not activate some windows when Toad is in SDI window mode

Workspaces: Connection and window order is not retained when saving workspaces

Editor: Execute as Script throws an Access Violation when the connection has closed due to timeout

SQLNET Editor: ESC key does not close the window

Workspaces: Cannot close Toad after loading a saved workspace that opens a Describe Objects window

Data Grids: Various dataset navigation issues with the nested table popup editor

Team Coding: Team Coding Manager dock panel is blank if in an unpinned/hidden state when connecting to database

Editor: Execute as Script grids do not use sequential numbering in the tab captions when SELECT statements producing no rows are in the script

Editor: Connection shown in the title bar and status bar can get out of sync in some cases when changing the session associated with the window

Editor: Executing SELECT against a table with a user-defined type column crashes if the type contains an integer value greater than 2147483647

Editor: Execute as Script does not cancel promptly when the script executes long running PL/SQL

Data Grids: Access Violation occurs when editing a field via the popup editor if the connection has terminated

Data Grids: Access Violation occurs when posting edits directly in the grid if the connection has terminated

Editor: Executing SELECT against a table with a user-defined type column throws an error if the type contains a SMALLINT datatype

Data Grids: Access Violation occurs when the next block of results is fetched if the connection has terminated

Schema Browser: Access Violation or Invalid Pointer Operation occurs when viewing the data in a Queue Table

Team Coding: Materialized Views don't get versioned in the VCS when recreated

Editor: Editing large text is slow if Sensitive Data Awareness is enabled

Compare Schemas: Access Violation occurs when closing the compare text dialog while it is still loading

Toolbars: Connection bar images do not update to indicate lost connection

Rebuild Table: VALIDATE/NOVALIDATE constraint states are excluded when the table has a Foreign Key constraint

Login: Custom fields are removed from the recently used connections grid when the connections are grouped by custom field(s) and the view style is changed

Quest Script Runner: Favorite Folders aren't being retained after restart

Code Analysis: Results exported to comma delimited text do not use the same precision for Halstead Volume and Maintainability Index as shown within Toad

Team Coding: Error converting VCS timestamps on machines with custom time formats when viewing the debug log

Database Browser: Access Violation occurs when selecting the node for a database having no connection

Explain Plan: Viewer (tree style) does not support Adaptive Plans

Compare Schemas: Byte/Char differences are not identified/synced when the "Include Byte/Char when creating DDL scripts" option is unchecked on the Datatypes page in View|Options

Roles/Editions: On Fail behavior (View | Options | Oracle | Roles and Editions) does not work when the schema lacks privileges on the Role or Edition

HTML Database Doc Generator: Objects privileges granted to Roles are not shown

Schema Browser: Comparing CDB Resource Plans does not check "CDB Resource Plans" in the Compare Databases window

Application: Various modal windows are pushed to the background when they should remain as the top-most window

Import Table Data: Error occurs when importing from MS Access file having erroneous data

Data Grids: Popup editor closes immediately upon opening when invoked from the last row in the dataset

Data Grids: Duplicate Row does not work if the table has an IDENTITY column

Editor: Team Coding prompt to check-in occurs twice when closing the tab in some cases

Editor: Overwriting selected text causes Toad to hang

Compare Objects: Object privileges granted to Roles are excluded

Alter Table: Locations and Default Directory are not editable when altering an External Table

Schema Browser: Can't rename Datafile in non-Enterprise editions of Oracle

Connections: Oracle 10g RAC connections are not detected

Tablespaces: Access Violation occurs when clicking in the Tablespaces window quickly as it is opening

Automation Designer: Access Violation occurs when running actions against multiple connections if the option to highlight table names is checked (View | Options | Editor | Display)

Copy Table Data: Access Violation occurs in some cases

Editor: Saving a file that was split (View | Options | Editor | Open/Save) saves the file using ANSI encoding

ADDM Report: "'' is not a valid floating point value" error occurs

Alter Tablespace: Floating point values are not accepted when altering the size of a datafile

Login: Access Violation occurs when testing a saved connection if no Oracle clients are configured

Data Grids: Error occurs when pasting into a read-only grid in some cases

Data Grids: Export Dataset | "Create insert statements for selected rows" is slow to load

Connections: Various errors within Toad for schemas that are limited by a Profile having sessions_per_user set to 1

Quest Script Runner: Unable to login with a schema configured for External Authentication

Sensitive Data Protection Search: Previously used settings aren't being remembered

Application: Some message dialogs are shown on the wrong monitor

Schema Browser: Compiling invalid objects does not refresh the window to show the new state

Editor: Prompt to reconnect a connection that has terminated does not occur when compiling PL/SQL

Data Grids: Single Column Export is disabled in some cases when it should not be

Editor: Backup file recovery does not work for tabs that were loaded from a previous backup recovery

Connections: Ending a connection that has been terminated results in a prompt to reconnect in some cases when the "Execute queries in threads" option is checked (View | Options | Oracle | Transactions)

Data Grids: Changes made to a newly inserted row are cancelled when entering invalid data into a TIMESTAMP field

Export Dataset: NULL values are excluded in some cases when the "Display large numbers in Scientific Notation" option is unchecked (View | Options | Data Grids | Data)

PL/SQL Templates: Access Violation occurs when creating a new object from template if the path to the template is invalid (View | Options | PL/SQL Templates)

Rebuild Multiple Objects: Access Violation occurs when closing the window while it is loading Lob Segments

Query Builder: Wrong error dialog is used when assigning null to a field having NOT NULL constraint in the data grid

Advanced SQL Optimization: "'value' is not a valid floating point value" error when sending View to Quest SQL Optimizer if Toad and Windows have differing decimal and thousand separator values

Application: When setting a temporary folder to a path that is inaccessible to the current Windows account the following errors occur: Access Denied exceptions and Toad will not start after being closed (View | Options | General)

Login: Wrong error dialog is used when trying to save changes made in either the TNSNames Editor, SQLNET Editor, or LDAP Editor if the current Windows account does not have write access to the respective Net Configuration File for those windows

Login: Exporting saved connections excludes all passwords if the global "Save passwords" option is unchecked on the login window

Schema Browser: Adding a constraint to an existing View uses ALTER TABLE instead of ALTER VIEW in the generated SQL

Login: Importing connections into a new install of Toad does not allow for including passwords associated with the connections

Application: Proxy Automatic Configuration (PAC) scripts are not handled (see Known Issues)

Automation Designer: Access Violation occurs when executing an Import Table Data action after opening its properties dialog and closing the dialog

Alter Tablespace: Backspace key does not work when editing the size of a datafile

Schema Brower: Materialized View script options dialog does not retain the "Add to refresh group after create, subtract before delete" option

Object Palette: GUI control alignment is broken in some cases

Session Browser: Not tolerant of missing fields in V$SESSION after an unfinished Oracle database upgrade

Data Grids: Popup editor for BFILE data will work once and subsequent attempts to show the dialog do not work

Connections: Closing Toad with connections that have been terminated results in a prompt to reconnect in some cases when the "Execute queries in threads" option is checked (View | Options | Oracle | Transactions)

Editor: NCHAR string literal corruption when executing SQL against non-Unicode databases (see Known Issues)

Data Grids: Cannot edit data for tables having a period in the schema name, e.g. "QUOTED.USER"

Data Grids: Erroneous data appended after string literals in some cases

Describe Objects: Current connection's schema name is prepended to the object name when describing objects through a database link

Editor: Duplicate prompts to reload files that have been deleted externally when the "Prompt for reload on activation..." option is checked (View | Options | Editor | Open/Save)

Schema Browser: The selected table loses focus after a "Refresh all" when the Browser Style is set to Treeview

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

Editor: Opening the data grid popup editor repeatedly for grids in multiple Editor tabs can lead to Toad hanging in some cases

Connections: Slow connect times on some databases due to checking for Team Coding's installation state

Editor/Quest Script Runner: Execute as Script does not support bind variables that are declared and set using a single statement, e.g. var bind_var VARCHAR(10) = 'foo';

Data Grids: Access Violation occurs when using Ctrl+Insert to copy records if there is no active connection

Project Manager: Access Violation occurs when Ctrl+RightClick if there are no focused nodes

Master-Detail Browser: List Index Out of Bounds occurs when cancelling the Select Detail Table dialog in some cases

Application: Unexpected error dialogs are shown in various places when invalid or inaccessible directories are set as output destinations

Schema Browser: Argument out of range error occurs upon Ctrl+C or typing in the Tables | Referential tab when no node is selected

Trace File Browser: Argument out of range error occurs upon Ctrl+C when no node is selected

Schema Browser: Access Violation occurs upon Ctrl+Click on an object name in the Script tab when Favorites is active on the left hand side

Schema Browser: List Index Out of Bounds occurs when refreshing the left side if a package having a body and no spec is selected and the Browser Style is set to Treeview

Import Table Data: List Index Out of Bounds occurs when the import source is "MS Windows clipboard" with some clipboard content

Explain Plan: Errors occur if any of the configuration files are corrupt

Team Coding: Cannot focus disabled or invisible window error occurs when editing SVN WebDAV configuration

Data Grids: Wrong error dialog is used when filtering on a date column and entering an invalid date value

Schema Browser: Error occurs when recovering a Tablespace

SQLNET Editor: Error occurs upon opening if sqlnet.ora has comments following some parameters and on the same line

Session Browser: INST_ID invalid identifier error occurs when viewing the Current Statement | Explain Plan if connected to RAC and the "Use RAC views" checkbox is checked

Editor: Access Violation occurs when shutting down Toad after using Add Breakpoint on the Breakpoints tab if the caret is on an empty line and the Script Debugger is the set as the active debugger

Team Coding: Closing an inactive Editor tab results in a prompt to check-in the current object of the active tab

Copy Table Data: Access Violation occurs when shutting down Toad in some cases following multiple Copy Table Data operations

Alter Table: Access Violation occurs when clicking Cancel immediately after clicking OK

AWR Browser: Access Violation occurs and incorrect legend items are shown then the "Overall Phys Reads and Writes" chart is active

Schema Browser: LOGGING_FAILED_RUNS is not supported when viewing scripts for a Scheduler Job Classes

Create/Alter Job Class: LOGGING_FAILED_RUNS is not supported

Database Browser: Various issues with drag/drop behavior

Analyze Objects: Access Violation occurs when closing the window before it has finished loading objects

Schema Browser: Access Violation occurs when closing the window quickly after a refresh if the objects have not finished loading

Schema Browser: Access Violation occurs when selecting a table that has UNDEFINED datatype if the Data tab is active

Editor: Toad hangs when using the mousewheel to scroll if a text selection occurs within a collapsed folding region

Schema Browser: Access Violation occurs when using the right or left arrow key when the left side packages tree has focus, but there is no selected node

Schema Browser: DataController not in GridMode error occurs when using Export Dataset | "Create insert statements for selected rows" and the Memory Sorting grid option is checked

Connections: Access Violation occurs when clicking the End Connection button if more than one connection exists and a filter in the Select Session grid excludes the active connection

Generate Schema Script: Triggers are not included in the script when Extract | Object Types specifies Triggers and Views and Filters | By Name specifies specific triggers and views

Schema Browser: "Team Coding Status" and "Collection Name" columns are not shown when viewing the all tables detail grid and connected to a Team Coding enabled database

Schema Browser: The "View" column header caption changes to "Table" after refresh when viewing all views detail grid and connected to a Team Coding enabled database

Schema Browser: Viewing all sequences detail grid incorrectly lists "Cache Size" value in the "Increment By" column

Document Recovery: Poor performance when selecting a large backup in the Recover Documents window

HTML Schema Doc Generator: "Create Table List File" excludes newlines when a View has a name exceeding 30 characters

HTML Schema Doc Generator: Views having names exceeding 30 characters are not included in the report

HTML Schema Doc Generator: Report shows "is referenced by" instead of "references"

Editor: Unable to end connection or close Editor when debugging and the debug session has terminated

Schema Browser: Unable to retrieve details for packages having an OBJECT_ID greater than 2147483648

Code Analysis: "Test selected rule" does not flag all occurrences in the Code Analysis Rules window (View | Options | Code Analysis | General | Edit Rules)

Toolbars/Menus: Ctrl+P continues to print even when the shortcut has been cleared (View | Options | Toolbars/Menus | Shortcuts)

Schema Browser: Access Violation occurs when dropping a package if a node beneath "Local Subprograms" is selected

TNS Error Assistant: Connection failures due to Oracle client incompatibility are not caught, e.g. Oracle client 19.10 does not work on Windows 7