Toad for Oracle 15.1 - Release Notes

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.

Editor: Caret position is not retained after formatting in some cases

Schema Browser: Identify columns cannot be modified in the data grid

Desktop: A floating dock panel returns to a docked state when it is closed and re-opened

Team Coding: PL/SQL objects that are already in VCS are re-added when compiled

Data Grids: Duplicating a row inserts the new row before the selected row which makes it appear as though nothing happened if the selected row is the last visible row in the grid

Team Coding: VCS client configuration options cannot be modified without the TC_ADMIN_ROLE

Editor: Toad hangs when canceling a compile with debug operation if the object is in use and locked by another process

Schema Browser: Unable to toggle Object/Collection Type visibility when the browser style is set to "Treeview"

Editor: Clicking "Next" on the Replace dialog performs a replace instead of advancing to the next occurrence of the search term

Schema Browser: Statistics tab is blank for Queues having an object ID greater than 2147483648

Workspaces: Transactions window is not restored when loading a workspace

Debugger: When connected to a pluggable database in Oracle RAC using TNSNAMES connection the debug session incorrectly connects to the container database in some cases

Debugger: When connected to a pluggable database in Oracle RAC using direct connection the debug session fails to establish a connection

Connections: Selecting a closed connection from the Change Session button does not prompt for password if it has been changed since the connection was last used; also affects restoring workspaces having connections with new passwords

Data Grids: Posting a null value for a column with a NOT NULL constraint throws an error even if the column is populated by a BEFORE INSERT trigger

Database Health Check: Misleading Feature Usage results when run against a pluggable database

Create Table: Incorrect script may be generated after renaming a column

Data Grids: Modifying date values results in a date conversion error if the data grid "Date format" option is set to YDM

Import Table Data: File preview record numbering does not reflect the file line numbers when the "First Row" option is configured to something other than 1

Schema Browser: Data filter name is cleared when adding new criteria to a saved filter

Editor: Auto Replace does not take the "Additional Word Chars" option into account when looking for word boundaries

Editor: Find dialog does not move out of the way to reveal search matches

Code Insight: Tables related through referential integrity are not shown when the SQL qualifies the table reference with the schema name

Workspaces: Editor tabs are restored incorrectly when the "One/Connection" option is used for the Editor window

Editor: ORA-00942 is encountered when executing SQL having leading tabs in some cases

Master Detail Browser: Access Violation occurs when sorting a detail dataset

Editor: Auto Replace does not work when Tab key is pressed if the "Tab Mode" option is set to "Spaces" or "Smart"

Workspaces: DBMS Output polling options are not restored

Trace File Browser: Errors occur when loading trace files 2 GB or larger

General: Slow load times in environments without internet access

Editor: Access Violation in module SciLexer.dll in some 64-bit installations

Schema Browser: Double clicking an object does not open the Alter window when the right side detail area is hidden and browser style is set to "Treeview"

Schema Browser: Unable to expand package spec/body to view package members when the right side detail area is hidden

Schema Browser: Double clicking a package to load it in the Editor does not obey the "Load spec/body as a pair" option

Editor: Clicking the Save button will prompt to export the Data Grid contents if the Data Grid has focus

Data Grids: Records do not scroll at the same rate as mouse wheel rotation when scrolling quickly

Team Coding: Double clicking a Package or Type spec/body does not load both the spec and body in the Editor

Rebuild Table: ORA-32795 is raised when rebuilding a table having an IDENTITY column

Schema Browser: When Browser Style is set to "Treeview" the tree does not scroll at the same rate as mouse wheel rotation when scrolling quickly

Compare Data: Differences report incorrectly identifies the source and target tables when the two tables have a primary key column of the same name

Document Recovery: Some Editor shortcuts are mapped incorrectly after recovering a document

Workspaces: Access Violation occurs when restoring a workspace that has the Schema Browser opened and navigated to the Favorites tab

Alter Tablespace: Numeric conversion error occurs when using a decimal value for Size and/or Next Extent fields

Alter Tablespace: Max Size field does not accept decimal values and instead removes the decimal separator, e.g. 1.5 becomes 15

Login: Add/Edit Login Record dialog is missing Protocol and Instance Name fields when configuring a direct connection

Code Insight: The query that searches for referential integrity relationships is not optimal and takes a long time to execute in some environments

Schema Browser: Package navigation does not work properly when the "Default EOL Mode" option for files is set to "Unix (LF)" line endings

Workspaces: Restoring workspaces saved in older versions of Toad may create more connections than it should

Editor: Bookmark positions are lost or moved after formatting code

Editor: Auto Replace options exclude the pipe character as an activation char, but since it's part of the concatenation operator it should be present by default

AWR Browser: Date conversion error occurs in some locales

Connections: A race condition when closing a connection results in an Access Violation

Team Coding: DDL operations against an uncontrolled object are blocked and an error message is shown if the object was previously controlled

Workspaces: File modifications that are not saved to disk are not retained as part of the workspace

Workspaces: Files that have been deleted from disk since saving a workspace are not restored; the contents of the file as it was when the workspace was saved should be restored and the tab caption updated to indicate that the file has been deleted

Automation Designer: The Connection Iterator action loops over each connection, one nested action at a time; it should be running each nested action against the current connection before advancing to the next connection like a traditional loop construct

Schema Browser: A race condition when invoking a drop, canceling the query, and closing the window may result in an Access Violation

Schema Browser: Switching between saved filters on the Data tab does not reflect the active filter properly in the status bar

Tablespaces: Viewing datafiles results in an ORA-00904 error when connected to a multitenant container database if the "Include Pluggable Databases" option is checked

Session Browser: Activating an inactive, unmaximized Session Browser window by clicking on its title bar does not change the active connection to be that of the window in some cases

Schema Browser: ORA-01460 occurs if the "Enable value lookup for foreign key constraints" option is checked when browsing data on databases using a non-Unicode character set

Trace File Browser: Some large trace files suffer from an unnecessary performance hit

Editor: Unable to retrieve trace file after execution

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