Toad (r) Copyright (c) 1995-2005 Quest Software All Rights Reserved
Toad 8.5.3 Release Notes
LAST REVISED: 06-JULY-05
Table of ContentsIntroduction
These Release Notes are intended to provide an overview of new functionality and to list many of the fixes that have been implemented in this release of Toad. The Release Notes are also intended to help you upgrade to the new version. For a summary of new features, also see the "What's New" topic in the Toad help file. For an introduction to Toad, please see TOAD Getting Started Guide.pdf located in the 'docs' folder.
Toad for Oracle 8.5 extends the 10g support introduced in the previous release of Toad. New 10g support includes the 10g Instant Client (Toad 8.0 supports Instant Client from the Oracle installer but does not support the stand-alone Instant Client); Browser filter options to exclude recycle bin objects from lists; Global hash partitioned indexes; more datatype and SQL Statement support; and a drop table PURGE option. In addition, Toad DBA module exposes new Oracle 10g features by offering new utilities such as Data Pump (also available in Toad Professional), Segment Advisor, Undo Advisor, Index Monitoring (9i feature), and 10g Scheduling.
Other significant features now offered in Toad for Oracle Standard 8.5 include Terminal Server and Citrix support, Secure Shell support for all of Toad's monitoring and FTP capabilities, a redesigned SQL Editor, RAC support (included in both DBA and non-DBA windows), true threaded query support with the ability to view queries running in Toad, re-designed SQL Recall, and Integrated Windows Task Scheduler with the ability to schedule through many Toad windows.
Toad Professional and Xpert editions now offer more functionality in the CodeXpert Utility. CodeXpert now appears as a sub tab in both the SQL Editor and the Procedure Editor for Toad Professional users. CodeXpert analyzes PL/SQL and now SQL statements against an updated set of rules for best practices. In addition, Toad Xpert Edition users will have the ability to scan the SQL code for inefficient statements that are either problematic or complex, and which should be reviewed further in the SQL Tuning interface. Other Toad Professional enhancements include the Export File Browser (also included with DBA module), Just-in-time Debugging (also known as "External debugging") in the Procedure Editor, and Step-in Debugging has been added for debugging SQL scripts in Toad's redesigned SQL Editor.
TopPatch Information
TOAD version 8.5.3 is provided as a patch with selected fixes to version 8.5. This patch version is not intended to address all reported issues. Rather, it addresses a subset of the issues, selected based on severity and complexity.
Top| WINDOW | DESCRIPTION |
|---|---|
| Browser Filters | User Status filters not working for < 10g DB. |
| Create DB Link | Remove quotes from fields, but still allow manual entry. |
| Create Index | Can't create Local Index on Hash partitioned table on non 10g DB. |
| Describe | Can't describe package across DB link. Add support for lower case named DB Links. |
| File - End All Connections | Access Violation when connected to 3 databases and have Procedure Editors open |
| Installer | The default install directory has changed, detection code needed to locate previous Toad install. |
| Options | F1 lookup disabled for SQL Editor > SQL Recall. |
| Procedure Editor | Static methods don't show in navigator. |
| Procedure Editor | Re-validate object owner on compile. |
| Procedure Editor | Always include the schema name in the execution or debugging session generated anonymous block, independent of the "Procedure Editor - General - Include Owner when extracting source from database" option. |
| Procedure Editor | Exception Eureka Log when saving to non-existent directory. |
| Procedure Editor | Blank error message during debugging session. |
| Save As | Detection code needed to check if file is opened. |
| Script Engine | NO_DATA_FOUND PL/SQL Exception is not being raised. |
| Session Browser - Locks - Blocking Locks | Field 'SQL_Test' not found error. |
| Single Record View | Viewing single record view after running this query produces error: "select chr(13) || chr(10) from dual;". |
| SQL Command Recall | Truncation after 5K and editor contents are being loading from grid, instead of file. |
| SQL Editor | Ctrl/Alt + Up/Down to recall SQL history and overwriting editor contents can't be undone. |
| SQL Editor | Caret position jumping to first character in statement. |
| SQL Editor Script Output | Ctrl+A is non-functional in Script Output tab. |
| SQL Modeler | AutoTrace tab is non-functional. |
| Threaded Queries | DBMS Output is not displayed in the DBMS_OUTPUT window or the SQL Editor tab when Threaded Queries option enabled. |
| Threaded Queries | Auto Commit on: No message to post outstanding transactions when a Commit is performed manually. |
| Threaded Queries | Auto-commit is not committing after record deletions in data grid. |
| Toad Profiler | Error: "PLS-00201: identifier 'TOAD.TOAD_PROFILER' must be declared" when Profiler installed in non-Toad schema. |
| Trigger Editor | Comments being forced to UPPERCASE in some cases. |
| WINDOW | DESCRIPTION |
|---|---|
| Connect | Unable to connect to 64Bit Oracle instances, errors out with "Connections to Oracle 7 require Oracle 8.1.7 clients or older" |
| Connect | 10g instant client does not work if its is the only client installed |
| Procedure Editor/Schema Browser | When running Toad with multiple connections, Toad may execute a PL/SQL Object in the wrong connection. If using the debugger module, the PE lightening bolt will work, but right click "execute outside debugger" will not. If not using the debugger module, the lightening bolt in the PE will execute in wrong schema as well. Executing via the PM will also fail. |
| Procedure Editor/Schema Browser | When loading Triggers into the Procedure Editor, Toad will prefix the schema name twice if the schema name is in the DESCRIPTION column in dba_triggers. |
Important Installation and Upgrade Information
| ITEM | DETAILS |
|---|---|
| Microsoft Excel Support | Excel '97 is no longer supported as of TOAD 7.6. This desupport applies to importing/exporting data through TOAD. |
| Microsoft Windows Support | As of version 7.6, Toad no longer supports Windows 98. Toad supports Windows 2003, NT 4.0, Windows 2000, Windows XP, and Windows 2003. We recommend the latest patches for each operating system. |
| Newline format for character data | The option to "Convert CRLF to LF" has been changed to "Newline format for character data" with choices "Unix" and "Windows" as of TOAD 7.6. If "Unix" is selected, then the behavior is the same as it was with "Convert CRLF to LF" checked: Toad converts carriage return-linefeed pairs in altered text data to linefeeds. If "Windows" is selected, however, then Toad will convert linefeeds in altered text data to carriage return-linefeed pairs. |
| SQL Editor Script Options | The Toad script options have been removed. Toad now respects the SQL*Plus standard login.sql and glogin.sql. The Script options section in SQL Editor options will display this path when login.sql and/or glogin.sql are found. You can also open these files for editing from Toad's options window. |
| Schema Definition Files | SchemaDefFileConverter.exe" was discontinued as of version 7.6. Schema definition files (.def files) created from Generate Schema Script in previous versions of Toad (pre 7.6) will no longer newer versions of Toad. Only Schema Definition Files extracted from a live schema using Toad 8.5 will work in Generate Schema Script. |
| Script Debugger/SQL Editor Merge | The SQL Editor has been merged with the Script Debugger. Script Debugging functionality will only be available for those users who have purchased the debugger license. The only available item on the Script Debugger for those without the Debugger license, will be the "Execute as Script" (lightning bolt) button.
Since the SQL Editor now combines SQL editing/execution with script execution/debugging, you will encounter several shortcut conflicts if you are upgrading. For instance, F8 was for "Step over" in the script debugger, and launched the SQL Recall Window from the SQL Editor. As a result, you will need to right click on the main Toad toolbar and choose "Menu Shortcuts". From there, you can adjust any conflicts as necessary to best fit your working environment, or reset defaults. If you are not upgrading, then you will not encounter shortcut conflicts. The SQL Editor script engine used in previous version of Toad has been removed in favor of an updated script engine used in the old Script Debugger. Since the new script engine conforms to the SQL*Plus standard, you may need to modify some scripts that utilized non-standard aspects of the old Toad script engine. Examples: - SQL statements should be terminated with a semi-colon, anonymous blocks and create function or package calls should be terminated with a newline slash. - the old Toad script engine had different variable scoping rules applying to substitution variables named like &1 and &2. Avoid numeric substitution variables unless you are referring to script arguments. - "Set Maxrows" is an example of a non-standard, Toad-specific command used by the old script engine. This command will no longer work in the new script engine |
| Server Login Window | As of Toad 8.5, The 'SQL*Net compatible Net8' and 'Force SQL*Net (ignore Net8)' options have been removed. These options are no longer necessary since the bugs that they were used as workarounds for have been fixed. |
| Set Table Alias in SQL Modeler | Since the table selector window has been replaced with the Object Palette window (View > Object Palette) for Toad 8.0, the ability to add an alias from the table select window has been removed as well. You can still set a table alias by right-clicking on the table after it has been added to the table model area, and selecting 'Set Table Alias...'. |
| TOAD Security Upgrade from TOAD 7.3 | The items you restricted through TOAD Security in versions 7.3, 7.4, 7.5, 7.6, or 8.0 will still be restricted in Toad 8.5, and there is nothing additional you will need to do. The following items can now be restricted in Toad 8.5: |
| Team Coding | If you plan to use Team Coding, we strongly recommend that you check Options > Procedure Editor > General > Toggle modified flag after compiling source loaded from database. The option defaults to checked in TOAD 7.5, but it is remembered from your previous installs, where it defaulted to unchecked. If the option is unchecked, then switching tabs or windows will disable check-in until you compile again. |
| Team Coding Upgrade from 7.5 | Views are now recognized in Toad's Team Coding module. If you are upgrading from TOAD 7.5, you will need to run the Server Side Objects wizard to update your Team Coding objects. When you upgrade your Team Coding objects from TOAD 7.5 to Toad 8.5, Team Coding will work with TOAD 8.5 and continue to work with TOAD 7.5 as long as CVS is not used as your version control provider. CVS is not supported in older versions. |
| Threaded Queries | SQL Editor options "Process statements in threads / allow queries to be cancelled", "Process Update, Insert, and Delete statements in background (threaded)" and "Process PL/SQL statements and DDL in background (threaded)" have been replaced with the new General option "Execute in threads (creates a new session for every active query). This new option provides true threaded query support. A "Query Viewer" window and new SQL Editor subtab have been added to supplement this new functionality. |
| Toolbars | Toad's pre-packaged toolbar templates have been depreciated. The toolbars will no longer be updated with this and all subsequent Toad releases. However, the toolbars will still appear in your custom toolbar list as read-write. The depreciated toolbar may still be used but will be missing new features. |
Windows Removed from Toad
NT SchedulerNT Scheduler used for the "Schedule to run later" option in the Import/Export Utilities and SQL*Loader Wizard has been removed in favor of the "Task Scheduler"
Script DebuggerThe Script Debugger window has been removed. All functionality previously available in the Script Debugger window is now available in the SQL Editor.
View ConstraintsView Constraints window, previously accessible from the "View" menu, has been removed. The same functionality can be found in the Schema Browser "Views" tab.
TopEnhancements
Enhancements for Base Toad
"Not In" added to filter-by-name drop downs.
"Users" Filters added for every possible Status for user accounts, such as "Expired (Grace)" and "Locked (Time)".
Added Procs tab filtering by AuthID.
Included 'Roles Granted' and 'Roles not Granted' as filter options for Users and Roles.
Added designation of a RAC connection following the connection string. Example: mlerch/mlerch@ORA10G[2], where 2 is the instance ID of the current RAC connection
"Full Row Data" will no longer appear during copy/paste, unless multiple rows are selected.
Added byte/char support for Varchar2, Char, and Varchar columns on 9i & newer has been added to create/alter table window, schema browser - tables - rhs columns tab, drop down select box on sql editor.
Foreign Key lookup is available with the Tables Data Grid is in read-only mode, via the Schema Browser > Data options.
Row operations now abide by the auto commit option in TOAD. This included data edits and row removals, etc. performed in the grid itself.
The low memory threshold TOAD validates during data fetches, is not a configurable option. Available at Options > Data grids > Data, this value includes all available physical and pagefile memory.
Added a second tab to the left side to show active connections
Now supports flushes of both the SGA and DB Buffer Cache, for all selected databases. DB Buffer Cache flush is only available on Oracle 10g databases.
Added the ability to multi-select connections to end during File > End Connection
Added support for column level grants, utilizes DBA views where applicable and displays more items in the drop-down at one time.
Dropdown added to Connect button, listing previously used FTP connections.
New option added to the "Format" tab where you can specify the Character Set. The Character set supplied in this field will be used as a declaration in the .css file generated.
Option to display a unidirectional only data grid added, for improved memory usage during import operations.
Added support for user-defined table relationships. This configuration does not create a foreign key on the detail table, it simply filters the detail table rows for any row selected in the master table. Click on the "..." button next to the table name, to define the Master/Detail relationship.
New screen added under Tools menu, allows the user to grant or revoke multiple privileges on objects to multiple grantees simultaneously.
"Script Options" node has been added below the "SQL Editor" as a child node. These new options replace the old "Script Default" options, which were a top-level node in the options tree. Most of the Toad script options have been removed. Toad now respects the SQL*Plus standard login.sql and glogin.sql. For upgrading users, you will be asked if you want to merge Toad's script options with Login.sql. An option has been added to pass the script only the first time the script is run in the SQL Editor, or it can be run with every script execution.
Single Record View dialog can now list columns alphabetically. The option is under options - data grid - data.
Two new options added to "General" section: "Flash the output window when messages are written to it" and "Flash Toad when inactive and messages are written to the output window".
Option under view > options > sql editor > make code strip code copies to the clipboard
Added "Scroll Pinned Windows" option. This option adds the ability to control the speed with which pinned windows open & close
Added the ability to change the window and connection toolbar fonts
Connection and Window taskbars font can now be adjusted from Options > Toolbars.
If TOAD is the active application, the Output window will flash when messages are written to it.
Pinned Code window now supports sequences.
"Clear all bookmarks" has been added as a right-click menu option.
Option added to format files upon opening
"Remove Dead Links" button added to toolbar. This new button opens a secondary window by were you can specify which link types to remove. The function will remove all objects which no longer exist
"Select Project" dialog dropdown has been changed to accept a new project name in dropdown box while adding new objects to the Project Manager.
Added support for Named SQL objects and collections.
New Action: "Find in Schema Browser". Connects if necessary. This was added to popup and double-click items for Schema Browser nodes only.
New Drag and Drop operations added. The following new options can be customized in "Drag and Drop" tab of the Project Manager Configuration window:
- Drag individual script files (local or server) onto a schema node and they execute (auto-connects as needed).
- Drag local folders onto a schema node and all files (filter respected) in that folder (note: underlying files - whether or not they are nodes) will execute in that schema.
- Drag local or server script files onto a project node and they will execute in all the schema nodes directly under that project. Server files downloaded as needed to Windows temp directory; schema connections made automatically as needed.
- Drag local folder nodes onto a project node and all files under it will execute in all schema nodes under that project, as noted above.
- Drag one or more project nodes onto a schema node and all files in the project will be executed in that schema.
New Node type: "Task." This is a Windows Task, the same as created by Toad's new Windows Task Scheduler interface. Drag and drop is supported from Toad's Windows task scheduler to the Project Manager. A new task can be created from the Project manager as well as viewing existing task's properties. A task can also be run and deleted from this new node.
New Option added - "SmartExpand" (c). This option allows only 1 top-level project node to be expanded at one time. Expanding 1 project, collapses all other project nodes.
New options available for loading files into SQL Editor. New options include a function to load multiple items into SQL Editor creating a new script that references selected scripts.
New panel added which can be toggled above the tree to show current, create new, and end connections. This new panel allows you to multi-select live connections to perform tasks against them such as running scripts and creating database objects. "Copy TNS Names entry to clipboard" option has also been added.
Support added for the multiple file Formatter Plus actions of "Format Files", "Profile Code", and "Check Syntax". These actions are available via 3 different node types: Project nodes, File Folder nodes, and File Folder items.
Added highlighting for queries tied to a still-active dataset. The number of rows processed (total or so far) is added as a column. A new button added to clear queries without any active datasets. The subtabs of "SQL" and "Error" have been moved from the global viewer to the SE.
Added a checkbox for "Compute Statistics" for index rebuilds on Oracle versions 8i through 9iR2.
Test DB link feature now shows some info about the linked database after successful test.
For every left hand side filter that has an option of "Altered in the last X days", you can now choose between created and altered.
Enable Grid > Print and Grid > Save As menu items.
Added ability to administer jobs in other schemas, with privileges to DBMS_IJOB package.
A new icon has been added for objects created with AuthID = Current User.
Error Tab, Deps(Uses), Deps (Used By) tab now all show info for both Package and Package Bodies at the same time
Create, Alter, Compare and Script windows now supports Rules and Transformations in the subscribers.
New Tab - Used by Snapshot - lists info about the snapshot which uses the current snapshot log (if any). F4 or double click on this grid will open a describe window to the snapshot.
New Tab - Uses Snapshots Logs - Lists info about the snapshot which uses the current snapshot log (if any). F4 or double click on this grid will open a describe window.
New refresh dialog available from the Snapshot menu or toolbar. The dialog exposes every option available in DBMS_SNAPSHOT.REFRESH package.
Enable Grid > Print and Grid > Save As menu items.
Filter modified to allow multiple schemas under the 'For Objects Owned By' option.
Synonyms of Synonyms can be resolved in the Schema Browser.
A 'Suggest' button has been added to the constraints tab of the create and alter table windows. When creating a constraint, selecting the button will pre pend the table name to a constraint type descriptor (TABLENAME_PK, TABLENAME_U01, etc.). For databases 9.1 or greater, the 'Suggest' button is also available for renaming system-generated constraints.
In the Create and Alter Table windows, constraints are now defined on their own tab, to allow constraint naming and better constraint definition.
The right-click menu item 'Copy names to clipboard' has been replaced with the ability to CTRL+C from any LHS Schema Browser tab. Options > Schema Browser > Data also has the added option to set the copy format as "one item per line" or "comma separated list."
Data filters have been moved down to the Database level. For example, a filter set for SCOTT.EMP on Database A will no longer apply to SCOTT.EMP on Database B.
Enable Grid > Print and Grid > Save As menu items.
Enable Grid > Print and Grid > Save As menu items.
Schema Browser filters for triggers: - a "search in all schemas" checkbox was added - a "base object type" dropdown was added.
a table/view/database/schema icon now shows if the trigger is enabled and valid (enabled, invalid, or both icon overrides)
an "owner" column is now available on the RHS(becomes visible automatically if "search in all schemas" is checked.
Added 'Compare with another object' as right-click menu item.
Object Grants query modified to access SYS$ tables, if available.
SYS owned objects now included in the Object Grants result listing.
Added checkbox option for SYS/SYSTEM grants.
"Clear all bookmarks" has been added as a right-click menu option.
"Set Schema" dropdown box added to SQL Editor toolbar. If you select a schema other than the connected schema in this dropdown, an ALTER SESSION SET current_schema command is issued prior to execution and again after execution to restore the current_schema back to the connected schema. "Set Schema" is not available for "Execute As Script" (lightning bolt) routine.
A new threaded query engine has been implemented as part of a new option (Options > Oracle > Transactions). If the option is selected then Toad will create a separate session for each query that is executing in each SQL Editor tab. If updating table data in grid, then you will see a Commit and Rollback button that only applies to the current session being used for the SQL Editor tab. If the threaded query option is not selected, then a modal cancel dialog is still presented to the user.
ALT + [PgUp|PgDown] navigates to the previous and next editor tabs.
Added a Threaded Query window for the active editor tab.
Adding a Named SQL Item from the drop-down now appends to, rather than replaces, the existing editor text.
New Options added: "format files upon opening", "use multi-line tabs in the editor", and "Reload files when activating Toad if file timestamp has changed".
New right-click menu added. Right-click over the editor tabs themselves to get new tab, close tab, and a tab menu showing all open tabs.
Selecting ALT+[UP/Down] in the editor window will perform a circular scroll through all available SQL Recall items.
VCR style navigation controls are now being used in the SQL Editor Data Grid. This was done for consistency and adds an easier way to fetch all records.
Added a new Named SQL dropdown to the SQL Editor toolbar, enabling a quick launch for named SQL.
This window has been rebuilt as a dockable window combining the SQL Editor history statements with saved Personal and Named SQL. Within the window grid, Personal and Named SQL statements are labeled as 'Saved Item', and editor history as 'History Item', allowing the user to sort and group statements by category. When the limit of statements to save (set in View-Options-SQL Editor) is reached, then the oldest History item is pushed out when a new History item is added. Saved items are never automatically removed. There is an 'Editable' button on the toolbar, which allows the user to modify the SQL, SQL Type, and Name. This allows the user to move frequently used History items to Saved and name them.
"Auto" button added for Save As Insert Statement. The new function will auto-fill the Insert Schema and Insert Table fields with the schema and table name in the FROM clause of the query run to populate the Grid.
"All" button added to Schema Browser configuration window to quickly enable all tabs.
Added calendar drop-down for date fields, in Single Record View window.
Added option to enable/disable Schema Browser refresh after create/alter object: Options > Schema Browser > Data.
An option has been added to disable the LHS item hints, via the either the RHS Browser Style drop-down or the Options window.
Create and Alter Object Windows are now non-modal.
Enabled incremental search on the Schema and Object Type dropdowns.
In tabbed and treeview modes, the user can now right-click on the LHS column header to chose more than one column to display. Furthermore, the user can also choose whether to autosize the columns.
LHS Item Popup available in one action with just a right-click.
Object type icons can be displayed for LHS tabs and drop-down entries. Icons can be enabled either through Options > Schema Browser > Visual or the RHS Browser Style drop-down.
Quickfilter filter history added. 25 most recent entires available through right-click
A new "Output tab" has been added, which has embedded subtabs for the output from each session scripts are being executed against. A "Grid" subtab will also appear for each select statement in the script. The "Status" tab is now called the "Messages" tab.
Added support for the scheduling of scripts through Toad's new interface to the windows task scheduler. Tasks are setup to run using Quest Script Runner.
New "connections to execute against" toobar button added, removing the prior connection bias. Session to execute against still defaults to the active session.
Oracle Variable "LOCAL" is now supported. If both LOCAL and ORACLE_SID variables are used, Toad uses LOCAL first, then ORACLE_SID. These variables are only used when the Database dropdown is empty.
Oracle client detection code has been updated and Toad now supports connections using a 10g Instant Client.
Support added for those who use multiple aliases for tnsnames.ora entries.
Added button to refresh only the Detail panel.
Current Statement tab has been rearranged to include 3 subtabs for faster performance.
Details for any slave process are listed in the main process grid.
Explain Plan errors are now displayed in the grid.
New static filter added to exclude TOAD background sessions. These sessions are created when Toad executes threaded queries and are given the module name "TOAD background query session".
Old Kill/Trace style filter brought back in the left side of the "Sessions" tab. Select item from "Limit" dropdown and enter filter in the text box. LIKE wildcards are accepted (%) and filter is applied on refresh. Top/Bottom Session Browser arrangement is advised for best use of this feature.
RAC support added:
- Group by: Additional column added for "instance id" representing a RAC instance
- Visible columns: Option to display "instance id" in primary tree/grid
- "Instance ID" appearing in bottom detail grids where appropriate
- Kill Session support killing one or many of the instances on a RAC.
- All necessary views are adjusted (gv$ instead of v$, queries for RAC)
Right click option for "Save to file" has been added for the Sessions Treeview.
Added option checkboxes for including object Grants and Synonyms.
And Object Type drop-down has been added to the Comparison Object section.
Single Record View dialog can now be closed with the ESC key, as long as the dataset has not been edited (or edit was cancelled) - as indicated by the "cancel" button on the navigator.
"View Table Duplicates" screen now has a tab where you can edit the duplicate rows. You can multiselect rows and right click to delete them.
Added and "include data" option on schema browser-tables-script - adds insert statements from the selected tables after the create script.
Certain parameters can now be included/excluded from scripts. These parameters include Parallel/NoParallel, Logging/NoLogging, Cache/NoCache, Compress/NoCompress, and Monitoring/NoMonitoring
New window - Interface to Windows Task Scheduler. This new window replaces the old "NT Scheduler". The Task Scheduler allows the ability to schedule/alter/view Windows tasks through Toad. Tasks that are scheduled in Toad will be run using the Quest Script Runner, located in your current Toad directory.
Scheduling task is available in the following Toad windows:
- File > Task Scheduler
- Project Manager
- All Create/Alter object windows
- Import/Export Utility Wizards
- SQL*Loader Wizard
- Data Pump Import/Export Wizards
- Data Subset Wizard
- Rebuild Table
- Rebuild Multiple Objects
- Compare Schemas
- Compare Databases
- Analyze All Objects
If TOAD is not the active application, the TOAD Taskbar Icon will flash when messages are written to it.
Team Coding support has been added to the Alter View window.
Citrix support has been added to Toad. A "Citrix" option has been added to the installer. Licensing for citrix is at the client level, so every client user will be required to enter individual license keys.
New Option for limiting Users in drop-down boxes. Only users that have objects other than synonyms and temporary tables.
Grid Menu items 'Save As' and 'Print' are now available.
Incremental search of grid results functionality added.
Multi-column sorting added.
Enhancements in the Debugger
New window added under the "DBA" menu called "Export File Browser"
- Available for the DBA and Professional Modules only.
- Lets you browse Oracle Export files. You can see what objects are in your export files, get DDL for one or multiple objects, or for an entire schema.
- Data can be viewed for any table or partition in a grid. Toad's Grid items such as "Save As" and "Print Grid" are available from these grids.
- Compare to Database function lets you compare objects and data in an export file to those in a live Database.
All tabs have been changed to dockable windows, allowing the user to customize and save multiple desktop layouts.
Attach External Session prompt for Debug ID is a dropdown now and remembers past values. Debug ID validation against opened Pipes added.
Just-in-Time debugging added to allow a user to debug PL/SQL code executed from an external application, within the Procedure Editor.
Ref Cursor results grid now includes all relevant read-only right-click operations.
Support for displaying weakly-typed Ref Cursors has been added to the Execute Procedure functionality. This can be enable by selecting either the 'Print to DBMS Output' or 'Load into grid from memory' options on the modified Set Parameters > Options dialog.
Support for displaying weakly typed Ref Cursors has been added to the Execute POrocedure functionality. This can be enable by selecting either the 'Print to DBMS Output' or 'Load into grid from memory' options on the modified Set Parameters > Options dialog.
Step-in debugging added. The "Trace Into" function now allows you to step into called scripts. The Script Debug bottom panel now has "Breakpoints" and "Call Stack" sub tabs available.
The SQL Editor and Script Debugger have been merged into a single window. All Script Debugger functionality is now available from the SQL Editor. Debugging is not available unless you have the Debugger license.
DBA Module Enhancements
Support for enabling and disabling database auditing has been added to TOAD. Single object auditing can be managed from a new RHS Schema Browser tab called 'Auditing'. Multiple objects can be configured either by multi-selecting the objects on the LHS of the Schema Browser and choosing the right-click menu option 'Auditing', or with the Audit Objects window under the DBA menu. There is an additional window under the DBA menu for managing System Privilege and SQL auditing. Audit tabs and menus are read-only unless the DBA module is installed.
When the database is configured to write the audit trail to the DB, rather than the OS, Audit Trail records can be viewed within Toad. For a single schema object, select the object in the schema browser and then choose the 'Audit Trail' radio button from the RHS Auditing tab. The complete DB audit trail is available by selecting the 'Audit Trail' radio button from the Audit SQL/SYS Priv window.
This is a non-modal window which uses Oracle 10g's new Data Pump, a vastly more powerful export utility which runs on the server. DBA > Data Import/Export > Data Pump Export Wizard invokes this new tool.
This is a non-modal window which uses Oracle 10g's new Data Pump, a vastly more powerful import/export utility which runs on the server.
This window monitors jobs for the Data Pump Export/Import wizard. You have the option to Start/Stop/Kill selected jobs.
Ability to view LHS either in a tree style or list style. The list shows active connections and is a much easier way to quickly find the connections to select or multi-select.
RAC support added to Toad. Window modified to query the correct database views.
Now supports flushes of both the SGA and DB Buffer Cache. DB Buffer Cache flush is only available on Oracle 10g databases.
RAC support added to Toad. Window modified to query the correct database views.
Alerts queries modified to handle much larger query results.
Now supports flushes of both the SGA and DB Buffer Cache. DB Buffer Cache flush is only available on Oracle 10g databases.
RAC support added to Toad. Window modified to query the correct database views.
New window added under the "DBA" menu called "Export File Browser"
- Available for the DBA and Professional Modules only.
- Lets you browse Oracle Export files. You can see what objects are in your export files, get DDL for one or multiple objects, or for an entire schema.
- Data can be viewed for any table or partition in a grid. Toad's Grid items such as "Save As" and "Print Grid" are available from these grids.
- Compare to Database function lets you compare objects and data in an export file to those in a live Database.
Added support for 10g Scheduler objects.
Added support for 10g Scheduler objects.
Certain parameters can now be included/excluded from scripts. These parameters include Parallel/NoParallel, Logging/NoLogging, Cache/NoCache, Compress/NoCompress, and Monitoring/NoMonitoring
Option to "Show Errors" added for Procs and Triggers.
All report settings automatically saved.
New window for Oracle 9i and newer for monitoring index utilization. Monitoring can be set for a single index, or for multiple indexes within a schema. A user can see their own indexes, but to view indexes in another schema the user must have access to the following: sys.obj$, sys.ind$, sys.USER$ sys.object_usage. In addition, the user needs the "alter any index" privilege to start and stop the monitoring of another schema's index.
Log switch details available with right-click on any column's cell. The first three columns yield details for the whole day, with any hour column detailing only the selected hour.
Ability to do a quick sort on the Default column: Yes, No or All.
RAC support added to Toad. Window modified to query the correct database views.
Support has been added to the parameters grid for incremental search by parameter name, multi-column sorting and smooth grid scrolling when the scroll bar has been released by the mouse.
The "Find" and "Find Next" buttons have been removed and replaced with an incremental search functionality.
When logged in as SYSDBA, an administrator now has the option of specifying whether changes to a parameter will apply either to Memory, SPFILE or both. Additionally, the comment field is not modifiable.
Passwords are no longer extracted from the data dictionary.
Schema Browser tab added for 10g Scheduling objects. This tab is only available with the DBA Module.
Job program and schedule navigation links added.
Run job, stop job and purge log have been added as right-click menu items.
Schema Browser tab added for 10g Scheduling objects. This tab is only available with the DBA Module.
Schema Browser tab added for 10g Scheduling objects. This tab is only available with the DBA Module.
Schema Browser tab added for 10g Scheduling objects. This tab is only available with the DBA Module.
Schema Browser tab added for 10g Scheduling objects. This tab is only available with the DBA Module.
Open window, close window and purge log have been added as right-click menu items.
Schema Browser tab added for 10g Scheduling objects. This tab is only available with the DBA Module.
Change active undo tablespace functionality and a current undo tablespace icon have been added.
If the user selects F4 on a row with a LOBSEGMENT, in the table describe window that opens, whatever column is associated with the LOB will be selected. When LOB Partitions and Sub partitions are selected in the grid, the associated Partition or Sub partition will be selected as well.
If the user selects F4 on a row with a LOBSEGMENT, in the table describe window that opens, whatever column is associated with the LOB will be selected. When LOB Partitions and Sub partitions are selected in the grid, the associated Partition or Sub partition will be selected as well.
RAC support added to Toad. Window modified to query the correct database views.
New Oracle 10g window to examine database segments for reclaimable space. Once resizing recommendations are made, the user has the option of freeing up the space for each segment or several segments at the same time.
New window to view call of Toad's currently running background queries, the database on which they're running, their current execution time and the SQL for them. The user has the ability to cancel any threaded query, as well as being to front the Toad window which is running the threaded query.
All necessary views have been adjusted to support RAC environments.
New Oracle 10g window for viewing the health of database undo, both overall and within a given time range. The advisor also allows the user to alter the Undo tables, switch to another undo tablespace, adjust database retention time, or get develop projections of required undo space given a retention time.
If the user selects F4 on a row with a LOBSEGMENT, in the table describe window that opens, whatever column is associated with the LOB will be selected. When LOB Partitions and Sub partitions are selected in the grid, the associated Partition or Sub partition will be selected as well.
Other Changes to Note
Added a Code Snippets node under View > Options > Editors. The user now has the ability to add/edit/remove any of the code snippets without having to manually edit the text file using notepad. Eliminating 12 text files and combined them into a single xml file.
Added a code snippets node under View > Options > Editors. The user now has the ability to add/edit/remove any of the code snippets without having to manually edit the text file using notepad. Eliminated 12 text files and combined them into a single XML file.
"Save" toolbar button removed. PM now auto-saves when changes occur.
The Snapshot Logs Schema Browser tab and all related functionality has been moved from the DBA module into Base Toad.
The "Create Public Synonym" right click menu item will be renamed to "Create Synonym". It will bring up a dialog that defaults to public.
CTRL + ALT + [PgUp|PgDown] navigates to previous and next dockable tabs at the bottom of the editor. (This used to be ALT + [PgUp|PgDown]
Changed the Synonym icon on the toolbar buttons/menu items since the old icon indicated a public synonym
With the new multi-tab support in the SQL Editor, the old SQL Editor options in the Script Debugger have been trimmed down into a single option called "Execute via SQL Editor"
'SQL*Net compatible Net8' and 'Force SQL*Net (ignore Net8)' options have been removed. These options are no longer necessary since the bugs that they were used as workarounds for have been fixed.
"Table Privileges" tab renamed to "Granted Object Privileges".
Bug Fixes
"Primary Key", "Unique" or "Ref" checkboxes incorrectly disabled.
Can't handle schema names that contain multiple '.' chars
Object not Found error when parsing table with "MDSYS"."SDO_GEOMETRY"
"Field MONITORING does not exist" error on 7.3.4 and 8.0.X DBs
Estimate Table Size -> Single Record View has column mislabeled
TOAD hangs when connection is dropped
Difference found (foreign key) when no actual difference is evident.
PL/SQL compare not finding code difference if Ignore Comments AND Ignore Whitespace
Synch script incorrect when comparing 2 tables differing by 1 commented column.
Tables being shown with diff due to Rowcounts, due to ORA-01036 on query for rowcount
Alter X Compile with Debug is appending the original owner schema - ORA-01031
Compile Dependent package in connection1, then in connection2 - no error for conn2
ORA-01400 When attempting to copy data (date of 12/30/1899)
Compute Stats and ONLINE are mutually exclusive - oracle allows for this combo
Function Based Indexes - form forces me to specify a column in addition to function
Incomplete ddl for External Table when logged in as non-OWNER
ORA-06502 on tables with LOOOOONNNNNGGGG check constraint
Enterprise Authentication limits to 30 characters - not long enough
Tablespace Print doesn't respect sorted grid order on Space Tab - forces Usage Sort
Delete row only deletes last of multi-selected rows.
Index Out of Bounds and ORA-01785 when attempting to sort number column preceded by XML col
Record Count - Query sent to oracle isn't correct when statement has comments above
Scientific Notation Options Ignored
Size Column to Data cuts last char or part of last character off
AV when "Ignore FK references ..." enabled.
Data Tab filters are showing up in different databases.
ROWID not available in Sort dialog
Refresh detail brings back hidden column from Select Columns
(ORA-03113: end-of-file on communication channel) when viewing across DBLINK
Option 'Include Timestamp (Oracle 9i)' does not get saved when enabled by itself
Debugger querying wrong schema to display compilation errors
Trace Into Type Package Body non functional in 10g
DESC on object resolved via DBLINK data grid > create inserts does not work
DESC on package pulls up blank screen - must hit switch body/spec button to get info
Drop Column Button disabled on Table F4 popup
Load in PE button disabled in DESC popup for Package.
'Apply capitalization effects' option is missing if editor options window is accessed via TOAD opts
Wildcard filter not working
Non-functional if ?Return object names in lower case from selection window and drag and drop? on
Exports fail to Schedule using the NT Job Scheduler window
Columns can be sorted Desc, but not Asc
Test -> Reconnect does not work for OS Authenticated connections
Mixed case roles not quoted for user grants
RowNum column wider than it needs to be...
Type Source omits member function code
View file shows up as Invalid.
Importer does not like large negative numbers from Excel
Partitions not showing up if STATS have decimal values
ordering not correct anymore
AV on Scroll of very large redo log files
New data not viewable before commit when added via trigger
R-Click on Memo Editor Icon activates Memo Editor and then displays R-Click menu
"Show shortcut keys in tooltips" option not working
AV when OS path is stored in HEX
AutoConnect, no save password, change username - ActiveSession not updated?
General Protection fault when Registry has REG_MULTI_SZ env variable.
CNTRL-INSERT copies entire row w/header
OCI-22060 when querying table with object datatype
ORA-00600: internal error code when running .getClobVal for XML
ORA-01405: fetched column value is NULL when querying table with nested TYPE cols
Toad error '0.0' is not a valid timestamp when run a select statement
qrySQL: duplicate field name when querying multiple tables with same column name
Deactivate Search button while search is in progress...hitting it twice hoses toad
AV address 0108B56D when loading package from file and hitting Set Params
Anonymous block causes Oracle Exceptions - Var declaration causing it?
Page Setup button doesn't work
Item History item for Package Body instead pulls up Package Spec
No color Printing from Code window
Not able to use DBMS_OUTPUT to see REFCURSOR output from PE Runs
RHS does not refresh when navigating with keyboard by typing first letter of next proc
SB fails to refresh active LHS object if app focus returns by clicking on a DIFFERENT proc.
File Association Application Properties Parameters are not processing $UID, $UPW, etc.
PM -> Package -> Load to PE -> Both Spec and Body only loads Spec
AV if no Queue Tables and you click in Statistics Tab
RegEx not working properly
End key does not take cursor to end of test on a given line.
Option to save editor contents ignored if editor closed via END CONNECTION
Doesn't pick up optimizer hint for DBA_IND_COLUMNS
Doesn't support case sensitive table/column names.
Problem with column with non-standard character ORA-01747: invalid user.table.column, table.column,
NT Scheduler Doesn't work
Insert statements - bad insert created if SHOW ROWNUMS and INSERT NULL TEXT enabled.
XLS Export is switching off AutoComplete in Excel
XLS Instance disables AutoComplete in Excel
XLS exporting bad data
Connections with SYSDBA show SYS objects instead of ActiveConnection objects
Unnecessary CPU Spike when sitting idle or mouse movement in SB
Old Script Engine (8.0) truncates output - SQL*Plus converts to Sci Notation to avoid this
Conversion Error when UserName column is dragged into the "locked column" area on the left side
Disconnect Session on 7.3.4 results in ORA-02065
Waits tab, Current Waits -> State always shows WAITED KNOWN TIME
USING INDEX TABLESPACE clause missing
Check for dbms_transaction to avoid unnecessary commit reminders not working
Locality settings gets reset [DATE, delimiters, etc]
Thousands separator defaults incorrectly for some languages
Index Out of Bounds when space encountered in Name field
TOAD Reports does not work on UTF8 DB
Create Like is mishandling a column OR constraint
REBUILD table with blob - remove blob column, blob storage still in ddl to be ran
Table Privileges will show ROLE with 'Show Users and Roles' but not with just 'Show Role'
All objects not appearing
Scissors and Chain bitmaps are gone
BLOCK ID always shows '0' in Segments & Extents window
Read Only: Drop ALL triggers available.
DDL to create TYPE lacks CREATE or REPLACE
Data Files tab is not showing TEMP TABLESPACE temp files
"Free Pct" sorts alphabetically instead of numerically on the Space tab
Tree View > MultiSelect > Create Script does not place scripts on clipboard
Debugger hangs when attempting to WATCH outbound vars (:OLD | :NEW)
Known Issues
Top| WINDOW | DESCRIPTION | WORKAROUND |
|---|---|---|
| Data Export | "Create Insert for Selected Rows" and "Data Export" from the schema browser are giving the error "No exportable columns found" when "Return object names in lower case from selection windows and drag drop" is checked under Options > Editors. | 1. Uncheck that option
or 2. Right-click on the data grid and choose "Save As". Choose "Insert Statements". If you have selected multiple rows and want to only export those, then check "Selected rows only". If you want to put only certain columns in the Insert statements, then you will need to use the right-click "Select columns" function to choose the columns for the grid before going to "Save As" or 3. If you just want to get INSERT statements for a lot of tables, go to Database > Export > Table Data |
| Data Grids | Data does not always display correctly when using an older Oracle Client on a newer Oracle Database. | We strongly recommend using Oracle Clients equal to or greater than the Oracle Databases you are on to ensure data integrity. |
| Data Grids | Grid scrolls horizontally back to focused cell when scrolling vertically | Select a cell in the visible part of the grid before scrolling vertically. |
| Data Grids | Pasting multiple rows of text into a cell will only register the first row of the data. | Paste multiple rows of text into the text editor (popup editor) instead of into the grid cell. |
| Data Grids | REF columns now show as "(REFERENCE)" in the grid instead of showing the object ID, but you can still double-click them to pop up a display of the object type that they point to. | |
| Data Grids | Some users have received the error "invalid rowid" when adding a row to a data grid | The error appears to be linked to the use of Oracle 7 client calls. You are using Oracle 7 client calls if either of the following is true:
1. "SQL*Net compatible Net8" is checked on your Server Login window 2. You are using an Oracle 7 client (Note that "Force SQL*Net" will force TOAD to select the Oracle client on your machine.) We strongly recommend upgrading your Oracle client to at least the same version as the Oracle server that you are connecting to. We also recommend unchecking "SQL*Net compatible Net8" -- the only known advantage of using that setting with TOAD 7.5 is that for Oracle 8.0.x clients, it is the only way to get the error position in the SQL Editor |
| Data Grids | You may receive an "ORA-00902 invalid datatype" error when editing object, nested table, or varray data if you have redefined the data type for that data during the current session. | 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. |
| Database Probe | Database Probe does not work with Oracle version 8.1.5. | Upgrade to supported Oracle version 8.1.7 |
| Debugger | Can't watch record declared in package body on Watches tab | Hover the mouse over the name of the record variable to watch the values |
| Debugger | The debugger is not designed to work with word-wrapped lines, since the editor will then have a different set of line numbers than what is stored in Oracle. | Toad provides a warning message about this if you open the procedure editor while word-wrapping is enabled. To disable word-wrap, go to Edit > Editor Options and uncheck "word wrap lines" under "General". |
| Formatter Plus | As long as the FmtPlus.dll exists in the TOAD directory, Toad will read its formatting options from there, even if there are other installations of Formatter Plus on the machine | This behavior is meant to ensure that the version of the FmtPlus.dll that Toad is loading will be high enough. If you have Formatter Plus version 1.4.0.6 (FmtPlus.dll version 4.8.0.23) or higher in another place on the machine and you would like Toad to use the options there, uninstall Formatter Plus from the Toad directory and manually delete the FmtPlus.dll from the Toad directory. |
| LogMiner | You may get the following error when moving from the first screen of the LogMiner to the second screen of the LogMiner:
17:46:25 Info: ORA-06532: Subscript outside of limit ORA-06512: at "SYS.DBMS_LOGMNR_D", line 793 ORA-06512: at line 2 This results from an Oracle bug in 8.1.7.0.0 and 8.1.7.1.0. | Upgrade to Oracle version 8.1.7.2.0 or higher, or see Oracle Metalink Note:124671.1 for details of how to fix the package. |
| Procedure Editor | The procedure editor will jump to the wrong line number for PL/SQL Errors and debugging stepping if the name of the object is not on the same line as the CREATE OR REPLACE | If you add "PELineOffsetOverride=1" under the "[SETTINGS]" section in your Toad.ini, it should fix the offset problems, as long as the CREATE OR REPLACE is on the first line of the editor. |
| Project Manager | After running a "Profile Code", "Check Syntax", or "Format Code" against files in the Project Manager, a results tab appears in the output window. Clicking on an occurrence node in the results tab will load the file in the appropriate Toad window. If you are loading a full package into the Procedure Editor in the manor and select "yes" to the Spec/Body file split prompt, your file will be split into 2 Procedure Editor tabs. At this point, selecting an occurrence node in the output window will only highlight the appropriate line in the Procedure Editor if the line is in the "Spec" tab. Clicking on an occurrence in the Body of the Package will always highlight the last line in the Spec tab. | When loading a package into the procedure editor in this manner, select "no" to the Package spec/body split prompt. |
| SB > Procs | Sometimes on Oracle 8.1.7 or higher, after pressing "Compile invalid objects", you may get:
ORA-20000: You have insufficient privileges for an object in this schema. ORA-06512: at "SYS.DBMS_UTILITY", line 282 ORA-06512: at line 1 This could mean that you really don't 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. | 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. |
| SB > Tables > Data | -Changing the order of the columns in the "View/edit query" popup does not change the order of the columns in the grid.
-Renaming a column in the "View/edit query" popup moves the renamed column one position to the left. The renamed column will not be editable. | Use drag-and-drop in the grid to change the column order. |
| SQL Editor | Cannot close Script Output panel in Script Debugger. | |
| SQL Editor | On an Oracle 8.0 client, if "Display large numbers in scientific notation" is unchecked, and the query contains a non-alphanumeric other than "*", the error "OCI-22061: invalid format text [TM9]" is returned. | Either:
1. Check Options > Data Grid - Data > Display large numbers in scientific notation, or 2. Upgrade the Oracle client to at least Oracle 8.1.6 |
| SQL Monitor | In order to monitor services, you must run the SQL Monitor from one of your local drives. If you try to monitor a service while SQL Monitor is running on a mapped or network drive, you will get the message "Error installing monitor for the service process." This happens because services run under the "Local System" account, which can only see local drives. | Install SQL Monitor on a local drive and run it from there. |
| SQL Monitor | The "Explain plan" options page describes SQL Monitor explain plan's limitations and potential side effects. Mainly, since SQL Monitor has to execute statements, it becomes proactive and can interfere with the program's execution flow. And since it executes statements, the statements may get into the SGA, and there is a remote possibility that they may affect the execution plan of the monitored application's statements. The only 100% guaranteed way of getting the execution plan that was actually used by Oracle for the statement is to turn on server-side tracing and get the plan from there. SQL Monitor is not guaranteed to display the plan that Oracle used, although it should be correct in most cases. | |
| SQL Tuning | Toad Xpert Edition is now supplied with a new in-process SQL Tuning component. This component relies on Microsoft's XML Parser. If the XML Parser is not installed on the client PC, then Toad will return a message "SQL Tuning cannot be found" or "class not registered". | The parser can be downloaded and installed from Microsoft to resolve this issue. |
| Save As > XLS | Exporting data grid cells of over 800 bytes (est.) could cause "OLE error 800A03EC" for Microsoft Office 2003 users when using the "XLS Instance" option. | Save using the "XLS file" option instead |
| Script Manager in Citrix Environment | Installed Script Manager files are not found in a Citrix Environment | Toad installs packaged SQL Scripts with it's Script Manager. When Toad runs in a Citrix environment, the default paths to these script manager files will be pointing to the wrong place on the Server. These paths need to be changed to point to the client's files.
Every client user will have to manually change these paths 1 time. To change the paths, open File > Script Manager and Select the DBA category from the dropdown box. Click the move button and enter your new path, which will be "C:\Documents and Settings\User Name\Application Data\Quest Software\TOAD\ScriptMgr\DBA". Repeat for the "Schema Objects" category and move to "C:\Documents and Settings\User Name\Application Data\Quest Software\TOAD\ScriptMgr\Schema Objects". |
| Server Login | Selecting a new Oracle home in the ''Connect Using'' dropdown box does not guarantee that the correct home will be used. Switching between major Oracle client versions works correctly in Toad. Switching between patch or mid-release versions of Oracle will not always work. For example, switching from Oracle client 9.0.1.4 and Oracle 9.2.0.4 will not guarantee the correct Oracle home is used. | To ensure the proper home is used while logging on, close TOAD use the Oracle Home Selector to select your home, and reload TOAD. Select the correct home in the ''Connect Using'' dropdown and login. |
| Session Browser | "PLS-00553: character set name is not recognized" error encountered when opening Session Browser | We received this when opening the Session Browser on a 9.0.1 database with a 7.3.4 client. We recommend always using a client version greater than or equal to the server version. |
| Session Browser | Session Browser does not work with Oracle version 8.1.5 | Upgrade to supported Oracle version 8.1.7 |
| Session Browser | 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. | |
| Snapshot Script | 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. We have not been able to determine a way to tell the difference between indexes explicitly created on the snapshot and indexes automatically created when the snapshot is created. | 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 re-create 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. |
| Source Control | Legacy Source Control does not support Merrant Version Manager 8.0 and higher. | |
| Team Coding | Most version control providers that integrate with Toad through the SCC API ignore the "Force revision" flag and the "Create a new revision for existing objects" option when exporting. | |
| Team Coding | 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) | |
| Team Coding | Team Coding and PVCS:
-Integration via the SCC API is available but not recommended for PVCS 6.6 and up. -PVCS 6.6.1 is not supported. In testing, we were not able to get check in and check out to function properly. PVCS 6.6.0 and PVCS 6.7.0, however, worked correctly in testing. -PVCS 6.8.0 is not supported because it has been found to cause a crash in Toad after about 5 to 15 minutes of use. We therefore recommend upgrading to PVCS 6.8.1, which does not have this problem. -PVCS Version Manager 6.6 and above only supports "Tip Revisions" via the COM interface used by Toad. Attempting to retrieve a non-tip revision using the Version Control Browser will always return the latest revision. (Merant case id 1230782). This means that comparing revisions in the VCS Browser will fail because both versions will return the text of the latest version of the file. -After connecting to a PVCS database, successive connections made during the same Toad session will always connect to the same PVCS database, even if a different database is specified in the "Logon to PVCS" dialog. | A work-around for this problem is to close and re-open TOAD before attempting to connect to a different PVCS database. If simultaneous connections to two different PVCS databases are required, this can be achieved by opening a second copy of TOAD. |
| Team Coding | Team Coding and SourceSafe:
-Integration via the SCC API is available but not recommended for SourceSafe 6.0 -SourceSafe 5.0 ignores the "Force revision" flag and ignores ''Create a new revision for existing objects'' option when exporting | |
| Team Coding | Team Coding and StarTeam: If you cancel the login dialog for StarTeam, you will not be able to log in to StarTeam until you restart Toad. | |
| Team Coding | Team Coding is disabled for mixed-case object names | |
| Team Coding | When you are using CVS as a version control provider, Toad may fail to retrieve the list of projects for you to select from, either in the VCS Browser or in Code Control Groups configuration. | Toad determines which files and folders are in your CVS repository by reading the file named Entries. This normally resides in a folder named CVS under each of your working folders. If Toad cannot find this file in your top-level working folder, or if this file does not contain all the projects, then Toad cannot retrieve all the projects.
Please see the "Missing CVS\Entries File Error" topic in Help for details about how to create the Entries file. |
| Team Coding | When you log into CVS from within Toad, Toad opens a command prompt window to send the password to the CVS server. Sometimes, the command prompt window opens in the background instead of the foreground, and this causes the login to fail. When this happens, the user needs to select "Log in to VCS Provider" from the Team Coding menu or toolbar to re-do the login. The second attempt invariably succeeds. | |
| Unicode | Toad's data layer does not support UTF8 / Unicode data. Most non-ASCII characters will display as question marks in the data grid and should not produce any conversion errors except in TOAD Reports. TOAD Reports will produce errors and will not run on UTF8 / Unicode databases. It is therefore not advisable to edit non-ASCII Unicode data in Toad's data grids. Also, some users are still receiving "ORA-01026: multiple buffers of size > 4000 in the bind list" messages, which also seem to be related to Unicode data. | |
| XML Editor | "ORA-31001: Invalid resource handle or path name "%s" when trying to post XMLType data that points to a document type definition stored in the XML repository. Even though an insert statement with the same data may work, there appear to be problems with posting these items from the XML editor. | We do not really have a workaround for this. But note that XMLType data that uses a registered XMLSchema for validation seems to post successfully. Also, XMLType data with an inline document type definition also seems to post successfully. |
| XML Editor | An extra newline gets added to the value for a mixed-content node when the XML is stored as XMLSchema. A mixed-content node is a node that has a value as well as subnodes.
For example, this: <node1>value1<subnode1/></node1> Returns exactly the same when it is in a CLOB or in an XMLType stored as CLOB: <node1>value1<subnode1/></node1> But, when it is in an XMLType stored as XMLSchema, it returns from Oracle to TOAD like this: <node1>value1 <subnode1/> </node1> As you can see, an extra newline appeared after value1. When TOAD posts altered data back to Oracle, that extra newline is posted along with the data (unless you manually eliminate it), and when TOAD then retrieves the data again, Oracle has added another newline: <node1>value1 <subnode1/> </node1> | If you wish to use TOAD's XML editor with mixed-content nodes in an XMLType stored as XMLSchema, then any code you use for parsing will need to be insensitive to newlines at the end of values. |
| XML Editor | The XML Editor has been tested successfully with the following combinations:
-Oracle 9.2.0.4 database with 9.2.0.4 client -Oracle 9.2.0.5 database with 9.2.0.5 client -Oracle 10g database with Oracle 10g client Some errors in other configurations: With an Oracle 9.0.1 client and any server, XMLType columns will show up as "(ADT)" and be unreadable. With an Oracle 9.2.0.5 client and a 9.0.1 or 9.2.0.1 server, small XMLTypes seem to work, but trying to post an XML over 4000 bytes to a Unicode database yields "ORA-31011: XML parsing failed" even if the data is all English With an Oracle 9.2.0.1 client and a 9.2.0.4 server, attempting to post data causes "two-task conversion" errors or "ORA-31011: XML parsing failed" errors. With an Oracle 10g client and a 9.2.0.5 database, XMLType data shows in the editor as a long string of question marks. These errors seem to be a result of errors occurring at the Oracle client level, which we cannot control. |
| Number of Bugs Fixed | 109 |
| Number of Enhancements | 171 |
| Number of Known Issues | 39 |