The following is a list of issues addressed and enhancements implemented in this release of Toad for Oracle.
The following list of resolved issues includes issues received from the Toad for Oracle forum, Toad Beta users, and exception data collected from the Toad Improvement Program.
Issue ID | Link to Forum Post | Resolved Issue |
---|---|---|
TOR-1344 | link |
Editor: Caret position is not retained after formatting in some cases |
TOR-5321 |
Schema Browser: Identify columns cannot be modified in the data grid | |
TOR-5370 |
Desktop: A floating dock panel returns to a docked state when it is closed and re-opened | |
TOR-5371 |
Team Coding: PL/SQL objects that are already in VCS are re-added when compiled | |
TOR-5372 |
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 | |
TOR-5373 |
Team Coding: VCS client configuration options cannot be modified without the TC_ADMIN_ROLE | |
TOR-5377 | link |
Editor: Toad hangs when canceling a compile with debug operation if the object is in use and locked by another process |
TOR-5384 |
Schema Browser: Unable to toggle Object/Collection Type visibility when the browser style is set to "Treeview" | |
TOR-5385 |
Editor: Clicking "Next" on the Replace dialog performs a replace instead of advancing to the next occurrence of the search term | |
TOR-5391 |
Schema Browser: Statistics tab is blank for Queues having an object ID greater than 2147483648 | |
TOR-5394 |
Workspaces: Transactions window is not restored when loading a workspace | |
TOR-5409 |
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 | |
TOR-5410 |
Debugger: When connected to a pluggable database in Oracle RAC using direct connection the debug session fails to establish a connection | |
TOR-5411 |
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 | |
TOR-5414 |
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 | |
TOR-5416 |
Database Health Check: Misleading Feature Usage results when run against a pluggable database | |
TOR-5417 |
Create Table: Incorrect script may be generated after renaming a column | |
TOR-5418 |
Data Grids: Modifying date values results in a date conversion error if the data grid "Date format" option is set to YDM | |
TOR-5420 |
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 | |
TOR-5450 | link |
Schema Browser: Data filter name is cleared when adding new criteria to a saved filter |
TOR-5451 | link |
Editor: Auto Replace does not take the "Additional Word Chars" option into account when looking for word boundaries |
TOR-5453 |
Editor: Find dialog does not move out of the way to reveal search matches | |
TOR-5454 | link |
Code Insight: Tables related through referential integrity are not shown when the SQL qualifies the table reference with the schema name |
TOR-5456 | link |
Workspaces: Editor tabs are restored incorrectly when the "One/Connection" option is used for the Editor window |
TOR-5459 | link |
Editor: ORA-00942 is encountered when executing SQL having leading tabs in some cases |
TOR-5461 | link |
Master Detail Browser: Access Violation occurs when sorting a detail dataset |
TOR-5463 |
Editor: Auto Replace does not work when Tab key is pressed if the "Tab Mode" option is set to "Spaces" or "Smart" | |
TOR-5466 |
Workspaces: DBMS Output polling options are not restored | |
TOR-5470 |
Trace File Browser: Errors occur when loading trace files 2 GB or larger | |
TOR-5484 | link |
General: Slow load times in environments without internet access |
TOR-5486 |
Editor: Access Violation in module SciLexer.dll in some 64-bit installations | |
TOR-5489 |
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" | |
TOR-5490 |
Schema Browser: Unable to expand package spec/body to view package members when the right side detail area is hidden | |
TOR-5491 |
Schema Browser: Double clicking a package to load it in the Editor does not obey the "Load spec/body as a pair" option | |
TOR-5493 |
Editor: Clicking the Save button will prompt to export the Data Grid contents if the Data Grid has focus | |
TOR-5495 |
Data Grids: Records do not scroll at the same rate as mouse wheel rotation when scrolling quickly | |
TOR-5496 |
Team Coding: Double clicking a Package or Type spec/body does not load both the spec and body in the Editor | |
TOR-5497 |
Rebuild Table: ORA-32795 is raised when rebuilding a table having an IDENTITY column | |
TOR-5498 |
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 | |
TOR-5499 |
Compare Data: Differences report incorrectly identifies the source and target tables when the two tables have a primary key column of the same name | |
TOR-5502 |
Document Recovery: Some Editor shortcuts are mapped incorrectly after recovering a document | |
TOR-5503 |
Workspaces: Access Violation occurs when restoring a workspace that has the Schema Browser opened and navigated to the Favorites tab | |
TOR-5504 |
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 | |
TOR-5507 |
Login: Add/Edit Login Record dialog is missing Protocol and Instance Name fields when configuring a direct connection | |
TOR-5508 | link |
Code Insight: The query that searches for referential integrity relationships is not optimal and takes a long time to execute in some environments |
TOR-5511 |
Schema Browser: Package navigation does not work properly when the "Default EOL Mode" option for files is set to "Unix (LF)" line endings | |
TOR-5516 |
Workspaces: Restoring workspaces saved in older versions of Toad may create more connections than it should | |
TOR-5518 | link |
Editor: Bookmark positions are lost or moved after formatting code |
TOR-5520 |
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 | |
TOR-5526 |
AWR Browser: Date conversion error occurs in some locales | |
TOR-5527 |
Connections: A race condition when closing a connection results in an Access Violation | |
TOR-5529 |
Team Coding: DDL operations against an uncontrolled object are blocked and an error message is shown if the object was previously controlled | |
TOR-5539 |
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 | |
TOR-5541 | link |
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 |
TOR-5588 |
Schema Browser: A race condition when invoking a drop, canceling the query, and closing the window may result in an Access Violation | |
TOR-5592 | link |
Schema Browser: Switching between saved filters on the Data tab does not reflect the active filter properly in the status bar |
TOR-5595 | link |
Tablespaces: Viewing datafiles results in an ORA-00904 error when connected to a multitenant container database if the "Include Pluggable Databases" option is checked |
TOR-5596 |
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 | |
TOR-5597 |
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 | |
TOR-5609 |
Trace File Browser: Some large trace files suffer from an unnecessary performance hit | |
TOR-5614 |
Editor: Unable to retrieve trace file after execution | |
TOR-5635 |
AWR Reports: ORA-01406 occurs in some cases |
The following list of resolved issues includes issues received from the Toad for Oracle forum, Toad Beta users, and exception data collected from the Toad Improvement Program.
Issue ID | Link to Forum Post | Resolved Issue |
---|---|---|
TOR-2353 | link |
Schema Browser: Usage data shown for the selected Tablespace on the left side is cleared after refresh |
TOR-3566 |
Debugger: Access Violation occurs during mouse-over inspection of ":new" and ":old" variables in triggers | |
TOR-3656 |
Create Unit Test: "not contain" matcher is missing from the list of available matchers | |
TOR-3663 |
Create Unit Test: Incorrect suite DDL generated when accepting the default values for the "All Tests Setup/Teardown" and "Test Setup/Teardown" options | |
TOR-3664 |
Code Snippets: Several utPLSQL matchers do not have code snippets | |
TOR-3665 |
Code Snippets: Several annotations do not have code snippets | |
TOR-4050 | link |
Editor: Bookmark gutter indicators disappear when deleting text in some cases |
TOR-4755 |
Editor: Access Violations occur when answering Yes to reload files that have been modified externally in some cases | |
TOR-4957 | link |
Editor: Executing a valid SELECT against a table with XMLTYPE columns incorrectly results in ORA-00904 or ORA-00936 |
TOR-4985 | link |
Data Grids: When CLOB data is cleared the data is updated to be zero length instead of NULL |
TOR-4993 |
Editor: The progress dialog counts steps incorrectly when executing as script | |
TOR-5021 |
Automation Designer: Unable to use scripts with ampersand in their path | |
TOR-5026 | link |
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 |
TOR-5027 | link |
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 |
TOR-5033 |
Automation Designer: Access Violation occurs when deleting apps | |
TOR-5035 | link |
Export Dataset: Exporting data containing CLOB as Insert Statements can generate lines exceeding the maximum length allowed by SQL*Plus |
TOR-5036 |
Toolbars/Menus Shortcuts: Several features of the Editor do not respect their shortcut assignment when configured to be anything other than the default value | |
TOR-5040 | link |
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 |
TOR-5042 | link |
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" |
TOR-5044 | link |
Copy Data: Excessive error prompting when the option to enable/disable constraints is set and there are errors disabling constraints |
TOR-5045 | link |
Schema Browser: The left side tree for PL/SQL objects is missing a column header and thus cannot be easily sorted |
TOR-5051 |
Editor: Data Grid column width is very narrow after running a SELECT statement if the Data Grid is set to unpinned | |
TOR-5062 |
Compare Multiple Tables: ORA-00972 is raised when generating a differences summary report in some cases | |
TOR-5064 |
Session Browser: The splitter is oriented incorrectly after flipping the form layout | |
TOR-5072 |
Team Coding: The "Check-in All" toolbutton and menu item are disabled even when objects are checked out | |
TOR-5092 | link |
Editor: The Windows taskbar does not flash to notify of query completion when Toad does not have focus |
TOR-5093 | link |
Schema Browser: Altering the size of a tablespace datafile produces an extra, harmless ALTER statement |
TOR-5098 |
Create Table: Invalid floating point exception when clicking Show SQL if the Next Extent storage option has no value | |
TOR-5101 | link |
Workspaces: Loading saved Workspace does not restore the Editor desktop layout properly |
TOR-5102 | link |
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 |
TOR-5118 | link |
Editor: Executing a SELECT that fetches ROWID produces a read-only dataset when the '@' character appears anywhere in the SQL text |
TOR-5122 |
Compare Multiple Tables: Excessive server memory usage when comparing tables with columns of a LOB type | |
TOR-5124 |
Export Dataset: Unnecessary prompt to choose a table in some cases | |
TOR-5131/TMB-3517 |
Editor: Korean fonts are not applied | |
TOR-5133/TMB-2668 |
Toolbars: Custom toolbars are lost after upgrading | |
TOR-5134/TMB-2233 |
Editor: The Navigator is slow to load when the Code Analysis "Check rules as you type" option is set | |
TOR-5136/TMB-2000 |
Script Execution: Alphanumeric variable values unnecessarily require double quoting to work properly | |
TOR-5147 | link |
Editor: When the word wrap option is enabled and text wraps Toad becomes unresponsive in some cases |
TOR-5151 | link |
Code Snippets: The Code Snippets datafile may become corrupt causing loss of all saved snippets |
TOR-5161 | link |
Make/Strip Code: The Make/Strip Code datafile may become corrupt causing loss of all saved templates |
TOR-5162 | link |
Toolbars/Menus Shortcuts: Several features of the Editor do not respect their shortcut assignment when configured to be anything other than the default value |
TOR-5167 |
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 ',' | |
TOR-5171 |
Administer Tablespaces: Datafile free space is incorrectly reported to be 0 in some cases | |
TOR-5181 |
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 | |
TOR-5185 |
Schema Browser: The focused object type node loses focus after refresh when the Browser Style is set to Treeview | |
TOR-5220/TMB-2262 |
Code Insight: ORA-02391 is raised when the connected schema has a profile assigned that limits the number of sessions to 1 | |
TOR-5228 | link |
Schema Browser: Custom tab order is not always applied when using the "Tabbed (multi line tabs)" view style |
TOR-5229 | link |
Data: Large CLOB values on non-Unicode databases experience corruption when fetched |
TOR-5243 | link |
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 |
TOR-5244 | link |
Schema Browser: Incorrect scripts are generated for partitioned tables with referential integrity constraints |
TOR-5246 | link |
Create Synonym: Long object names are unsupported |
TOR-5247 | link |
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 |
TOR-5248 | link |
Team Coding: VCS logon does not occur when attempting to compile a controlled object |
TOR-5250 |
Describe Objects: Access Violation occurs when loading a saved list of objects where one or more objects in the list has been dropped | |
TOR-5252 | link |
Schema Browser: Access Violation occurs when closing the window while it is refreshing |
TOR-5259 |
Import Table Data: Import does not complete after reconnect in some cases | |
TOR-5261 |
Connections: Error upon making a new connection if the connections datafile is locked by another process | |
TOR-5263 |
Alter Materialized View: Access Violation occurs when changing the partitioning strategy | |
TOR-5265 | link |
Reports Manager: Changes made to the Master Dataset are lost when activating the Comments tab |
TOR-5271 | link |
Toolbars: Menu animation reverts to Fade upon Toad startup when the Windows "Fade or slide menus into view" option is set |
TOR-5276 | link |
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 |
TOR-5279 |
Team Coding: "Cannot focus a disabled or invisible window" error occurs when editing the TFS server name in some cases | |
TOR-5280 |
Schema Browser: Access Violation occurs when quickly navigating PL/SQL object dependencies on the right side "Deps (uses)" tab | |
TOR-5281 |
Data Grids: Unhandled error when exporting to Excel when the Excel file is already open and locked by another application | |
TOR-5282 | link |
Explain Plan: Some valid statement type cannot be explained, e.g. CREATE TABLE, CREATE INDEX, etc. |
TOR-5289 |
Make/Strip Code: Access Violation occurs when deleting all Make/Strip Code templates | |
TOR-5291 |
Schema Browser: Changes made to object type visibility in the Configure Browser Tabs dialog are not saved in some cases | |
TOR-5292 |
Compare Data: Access Violation occurs when comparing tables across different sessions if one of the sessions is terminated | |
TOR-5300 | link |
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 |
TOR-5311 | link |
Schema Browser: Rebuild Table excludes triggers from the generated script |
TOR-5314 |
Space Manager: The Setup process incorrectly checks for required privileges | |
TOR-5315 |
Trace File Browser: Access Violation occurs when loading a trace file containing Remote Procedure Calls in some cases | |
TOR-5317 |
Formatter: The option to ensure a trailing newline is non-functional | |
TOR-5318 | link |
Team Coding: The values of Status By and Status Type are switched for Team Projects in some cases |
TOR-5358 |
Connections: Access Violation occurs if a reconnect fails in some cases | |
TOR-5359 |
Data Grids: Pasting string data into a cell does not work in some cases | |
TOR-5366 |
Execute Procedure dialog: "Cannot focus disabled or invisible window" error after hitting ESC key in the arguments grid | |
TOR-5369 | link |
Data Grids: Popup Editor for string data incorrectly applies newline format based on the default value set in Options for working with files instead of obeying the newlines as set in the data or the default newline option for working with data |
The following list of resolved issues includes issues received from the Toad for Oracle forum, Toad Beta users, and exception data collected from the Toad Improvement Program.
Issue ID | Link to Forum Post | Resolved Issue |
---|---|---|
TMB-2737 |
Code Insight: Toad hangs in some cases | |
TOR-1205 |
Formatter: "List Arrangements" option of Wrapped is non-functional | |
TOR-1644 |
Automation Designer: Can't add action to app if the app node has lost focus in the left side treeview | |
TOR-1820 | link |
Toolbars: Connection bar does not update to identify the active session in some cases |
TOR-1938 |
Object Search: Table partitions and subpartitions are not found | |
TOR-2199 |
Code Analysis: Slow to analyze some code when rule 2128 is included | |
TOR-2346 |
Code Insight: List is blank when typing the first character of a valid column name | |
TOR-2669 |
Application: Ctrl+Tab and Ctrl+Shift+Tab does not activate some windows when Toad is in SDI window mode | |
TOR-2770 |
Workspaces: Connection and window order is not retained when saving workspaces | |
TOR-3071 |
Editor: Execute as Script throws an Access Violation when the connection has closed due to timeout | |
TOR-3314 |
SQLNET Editor: ESC key does not close the window | |
TOR-3390 |
Workspaces: Cannot close Toad after loading a saved workspace that opens a Describe Objects window | |
TOR-3598 | link |
Data Grids: Various dataset navigation issues with the nested table popup editor |
TOR-4593 |
Team Coding: Team Coding Manager dock panel is blank if in an unpinned/hidden state when connecting to database | |
TOR-4651 |
Editor: Execute as Script grids do not use sequential numbering in the tab captions when SELECT statements producing no rows are in the script | |
TOR-4653 | link |
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 |
TOR-4654 |
Editor: Executing SELECT against a table with a user-defined type column crashes if the type contains an integer value greater than 2147483647 | |
TOR-4655 | link |
Editor: Execute as Script does not cancel promptly when the script executes long running PL/SQL |
TOR-4656 |
Data Grids: Access Violation occurs when editing a field via the popup editor if the connection has terminated | |
TOR-4657 |
Data Grids: Access Violation occurs when posting edits directly in the grid if the connection has terminated | |
TOR-4658 |
Editor: Executing SELECT against a table with a user-defined type column throws an error if the type contains a SMALLINT datatype | |
TOR-4659 |
Data Grids: Access Violation occurs when the next block of results is fetched if the connection has terminated | |
TOR-4660 |
Schema Browser: Access Violation or Invalid Pointer Operation occurs when viewing the data in a Queue Table | |
TOR-4662 | link |
Team Coding: Materialized Views don't get versioned in the VCS when recreated |
TOR-4675 |
Editor: Editing large text is slow if Sensitive Data Awareness is enabled | |
TOR-4677 |
Compare Schemas: Access Violation occurs when closing the compare text dialog while it is still loading | |
TOR-4678 |
Toolbars: Connection bar images do not update to indicate lost connection | |
TOR-4679 | link |
Rebuild Table: VALIDATE/NOVALIDATE constraint states are excluded when the table has a Foreign Key constraint |
TOR-4680 |
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 | |
TOR-4690 |
Quest Script Runner: Favorite Folders aren't being retained after restart | |
TOR-4692 |
Code Analysis: Results exported to comma delimited text do not use the same precision for Halstead Volume and Maintainability Index as shown within Toad | |
TOR-4693 |
Team Coding: Error converting VCS timestamps on machines with custom time formats when viewing the debug log | |
TOR-4694 |
Database Browser: Access Violation occurs when selecting the node for a database having no connection | |
TOR-4702 | link |
Explain Plan: Viewer (tree style) does not support Adaptive Plans |
TOR-4705 | link |
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 |
TOR-4709 |
Roles/Editions: On Fail behavior (View | Options | Oracle | Roles and Editions) does not work when the schema lacks privileges on the Role or Edition | |
TOR-4710 | link |
HTML Database Doc Generator: Objects privileges granted to Roles are not shown |
TOR-4713 |
Schema Browser: Comparing CDB Resource Plans does not check "CDB Resource Plans" in the Compare Databases window | |
TOR-4714 | link |
Application: Various modal windows are pushed to the background when they should remain as the top-most window |
TOR-4715 |
Import Table Data: Error occurs when importing from MS Access file having erroneous data | |
TOR-4717 | link |
Data Grids: Popup editor closes immediately upon opening when invoked from the last row in the dataset |
TOR-4718 |
Data Grids: Duplicate Row does not work if the table has an IDENTITY column | |
TOR-4722 |
Editor: Team Coding prompt to check-in occurs twice when closing the tab in some cases | |
TOR-4730 |
Editor: Overwriting selected text causes Toad to hang | |
TOR-4731 | link |
Compare Objects: Object privileges granted to Roles are excluded |
TOR-4733 |
Alter Table: Locations and Default Directory are not editable when altering an External Table | |
TOR-4734 | link |
Schema Browser: Can't rename Datafile in non-Enterprise editions of Oracle |
TOR-4739 |
Connections: Oracle 10g RAC connections are not detected | |
TOR-4740 |
Tablespaces: Access Violation occurs when clicking in the Tablespaces window quickly as it is opening | |
TOR-4741 |
Automation Designer: Access Violation occurs when running actions against multiple connections if the option to highlight table names is checked (View | Options | Editor | Display) | |
TOR-4742 |
Copy Table Data: Access Violation occurs in some cases | |
TOR-4743 | link |
Editor: Saving a file that was split (View | Options | Editor | Open/Save) saves the file using ANSI encoding |
TOR-4745 |
ADDM Report: "'' is not a valid floating point value" error occurs | |
TOR-4746 | link |
Alter Tablespace: Floating point values are not accepted when altering the size of a datafile |
TOR-4747 |
Login: Access Violation occurs when testing a saved connection if no Oracle clients are configured | |
TOR-4748 |
Data Grids: Error occurs when pasting into a read-only grid in some cases | |
TOR-4749 | link |
Data Grids: Export Dataset | "Create insert statements for selected rows" is slow to load |
TOR-4750 |
Connections: Various errors within Toad for schemas that are limited by a Profile having sessions_per_user set to 1 | |
TOR-4751 |
Quest Script Runner: Unable to login with a schema configured for External Authentication | |
TOR-4752 |
Sensitive Data Protection Search: Previously used settings aren't being remembered | |
TOR-4754 | link |
Application: Some message dialogs are shown on the wrong monitor |
TOR-4759 |
Schema Browser: Compiling invalid objects does not refresh the window to show the new state | |
TOR-4760 |
Editor: Prompt to reconnect a connection that has terminated does not occur when compiling PL/SQL | |
TOR-4762 |
Data Grids: Single Column Export is disabled in some cases when it should not be | |
TOR-4763 |
Editor: Backup file recovery does not work for tabs that were loaded from a previous backup recovery | |
TOR-4770 | link |
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) |
TOR-4772 | link |
Data Grids: Changes made to a newly inserted row are cancelled when entering invalid data into a TIMESTAMP field |
TOR-4774 |
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) | |
TOR-4777 |
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) | |
TOR-4779 |
Rebuild Multiple Objects: Access Violation occurs when closing the window while it is loading Lob Segments | |
TOR-4780 |
Query Builder: Wrong error dialog is used when assigning null to a field having NOT NULL constraint in the data grid | |
TOR-4781 |
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 | |
TOR-4782 |
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) | |
TOR-4783 |
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 | |
TOR-4786 |
Login: Exporting saved connections excludes all passwords if the global "Save passwords" option is unchecked on the login window | |
TOR-4787 | link |
Schema Browser: Adding a constraint to an existing View uses ALTER TABLE instead of ALTER VIEW in the generated SQL |
TOR-4790 |
Login: Importing connections into a new install of Toad does not allow for including passwords associated with the connections | |
TOR-4791 |
Application: Proxy Automatic Configuration (PAC) scripts are not handled (see Known Issues) | |
TOR-4793 |
Automation Designer: Access Violation occurs when executing an Import Table Data action after opening its properties dialog and closing the dialog | |
TOR-4796 |
Alter Tablespace: Backspace key does not work when editing the size of a datafile | |
TOR-4798 | link |
Schema Brower: Materialized View script options dialog does not retain the "Add to refresh group after create, subtract before delete" option |
TOR-4801 |
Object Palette: GUI control alignment is broken in some cases | |
TOR-4815 |
Session Browser: Not tolerant of missing fields in V$SESSION after an unfinished Oracle database upgrade | |
TOR-4818 |
Data Grids: Popup editor for BFILE data will work once and subsequent attempts to show the dialog do not work | |
TOR-4819 | link |
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) |
TOR-4821 |
Editor: NCHAR string literal corruption when executing SQL against non-Unicode databases (see Known Issues) | |
TOR-4825 | link |
Data Grids: Cannot edit data for tables having a period in the schema name, e.g. "QUOTED.USER" |
TOR-4826 | link |
Data Grids: Erroneous data appended after string literals in some cases |
TOR-4833 | link |
Describe Objects: Current connection's schema name is prepended to the object name when describing objects through a database link |
TOR-4837 | 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) |
TOR-4840 |
Schema Browser: The selected table loses focus after a "Refresh all" when the Browser Style is set to Treeview | |
TOR-4841 |
Export Dataset: Exporting a new sheet to an existing Excel File which contains a pivot table causes file corruption | |
TOR-4843 |
Editor: Opening the data grid popup editor repeatedly for grids in multiple Editor tabs can lead to Toad hanging in some cases | |
TOR-4847 |
Connections: Slow connect times on some databases due to checking for Team Coding's installation state | |
TOR-4848 | link |
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'; |
TOR-4895 |
Data Grids: Access Violation occurs when using Ctrl+Insert to copy records if there is no active connection | |
TOR-4896 |
Project Manager: Access Violation occurs when Ctrl+RightClick if there are no focused nodes | |
TOR-4897 |
Master-Detail Browser: List Index Out of Bounds occurs when cancelling the Select Detail Table dialog in some cases | |
TOR-4898 |
Application: Unexpected error dialogs are shown in various places when invalid or inaccessible directories are set as output destinations | |
TOR-4901 |
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 | |
TOR-4904 |
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 | |
TOR-4905 |
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 | |
TOR-4906 |
Import Table Data: List Index Out of Bounds occurs when the import source is "MS Windows clipboard" with some clipboard content | |
TOR-4908 |
Explain Plan: Errors occur if any of the configuration files are corrupt | |
TOR-4909 |
Team Coding: Cannot focus disabled or invisible window error occurs when editing SVN WebDAV configuration | |
TOR-4917 |
Data Grids: Wrong error dialog is used when filtering on a date column and entering an invalid date value | |
TOR-4923 |
Schema Browser: Error occurs when recovering a Tablespace | |
TOR-4924 |
SQLNET Editor: Error occurs upon opening if sqlnet.ora has comments following some parameters and on the same line | |
TOR-4926 | link |
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 |
TOR-4927 |
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 | |
TOR-4929 | link |
Team Coding: Closing an inactive Editor tab results in a prompt to check-in the current object of the active tab |
TOR-4930 |
Copy Table Data: Access Violation occurs when shutting down Toad in some cases following multiple Copy Table Data operations | |
TOR-4931 |
Alter Table: Access Violation occurs when clicking Cancel immediately after clicking OK | |
TOR-4938 |
AWR Browser: Access Violation occurs and incorrect legend items are shown then the "Overall Phys Reads and Writes" chart is active | |
TOR-4939 | link |
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 |
TOR-4942 |
Database Browser: Various issues with drag/drop behavior | |
TOR-4945 |
Analyze Objects: Access Violation occurs when closing the window before it has finished loading objects | |
TOR-4946 |
Schema Browser: Access Violation occurs when closing the window quickly after a refresh if the objects have not finished loading | |
TOR-4947 |
Schema Browser: Access Violation occurs when selecting a table that has UNDEFINED datatype if the Data tab is active | |
TOR-4948 | link |
Editor: Toad hangs when using the mousewheel to scroll if a text selection occurs within a collapsed folding region |
TOR-4952 |
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 | |
TOR-4953 |
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 | |
TOR-4954 |
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 | |
TOR-4955 | link |
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 |
TOR-4956 | link |
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 |
TOR-4958 |
Schema Browser: Viewing all sequences detail grid incorrectly lists "Cache Size" value in the "Increment By" column | |
TOR-4959 | link |
Document Recovery: Poor performance when selecting a large backup in the Recover Documents window |
TOR-4960 | link |
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" |
TOR-4962 | link |
Editor: Unable to end connection or close Editor when debugging and the debug session has terminated |
TOR-4978 |
Schema Browser: Unable to retrieve details for packages having an OBJECT_ID greater than 2147483648 | |
TOR-4979 |
Code Analysis: "Test selected rule" does not flag all occurrences in the Code Analysis Rules window (View | Options | Code Analysis | General | Edit Rules) | |
TOR-4981 | link |
Toolbars/Menus: Ctrl+P continues to print even when the shortcut has been cleared (View | Options | Toolbars/Menus | Shortcuts) |
TOR-4984 |
Schema Browser: Access Violation occurs when dropping a package if a node beneath "Local Subprograms" is selected | |
TOR-4987 |
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 | |
TOR-4997 |
Describe Objects: Blank window remains open when describing a table the connected schema has no privileges on |
The following is a list of issues, including those attributed to third-party products, known to exist in this release line at the time of the current release.
Known Issue | Issue ID |
---|---|
Toad's help cannot be opened from an installation path that contains Unicode characters. | 72966 |
If you check "Indexes" on the Scripts tab for snapshots, then the primary key for the snapshot will be included in the script, even though the CREATE MATERIALIZED VIEW statement implicitly creates this primary key. Toad currently does not differentiate between indexes created explicitly on the snapshot and indexes created automatically when the snapshot is created. Workaround: If you are running the generated script to recreate the snapshot, then you can simply ignore the error that occurs when the script tries to recreate the primary key index for the snapshot. If you do not normally create indexes on snapshots, then you can uncheck "Indexes" when generating the snapshot script. |
N/A |
If you use 11g Oracle ODP.NET client or any other client that does not have the oci.dll in the BIN directory, Toad has the following problems:
|
N/A |
Debugger If there is an exception during debugging on a 10Gr2 or greater database, REFCURSOR output and DBMS output will not be available when debugging is completed. This is due to the target session not being available. Workaround: To see REFCURSOR output and DBMS output, execute the procedure without the debugger. |
N/A |
Connections While Toad supports LDAP connectivity, some features of Toad depend on tnsnames.ora file to operate correctly, such as Toad Script Runner (TSR). |
N/A |
Schema Browser Sometimes after pressing "Compile invalid objects", you may get ORA-20000, ORA-06512, or ORA-06512 errors. This could mean that you do not have the privileges to compile the object, but it also happens when the schema contains a package body that does not have an associated spec. Workaround: Look in the schema that you are trying to compile to see whether there are any orphan package bodies. If it is your own schema, then do:select * from user_objects o1 where object_type = ''PACKAGE BODY'' and not exists (select ''x'' from user_objects o2 where o2.object_name = o1.object_name and o2.object_type = ''PACKAGE'') Then drop any orphan package bodies that are found. |
N/A |
Virtualization An access violation error may display when you close Toad in a Citrix XenApp environment. |
76354 |
Import/Export Constraint scripts from Export DDL do not contain the "using index" or "tablespace" clause. |
59228 |
Data Modeler:
|
N/A |
Known Issue | Issue ID |
---|---|
All versions of Oracle client 19c leak memory when working with LOB types. This includes simple SELECT statements against a table containing LOB types. |
N/A |
Oracle client version 12.1.0.1 corrupts data received via output bind variables. As a result, numerous errors result immediately upon connection and afterwards. Note: Toad for Oracle does not support Oracle client 12.1.0.1. |
N/A |
Known Issue | Issue ID |
---|---|
Toad does not support Proxy Automatic Configuration (PAC) scripts; however, Toad does allow you to specify Quest-specific proxy settings to work around this limitation. By default Toad will use non-PAC proxy settings configured within Windows automatically. Apply settings system-wide: HKEY_LOCAL_MACHINE\Software\Quest Software\Internet Settings:
For 32-bit applications on a 64-bit machine:
Apply settings to your own account: HKEY_CURRENT_USER\Software\Quest Software\Internet Settings:
Notes for use:
|
72966 |
Known Issue | Issue ID |
---|---|
You may receive an "ORA-00902 invalid datatype" error when editing an object, nested table, or varray data if you have redefined the data type for that data during the current session. Workaround: If you redefine an object type, nested table, or varray and then need to edit data in a table based on that type, end your current connection and begin a new one. |
N/A |
Full table data is not displaying in the live data grid (results from F9) if the data contains "zero" characers (ACII 0). In this case, all data after the zero character will not show in the grid. Workaround: Double click on the data cell in the data grid to view full contents of data in a popup editor. |
Known Issue | Issue ID |
---|---|
Saving results to a database: When dealing with nested procedures, Code Analysis can only insert run data from procs one level deep. | N/A |
Saving PL/SQL results to a database may fail or save invalid data to the database for invalid PL/SQL objects. Workaround: To ensure PL/SQL results are saved to the database correctly, verify the validity of all objects before running Code Analysis. |
N/A |
Known Issue | Issue ID |
---|---|
Toad errors when you query on a field of Oracle collection types. Workaround: Execute using SQL*Plus. |
64373 |
When spooling to an unpinned output window, the window becomes unresponsive and errors are given when Toad is closed ("Canvas does not allow drawing"). Workaround: Keep the output window pinned. |
68523 |
If you use a non fixed-width font, the results are misaligned in the of Script Output tab in Editor after executing a SQL script. Workaround: Go to Options | Scripts and select a fixed-width font for script output. |
62234 |
Known Issue | Issue ID |
---|---|
The Program name in the Session Browser may be blank or may be the full path to the executable instead of just the executable name. This depends on the Oracle client, not on Toad. | N/A |
In RAC databases, version 10.1.0.3 (and possibly other 10.1 versions), the query used to populate the "Current Statement" in the Session Browser fails with the following error: Runtime error occurred: 12801 (ORA-12801: error signaled in parallel query server PZ99, instance <instance name> ORA-01008: not all variables bound) This problem does not occur in Non-RAC environments. Workaround: Clear the "Use RAC Views" checkbox, and log into the appropriate instance of the database, if necessary. |
N/A |
Known Issue | Issue ID |
---|---|
Creating a new revision or attempting to force a check-in to Visual Studio Team Services may result in a "404: Not Found" error. The current version of Team Foundation Server used by Visual Studio Team Services compares the source being uploaded with the source already in the repository. If the source has not changed, it may incorrectly return an error rather than allowing the forced revision. This appears to be a Microsoft issue. As a result, these two commands may fail. |
N/A |
When using the Team Foundation Server internal client and Team Foundation Server 2012 or 2013 alternate Team Project Collections, workspaces created outside of Toad are not visible from within Toad. A workspace may be created from Toad by clicking the ‘New’ button during the Team Foundation Server log in. This is not an issue when using the Team Foundation Server external client. |
114334 |
Team Coding is disabled for mixed-case object names. | N/A |
With CVS, Toad may fail to retrieve the list of projects for you to select from in the CVS browser or in the Code Control Groups configuration. Workaround: See "Missing CVS\Entries File Error" in the online help. |
N/A |
Team Coding and Clearcase: Dynamic Views are not supported via SCC interface. Snapshot Views must be used instead. (Rational case ID v0830629, Rational Defect # CMBU00053934) | N/A |
Known Issue | Issue ID |
---|---|
The following features in Toad do not support Unicode:
In addition, Java itself does not allow Unicode class names or file names. This is relevant to the Java Manager, Editor, and Schema Browser. |
N/A |
Editor options to highlight object names may not work for object names that contain Unicode characters. |
N/A |
Script Execution in Editor: Error offset can be incorrect when running scripts with multi-byte object names. | N/A |
XML (Plain) format creates bad XML if Unicode string values and Unicode column names are exported through Export Dataset. | N/A |
Import mapping for Unicode characters is incorrect if the characters are not a fixed width (such as Korean). |
63221 |
In Team Coding, objects with Unicode contents are supported, objects with Unicode names are not. Supported Version Control Providers do not support Unicode names. | N/A |
The OCI option ORA_NCHAR_LITERAL_REPLACE affects the NCHAR String Literal Replacement behavior when connected to non-Unicode databases. The option can be enabled or disabled. See the "Enable ORA_NCHAR_LITERAL_REPLACE" option (View | Options | Oracle | General). The option has adverse behavior regardless of its value.
|
N/A |
Known Issue | Issue ID |
---|---|
Toolbars (Affects Windows Server 2019 only) Toolbar button images may disappear when you mouse over them if the "High DPI scaling override" option is set to "System (Enhanced)" in the Windows file properties dialog for Toad.exe |
N/A |
Known Issue | Issue ID |
---|---|
Help (Affects the 64-bit version of Toad only) If IE9 is installed, clicking a link in the Help file may crash Toad 64-bit, even if IE9 is not the default browser. Workaround: Users who have IE9 installed can open Help from outside of Toad. |
N/A |
This section contains the hardware, software, and privileges required to run Toad for Oracle, as well as the database and virtual environments that Toad for Oracle supports.
Requirement |
Details |
---|---|
Processor |
1 GHz processor |
Memory |
Note: The memory required may vary based on the following:
|
Hard disk space |
|
Operating system |
|
Requirement |
Details |
---|---|
Database client |
An Oracle client must be installed and configured on the system where you are running Toad. The following are supported:
Note: You must use the 32-bit version of Toad with the 32-bit Oracle client, and the 64-bit version of Toad with the 64-bit Oracle client. |
Database server |
Oracle versions:
Important: It is recommended that your client version be of the same release (or later) as your database server. This is an Oracle recommendation to prevent performance issues. |
Cloud database service |
Oracle Database as a Service on Amazon EC2 and Oracle Cloud |
Requirement |
Details |
---|---|
Additional Software |
|
Type |
Details |
---|---|
Application virtualization |
Citrix® XenApp |
Desktop virtualization (VDI) |
vWorkspace™ 7.0 has been tested. |
Server virtualization |
Oracle VM 3.1 has been tested. VMware ESX Server 3.5, 4.0, and 5.5 have been tested. |
Note: Toad may work in virtualization environments other than the ones listed. |
In order to install and run Toad, make a connection, and do basic operations, you must have the following privileges.
Operating System |
Requirements |
---|---|
Windows 8.1 and 10 Windows Server 2012 R2, 2016, and 2019 |
|
Note: Toad for Oracle Subscription edition is bundled with Quest Auto Update, a service to periodically check for and deliver product updates. Installation requires administrator privileges on all supported operating systems. | |
Note: Other functionality in Toad may require additional privileges. |
To activate a trial
To activate a purchased commercial license
Notes:
Toad for Oracle Subscription requires you to sign in with your Quest.com account. Licenses are tied to your account giving you the flexibility to use Toad from multiple computers without having to move your license.
Sign in with existing Quest.com account
Create a new Quest.com account
Enter the code from the email and select Verify
NOTES:
It may take a few minutes for the verification email to arrive
Check your spam/junk folders for the email sent from supportadmin@quest.com if you do not receive it
For additional assistance, please contact Quest support
Activating a new license
To manage licenses, select Account Settings beneath your account shown at the top-right of Toad
NOTE: You can view your licenses from within Toad by selecting Help | Licensing
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center