Toad® for OracleŽ Copyright (c) 1995-2006 Quest Software All Rights Reserved
Toad® Version 8.6.1
Release Notes
LAST REVISED: 03-APR-2006
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.
8.6.1 Patch Information
TOAD version 8.6.1 is provided as a patch with selected fixes to version 8.6. 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.
In particular, the following problems are addressed:
When Oracle patched version 10.2.0.1 with version 10.2.0.2 the structure of the ALL_ARGUMENTS view changed, causing Toad 8.6.0 or earlier to state: "IN" is not a valid integer value when selecting procedures in the Schema Browser or loading them into the Procedure Editor. Toad 8.6.1 remedies this problem.
Additionally, when extracting DDL for tables with LOB data types on a 10.2.0.2 database, the following error will occur:
ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []
This affected basically all of the VDBA areas in Toad (Generate Schema Script, HTML Doc Generator, Compare schemas, etc.) and has also been remedied in Toad 8.6.1.
SQL Tuning has been updated: Click here to read the Release Notes for SQL Tuning 6.1.2
| Number of Bugs Fixed | 2 |
| Number of Enhancements | 0 |
| Number of Known Issues | 0 |
8.6 Release Information
Toad for Oracle 8.6 continues our commitment to not only providing new features but improving and streamlining existing features and windows. The 8.6 development cycle focused on stability, usability, and consistency. Small examples include the reordering of menu items, reorganization of common popup windows, and ensuring that common window behavior and functions existed in all Toad screens where appropriate. The larger examples include screens that have not seen major updates in a few releases, such as the Master Detail browser, the Script Manager, and the SQL Modeler. Other significant enhancements in Toad Standard edition include new views and connection colors in the Server Login window, a new data grid reporting engine, and integrated code profiling in the Procedure Editor.
Toad Professional edition offers an improved PL/SQL debugging experience and greater flexibility running the CodeXpert rule set analysis. Breakpoints now support compound conditions and watches can now break on specified value change. CodeXpert rule set analysis can now be run against multiple files from the Project Manager. Multi-file support is also available from the Project Manager for SQL Scans (Toad Xpert module only).
Toad DBA module introduces an interface to the Oracle 10g Automatic Database Diagnosis Monitor (ADDM). The ADDM Report Generator allows the user to specify a report snapshot range as well as copy the report to clipboard, print, and save report.
This version of Toad provides an optional module allowing for access to Oracle eBusiness Suite through Toad. From the "eBiz" windows, a user may browse the application metadata, view a graphical representation of the current Application stats, search the Applications for specific Lookup values or generate and customize Application activity reports. Enjoy!
Top
Important Installation and Upgrade Information
| ITEM | DETAILS |
|---|---|
| Master/Detail Browser | The window no longer remembers previously selected relationships or filter conditions. This behavior has been replaced with the Open/Save Relationship functionality. |
| 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 as of Toad 8.5. 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 was merged with the Script Debugger in Toad 8.5. 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 | As of Toad 8.5, the 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 as of Toad 8.5. 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
OptionsThe following options have been removed:
- Data Grids > Data "Do not require NOT NULL columns via Toad" - Always true now
- Data Grids > Data "Popup memo editor on double-click" - Always true now
- Data Grids > Visual "Column Sizing" - Always true now
- Data Grids > Visual "Column Moving" - Always true now
- Data Grids > Visual "Allow resize column out of grid" - Always true now
- Data Grids > Visual "Cancel on Exit" - did not work
- General > "Show details following Oracle connections - Was not being used.
- Editors > General "Load table names from database at time of Login" - if "Highlight table names" is checked, this always occurs anyway.
- SQL Modeler > General "Restore ALL Defaults" - Superfluous option
- Startup > "Use locale settings" - Never implemented
Enhancements
Enhancements in Toad for Oracle
Object filters: "Custom Query" option added. This functionality works the same way as View/Edit query does, but it remembers your queries. Regular filter operations will be disabled if this function is used.
Column sorting dialogs now has an option for Nulls First/Last.
Ctrl+A keystroke now puts the grid in multi-select mode and selects all rows, making a quick copy and paste easier.
Schema Browser and SQL Editor are now using common grid popup menus. Menus have also been cleaned up.
External Tools main window now displays full path to the selected tool along with macros, fully expanded (passwords hidden).
New "Grid" menu item added: "Report". This is a powerful 3rd party end user reporting engine that works from nearly all Toad grids.
+ Also launchable from the Master/Detail Browser master and detail grid toolbars and appears in the new Oracle Applications module.
+ When launched from data grids, it will start off with a wizard which makes it easy to create a simple report.
+ When reports are saved, an association is created between the report and the COLUMN NAMES of the dataset from where it was launched. The next time Reports is launched from a dataset that has the exact same column names, the wizard will be bypassed and the saved report will open.
+ Reports can be printed and saved out in multiple formats such as excel, HTML, XML, PDF, JPG, BMP, etc.
Updated with more object support for clusters, policies, policy groups, dimensions, queues, queue tables, refresh groups, snapshot logs, user info, profile of current user, scheduler jobs, programs, and schedules.
Added the ability to specify a rejected record output file name.
Completely rewritten, with many new and improved features. Changes include: an unlimited number of detail datasets can now be assigned to a master dataset and detail datasets can be created in any hierarchy configuration, the master dataset can be a table, view, snapshot, or user defined query and detail datasets can be a table, view, or snapshot, also users can apply the filter/sort window, or manually edit the query for the master or any detail dataset. Lastly all details of the master-detail configuration can be saved to an XML file and re-opened from a MRU dropdown on the window.
Various view styles added to display object lists.
New option added to "Files" node to specify how many files to store for most recently used lists.
New option: Options > Executables "Auto detect path for current Oracle home". When set, this will disable user input into the given utilities and automatically assign their paths based on the Oracle Home used when Toad creates a connection.
Search utility has been moved so it is now integrated into the options window, instead of being separate. Clicking an item in the grid briefly flashes the corresponding control and moves focus to it. The result panel can be shown or hidden.
When used, the Apply button applies all changes and keeps the option window open.
New option added under options -> Schema Browser -> Data -> "Show Body when Package Name is Selected". This option allows you to display the package body on the right side of the Schema Browser, when the package name is selected on the left side of the Schema Browser.
"One per connection" and "One per Toad" columns have added to the window list. Checking this will only allow one instance of a given window.
Object privileges windows now have an incremental search function and no-nag dialog.
Make Code / Strip code functionality added. Identical functionality to the SQL Editor, including same templates.
New Profiler window added to the Procedure Editor from which users can load selected or all Profiler run units into the Procedure to view which line were executed. Also available from the Profiler window are individual line run stats. With the option "Editors > SQL/Procedure > Show executable line indicators in gutters" checked, executed lines are identified with blue dots outlined with green squares and non-executed lines with blue dots outlined with red circles. From the Profiler window, the user may also view the run stats for a given line, including the number of occurrence and average run time. Runs in red identify source objects that have been modified since that Profiler run.
New popup operations added for editor tabs: Close all tabs, Rename tab, and Tab position
New right click action in the editor section for "Send to SQL Editor". This function sends selected text to the SQL Editor and respects variable prefixes that are set in Options > Editors > SQL/Procedure.
New top-level groupings for Declarations, Types, Parameters, and Local Subprograms in the Navigator panel. Right-click and select Configure Navigator to set which items to show in the tree-view, including ordering and grouping when the Sort Navigator option is checked.
Ref Cursor Output now reduced to three options: No Output, DBMS_OUTPUT (strong ref cursors only) and in-memory grid.
Right click menus from editor have been cleaned up and grouped on similar functionality.
The Error Panel is now one of the dockable desktop tabs. If the tab is closed when an error is reached, the tab will show automatically. If the error is corrected, or a new editor tab opened, the Errors panel will auto-hide.
Top-level node sorting added. R-click > Sorting > Top-level
Option added to load views in separate tabs for loading multiple views into the SQL Editor.
SGA Trace, GUI has been reconfigured and enhancements added to the grids.
Auto-trace grid now supports print/copy/sorting.
New popup operations added for editor tabs: Close all tabs, Rename tab, and Tab position
New right click action in the editor section for "Send to Procedure Editor". This function sends selected text to the Procedure Editor.
New status bar added to show record count.
Right click menus from editor have been cleaned up and grouped on similar functionality.
ANSI syntax support has been added. Options->SQL Modeler->General->Use ANSI Syntax.
SQL Recall window has been redesigned to be more intuitive
+ There is still 1 dockable window for all SQL Recall items, which can be toggled via the "View" menu or F8 default shortcut.
+ The window has been broken into 3 tabs, one for each of the 3 types, History, Named, and Personal. Each tab has 2 subtabs, one for All SQL view and the other for Single SQL view.
+ You can edit your SQL via the right click menu in the "All SQL" and "Single SQL" views.
+ The old menus for "Recall Personal SQL" and "Recall Named SQL" on the main "SQL Editor" menu have been restored. These menu items now open the SQL Recall to the appropriate tab.
SQLab availability has been expanded within Toad Xpert. Previously accessible only from the SQL Editor or the Procedure Editor, SQL can now be sent from the SQL Modeler, Session Browser, SGA Trace/Optimization window and the Views, Snapshots, Procs and Triggers tabs of the Schema Browser. Additionally, multiple Create and Alter windows can send and receive SQL to and from SQLab.
New format added: MERGE Statements. Toad can generate MERGE statements for any database version, but they only run on 9i and newer.
"Save dataset as" button added to Tables/Views/Snapshots data grid toolbars.
Options added to right hand side "Browser Style" dropdown button: "Show LHS Item images". This will disable the display of images next to object names.
Status bar added to data tabs displaying current row number, and total number of rows fetched.
"Color" dropdown has been added to specify a connection color (connection color is covered in the "Toad" section of enhancements). The connection is also displayed in the connection section of the Server Login window.
Various view styles added for the previous connections list.
Now has two tabs per open document, one is the Text tab representing the text in ASCII, and the other is a read-only Hex view of the text The Text and Hex view toggles are the same as for the Procedure Editor and SQL Editor. 'View > Options > Editors > Hex' has a few options to control this. The Hex component used here also replaces that used for the BLOB grid popup editor.
All Open/Save dialogs are now resizable and remember their size and position until Toad is closed.
Connection colors added to Toad. A color, or no color (default), can be specified in the Server Login Window. When a color is chosen, this color will be displayed as an outline in the connection and window Toad toolbars. The connection colors will also be displayed as a boarder around all connection-related windows and in the "Change Connection" dialog called from these windows. The color will also be displayed in the status bar of all connection-related windows, so the color can still be seen while running maximized Toad windows.
Toad internal sessions now specify version information in app info, like the Toad application itself does.
Describe support through the F4 shortcut added to all grids.
Grid focus jumps to the first row when performing a column sort.
An optional module allowing for access to Oracle eBusiness Suite through Toad. From the eBiz windows a user may browse the application metadata, view a graphical representation of the current Application stats, search the Applications for specific Lookup values or generate and customize Application activity reports. This module is an available add-on to the base Toad product.
Enhancements in Toad for Oracle Professional
CodeXpert processing is now done entirely in the background, and cancellable. An MDI window opens while processing, showing status of the scan.
Data synchronization has been added to the Compare Data grids. Within the data difference grids, right-click menu items now allow the user to Delete rows from one table or insert them into the other. Selecting the 'Editable Dataset' checkbox allows users to edit table data from within the difference grids. Additionally, many right-click options from the Schema Browser > Tables > Data tab have been added to the grids.
Conditional breakpoints now support compound conditions. Supported are: +, -, /, *, AND, OR, NOT, =, <>, !=, <, <=, >, >=, IS NULL, IS NOT NULL, UPPER, LOWER, (, ), and Variables. Variables must represent a variable that can be evaluated via DBMS_DEBUG.get_value.
In the Set parameters window, the generated anonymous block will always prefix the object schema name to the object name, regardless of the Procedure Editor options setting. This resolves several problems that were caused by debugging procedures outside of the current schema.
Watches can now break when a value meets a condition. For instance, (tempvar = 40) or (tempvar = 50), is a valid condition. Supported are: +, -, /, *, AND, OR, NOT, =, <>, !=, <, <=, >, >=, IS NULL, IS NOT NULL, UPPER, LOWER, (, ), and Variables. Variables must represent a variable that can be evaluated via DBMS_DEBUG.get_value.
Multi-file CodeXpert functions are now available in the Project Manager.
+ "Run CodeXpert" Popup menu operations available from File Folder, File Folder item, and Project nodes. Double click operations available from File Folder and File Folder item nodes.
+ Processing is done entirely in the background and cancellable. An MDI window opens while the scan is processing, showing status of each file as they are scanned.
+ Interactive results tab containing 2 panels (grid and treeview) displays in the Toad's main output window after processing is complete. A scanned file can be opened directly from the CodeXpert results tab in the associated editor with a more detailed results tree in CodeXpert editor sub-tab.
Trace Out debug action added. This new action will complete script execution in the current script then will return you to the caller script if need be.
Enhancements in Toad for Oracle Xpert
Click here to read the current Release Notes for SQL Tuning for Oracle.
The previous SQL Tuning module and SQL Optimizer for Oracle have now been combined into a new single SQL Tuning module for Toad 8.6.
Enhancements in Quest DBA Module
Reporting interface to the Oracle 10g Automatic Database Diagnostic Monitor (ADDM) added. Allows the user to specify a reports snapshot range as well as copy the report to clipboard, print report and save report.
Comparison Source schema dropdown tries to guess which schema to compare based on connection and prior schema selection.
Queries run by the Health Check window now respect the Optimizer Hints configured in options > oracle > optimizer hints.
"Stats" tab added to right hand side. This new tab shows the contents of v$rsrc_consumer_group for the selected group.
Added an icon on the LHS to show if disabled and new right-click menu options to enable or disable Jobs.
Added an icon on the LHS to show if disabled and new right-click menu options to enable or disable Programs.
Added an icon on the LHS to show if disabled and new right-click menu options to enable or disable Window Groups.
Added an icon on the LHS to show if disabled and new right-click menu options to enable or disable Windows.
New LHS Icon to show which Window is currently open.
New right-click Recover Tablespace menu option.
New Drop and Truncate right-click menu items. Drop applies only to tables or indexes, while Truncate is enabled for tables, table partitions, or table subpartitions. Refresh grid maintains any selected rows.
New Drop and Truncate right-click menu items. Drop applies only to tables or indexes, while Truncate is enabled for tables, table partitions, or table subpartitions. Refresh grid maintains any selected rows.
Other Changes to Note
Tab order, option groupings, arrangement, and alignment have been improved throughout the options window. Some options have been moved to different sections as well. All options that were moved will remember their states for upgrading users. To find a particular item, use the new option search utility.
SQL Modeler - Re-design, added tree view on left hand side of the window to replace the criteria tab.
Bug Fixes
"Leave blank for no cache" not correct, you must input an integer value.
"Primary Key", "Unique" or "Ref" checkboxes incorrectly disabled.
Drop Primary Key Cascade whenever you do an Alter Table with $col names
Estimate Table Size -> Single Record View has column mislabeled
Toad hangs when connection is dropped
Variable values not remembered between toad sessions
Compound Breakpoints, i.e. have an AND or OR condition do not work
CRUD MATRIX does not pick up all SELECT (Retrieve) statements.
Package Body run blows Toad away.
Toad gets blown away on CodeXpert run.
Comments truncated at 1240 characters, oracle allows for 4000
Table comments area resize not saved.
Comparing schema against itself using DEF file - finds differences.
Difference found (foreign key) when no actual difference is evident.
MV Index DDLs coming b4 the Views
Synch script incorrect for PL/SQL code that contain RTF literals
Synch script incorrect for sequences where MAXVALUE < current value.
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
Compile Dependent package in connection1, then in connection2 - no error for conn2
PLS-00103 on 10g q {quote} call.
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
Add Scrollbars
Drop synonym when 'include schema' option enabled not including right schema
Incomplete ddl for External Table when logged in as non-OWNER
ORA-06502 on tables with LOOOOONNNNNGGGG check constraint
Compress radio control doesn't add COMPRESS to the script.
Enterprise Authentication limits to 30 characters - not long enough
If view def has '&' in the query, then toad prompts for & substitution
Toad no like reserved words in DB_LINK names
TABLESPACES > Takes Much longer to load than 8.0 (due to TEMP tblsps included now?)
Tablespace Print doesn't respect sorted grid order on Space Tab - forces Usage Sort
Tablespaces -> Objects tab goes blank on refresh when connected as SYSTEM
Isn't honoring FONT setting
Print to Landscape does not work
DBMS_OUTPUT is not shown when Threaded Queries option is used
Index Out of Bounds and ORA-01785 when attempting to sort number column proceeded by XML col
Record Count - ORA-00907 on ORA805 instances
Scientific Notation Options Ignored
Size Column to Data cuts last char or part of last character off
Toad Crash when external table file missing.
AV when "Ignore FK references ..." enabled.
933 (ORA-00933: SQL command not properly ended) when viewing 'SCHEMA' tables.
Data Tab Filters should be saved on change events, not when SB closes or table focus changes.
Data Tab filters are showing up in different databases.
Filter By Current Value doesn't handle strings with embedded quotes
ROWID not available in Sort dialog
Refresh detail brings back hidden column from Select Columns
Toad crash on data tab filter after ORA-01843
Toad crash on data tab filter type mismatch
qryData: Field 'PARAMETER_SET_ID' not found when scrolling through tables
Add ability to hide toolbars for SE Results Tabs just like PE Debugging option
Grids in additional tabs do not default to View Options Grid settings.
Rowcount doesn't display after all rows are fetched
Alert Log (option 6) not working on Oracle 8i instances
Invalid queries for 7.3.4 instances.
Report doesn't run correctly for Redo Log check against multiple connections
Option 'Include Timestamp (Oracle 9i)' does not get saved when enabled by itself
Commit Changes? prompt not being honored.
Debugger querying wrong schema to display compilation errors
ORA-0911 when compile dependent objects for debug session
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 btn to get info
DESC parsing not working correctly against certain synonyms
Drop Column Button disabled on Table F4 popup
"Cannot convert type" when filtering BLOB columns.
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
File -> Load in SQL Editor disabled
Connect query to determine Oracle version stumbles when , is on Oracle version string
Exception Eureka Log when saving to non-existent directory
Test -> Reconnect does not work for OS Authenticated connections
Table name starts with is reading value from Column name starts with control
Doesn't work when a filter is placed in the 'View Name' and 'Column Name'
View DDL Script option not honored when running via Command-Line
RowNum column wider than it needs to be...
Type Source omits member function code
View file shows up as Invalid.
2 clicks required to advance past step 7
Can't focus a disabled or invisible window
Can't focus a disabled or invisible window, Toad crashes - to map cols on data sheet2
Don't Commit not being honored - data is being committed.
Importer does not like large negative numbers from Excel
Mappings dialog screen, mouse focus doesn't remain, and the scrollbar moves when it shouldn't
ORA-01406 when importing records with TIMESTAMP(6)?
Partitions not showing up if STATS have decimal values
ordering not correct anymore
Triggers getting schema name appended twice.
Java has extra '+' added to make code statements
Detail set 5 - not able to scroll through records.
Toad crashes with customer toad.ini
R-Click on Memo Editor Icon activates Memo Editor and then displays R-Click menu
External Exception when clicking on window bar item when another app has focus
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.
OCI-22060 when querying table with object datatype
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
Trigger Source doesn't work on 8i (and probably 8 and 7) databases.
SQL Editor -> SQL Recall page has the F1 lookup disabled.
No support for parallel_enabled parameters
PLS-00201: identifier 'Toad.TOAD_PROFILER' must be declared
AV address 0108B56D when loading package from file and hitting Set Params
Anonymous block causes Oracle Exceptions - Var declaration causing it?
Add/Split partition is double-quoting timestamp values instead of single quoting
Can't do ANYTHING with policies. Object_Name isn't being passed to Oracle.
Page Setup button doesn't work
"Print filename in header" editor option ignored in PE
If multiple connections open, execution of object in 2...n connection will occur in 1st connection
Item History item for Package Body instead pulls up Package Spec
No color Printing from Code window
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.
AV if no Queue Tables and you click in Statistics Tab
Can't create a qtable if no DBA Module
RegEx not working properly
Select Grant missing from Role Script
Filter which brings back no queries breaks the Recall window
Replace Named SQL creates 2 entires of the same name.
After script execution, focus should be on either SE or the Output tab
End key does not take cursor to end of test on a given line.
ROW:COL box not large enough to display entire string
CPU spikes 100% for ReadOnly Toad
Nasty Cascade AV on CNTRL+F4 to close multiple SE windows
Option to save editor contents ignored if editor closed via END CONNECTION
AV when you close and reopen datagrid tab when more than 1 editor tab present.
Customize -> Add icon to toolbar. Open new SE -> Customization not present.
Open File - .SQL File association not working on toad startup
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
Clone Cursor truncates date/time data
Incorrect Data generated in XLS sheet
Insert statements - bad insert created if SHOW ROWNUMS and INSERT NULL TEXT enabled.
SQL*Loader option not playing nice with Timestamp data
XLS Export is switching off AutoComplete in Excel
XLS Instance disables AutoComplete in Excel
XLS Instance takes out the leading 0's in the data.
XLS exporting bad data
XLS slower than what it was in 8.5
Connections with SYSDBA show SYS objects instead of ActiveConnection objects
Detail info disappears if you close any secondary DB connection.
Unnecessary CPU Spike when sitting idle or mouse movement in SB
ORA-24801: illegal parameter value in OCI lob function when querying EMPTY_LOB
Old Script Engine (8.0) truncates output - SQL*Plus converts to Sci Notation to avoid this
Block Changes or Block Gets -> Visible on 10g RAC breaks Session Browser
Can't kill a connection on a RAC database across instances
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
Long Ops tab, completion bar doesn't always reflect % displayed
Waits Tab -> Total_Waits doing a character sort with customer's Toad.ini file
Waits tab, Current Waits -> State always shows WAITED KNOWN TIME
Synch script creates 2 constraints to handle named not null constraint.
"A call to an OS function failed" on table with CRLF in data
Last Column not shown if Rownum and ROWID selected.
ORA-00955 when running script - happens with long snapshot names
Synonyms excluded
USING INDEX TABLESPACE clause missing
AV if click on a snapshot that no longer exists.
PRIMARY KEY not noted on Status info
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
Execution time displayed often incorrect.
Invalid Blob - ORA-22275
Jumping Cursor in the SQL Editor After Execute of SQL
Mouse Click -> Execute Current Statement missing
Index Out of Bounds when space encountered in Name field
Compare with another objects - ORA00942 on 734 and 806 instances.
REBUILD table with blob - remove blob column, blob storage still in ddl to be ran
Rebuild - Toad loops when trying to rebuild table previously rebuilt
Table Privileges will show ROLE with 'Show Users and Roles' but not with just 'Show Role'
All objects not appearing
Gets stuck in loop and hangs Toad
Scissors and Chain bitmaps are gone
BLOCK ID always shows '0' in Segments & Extents window
Internal error (Team Coding): TTCSession.getHost = nil when closing Toad
Compile Invalid Objects is compiling for LoginUser schema, not selected schema
Triggers source is displaying source for ALL triggers, not just ones for the table.
DDL to create TYPE lacks CREATE or REPLACE
UB
Users not being populated when switching from Roles tab
Data Files tab is not showing TEMP TABLESPACE temp files
Doesn't show MAX MB for temp tablespaces correctly
"Free Pct" sorts alphabetically instead of numerically on the Space tab
Tree View > MultiSelect > Create Script does not place scripts on clipboard
'Undeclared Identifier' for watch on variable that has procedure prefixed to var name.
Window will only remember MAXIMIZED if AUTO-OPEN enabled.
Editor Placing CHAR(0) to delimit strings
Format XML is converting processing instructions in an XMLTYPE object into elements
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 | 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. |
| Multi-file Formatting Results | 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 edit in this manor, select "no" to the Package spec/body split prompt. |
| 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. |
| 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 | In an Oracle Apps environment, the default syntax highlighting options (options > Editors > General) can make the SQL Editor open very slowly. | Go to Options > Editors > General and uncheck all of the options to highlight object names. |
| 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. | |
| 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. |
| 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. | |
| Toad Help | Toad Help file no longer opens for Network installs. Microsoft security update 896358 disables ActiveX Components, which renders the Toad help file useless for network installs. | Copy the Toad help file (Toad.chm) from the server to the client and change the following Toad.ini (located in main toad directory under the "User Files" folder) entry to point to the new location:
[SETTINGS] HelpFileDir=C:\Program Files\Quest Software\Toad for Oracle 8.6 Client |
| 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. With and Oracle 10g Instant client or 10gR2 client, the XML Editor will open as RO to avoid data corruption issues. These errors seem to be a result of errors occurring at the Oracle client level, which we cannot control. |
This section contains information about installing and operating this product in non-English or non-ASCII configurations, such as those needed by customers outside the USA. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.
Toad for Oracle 8.6 is not supported in any multibyte operating environment, such as Japanese, Korean, or Chinese Windows, nor does it provide for the proper display of bidirectional data, such as Hebrew or Arabic. Customers requiring multibyte or bidirectional support should use Toad for Oracle International.
IMPORTANT: To avoid data corruption, the NLS_LANG setting in the Oracle home used by Toad must be identical to the system active code page associated with the user's system locale.
The user's locale is set via the Regional Options control panel. A mismatch between the NLS_LANG setting and the code page used by Windows will result in corruption of data in the database, even if the data appears to be correct in the display. Customers should consult the Oracle Database Globalization Support Guide for their version of Oracle to verify the most appropriate client configuration.
Some examples of this include:
Note that the client-side NLS_LANG setting is independent of the character encoding used by the Oracle instance. Toad can connect to any database whose NLS_CHARACTERSET is compatible with the character encoding specified in the client-side NLS_LANG (and which matches the system active code page where Toad is running). In configurations in which the server and client encodings are not identical, the characters are converted by Oracle when stored to or retrieved from the database. Characters not in the target encoding may be lost when this conversion takes place. No warning is produced when characters are lost due to encoding conversions.
Some examples of this include:
IMPORTANT: Do not set the client-side NLS_LANG to use the UTF8 or AL32UTF8 encoding.
Quest Software advises customers using databases with the UTF8 or AL32UTF8 encodings and who are concerned about the ability to store and process data from outside their current Windows code page to use the Toad for Oracle International product. This will avoid this form of data corruption.
For information about the characters contained in specific Microsoft code pages, please refer to the Code Pages supported by Windows
For information about compatibility between various Oracle encodings, or to find out which characters are included in a specific Oracle encoding, please consult the Oracle Globalization Support Guide for your version of Oracle. The Oracle LocaleBuilder utility can be used to view specific encodings and encoding layouts used by Oracle.
Top| Number of Bugs Fixed | 200 |
| Number of Enhancements | 68 |
| Number of Known Issues | 39 |