Quest Software, Inc.®
Toad for Oracle
Version 9.0.1
Release Notes
November 30, 2006
Important Installation and Upgrade Information
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 short summary of new features, also see the "New in Toad" topic in the Toad help file. For an introduction to installing Toad, please see TOAD Getting Started Guide located in the 'docs' folder.
Toad for Oracle 9.0 continues our commitment to providing new features while improving and streamlining existing features and windows. The 9.0 development cycle focused on stability, usability, and consistency. Some examples include the redesign of the menus to be more intuitive, combining the editors into one window that uses shared commands. In addition the new editor has much greater flexibility for parsing syntax highlighting, including the ability for you to design your own languages. A detailed Reports Manager has been added to provide pre-designed reports and queries through FastReports. In addition, the SQL Modeler has been renamed the Query Builder, and will now reverse-engineer any query it could have created; explain plans have been made easier to read; and RAC support has been improved throughout Toad.
In the Toad Professional Edition, the Code Xpert is now available from the right-click menu around Toad. In addition, it is available in a standalone window from the menus.
In the Quest DBA module, a DBMS_REDEFINITION Wizard has been added to make it easy to redefine and rebuild your tables online. This feature uses Oracle's DBMS_REDEFINITION package. From the Top Session Finder, find any selected session in the Session Browser with just a click. Also, ADDM/AWR functionality has been greatly expanded. Run several automatic reports, create snapshots and baselines easily from Toad.
In the Quest eBiz Module, the reporting functionality has been merged with Toad Reports Manager to make reports easier to find and manage.
TOAD version 9.0.1 is provided as a patch with selected fixes to version 9.0. 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.
| WINDOW | DESCRIPTION |
|---|---|
| Editor | Filtered column dropdown is empty when activated in a select statement (30567) |
| List index out of bounds error when selecting column from filtered column list (30568) | |
| Ctrl+period doesn't activate dropdown while typing within a statement (30569) | |
| Auto-complete overwrites existing code rather than replacing it (30570) | |
| Picklist no longer allows Tab to select column objects (30625) | |
| Compiling invalid PL/SQL does not highlight where the error occured (30571) | |
| Alpha-sort is non-functional in the Navigator (30572) | |
| Replacing all text with an empty string hangs Toad (30579) | |
| Auto replace doesn't work with symbols (30582) | |
| Describe/F4 on table in package body returns "Object not found" (30591) | |
| "No Errors" when compiling invalid procedure in another schema (30195) | |
| F6 does not put focus in Data grid on first try | |
| Missing "Pascal" and "Plain text" languages in Language Management options (30588) | |
| Can't type in Editor when using Windows IME for Korean characters | |
| Mistranslated Korean Characters when loading file in Editor | |
| Double clicking on a column in the Object Palette doesn't add trailing space in Editor (30589) | |
| Editor not treating underscores as non-word chars when highlighting with ctrl+shift (30624) | |
| Ctrl+click on table through DB link doesn't describe (30630) | |
| Auto-repalce is not maintaining case for all caps (30631) | |
| Ctrl+a to select all in script output tab selects all text in Editor window instead (30595) | |
| Cannot up arrow from below folded code (30647) | |
| Toad | Closing Toad when no other applications are open results in application error (30566) |
| "No Oracle homes installed" message on startup in some cases (30599) | |
| Dislpay issues using DPI 120 have been fixed throughout Toad | |
| ORA-01756: quoted string not properly terminated error when trying to connect (30670) | |
| Session Browser | Difficult to place cursor focus in "Expression" pane in Add Filter dialog (30580) |
| Upgrade overwrites existing Session Browser filters (30585) | |
| Import Table Data | "yes to all" is non functional when an error occurs (30583) |
| Schema Browser | AV when opening Packages node in treeview (30605) |
| Incomplete script when selecting multiple MVs and choosing "create script" (30627) | |
| Query Builder | "Allow Cartesian joins" option behaves as if it's always checked (30664) |
| Sub queries not retaining alias assignment (30646) | |
| A dml-file created with Toad 8.6 is not correctly reloaded in Toad 9.0 (30724) | |
| Top Session Finder | Top Session Finder does not compute weighted sums for some of the sessions (30666) |
| Server Login Window | List Index Out of Bounds error when filtering on database column (30628) |
| Script Engine | New option added to run scripts in the main Toad session, instead of creating new session |
| Data Grid | Characters not properly shown with Save As to clipboard, then pasted in Editor (30685) |
| Grid Popup Editor truncates data--Korean character issue (30686) |
| ITEM | DETAILS |
|---|---|
| Desktops | Due to the Editor merge and the addition of new functionality in Toad 9.0, we can no longer preserve old desktop layouts from previous versions of Toad. All previously saved desktop layouts for the main Toad desktop and the Procedure/SQL Editor desktops will be overwritten to the new default layouts. Once Toad is upgraded, users are advised to add customizations back if they wish. |
| Editor Options | Toad now uses a new Editor component, therefore not all pre-9.0 Editor options could be preserved on upgrade. The new "Auto Replace" and "Code Templates" options will recognize your pre-9.0 configurations and will not be lost when upgrading. As for the rest of the old "Editor options" (linked from Toad's main options screen in previous versions), they are now merged in with the other Toad options. The options in question will now revert back to the default settings as if you were re-installing Toad. For example, any custom Editor key mappings that were set for previous Toad versions will not be remembered when you upgrade. The key mappings will be set to match the defaults for Toad 8.6 |
| Editor Toolbars | Due to the Editor merge and the addition of new functionality in Toad 9.0, we can no longer preserve old SQL Editor and Procedure Editor toolbar layouts if upgrading from previous versions of Toad. Since the 2 Editors have been combined into a single Editor, there was no way for us to determine which toolbar to preserve. In addition, new toolbar items available in the single Editor would not be seen for upgrading users. |
| Editors Merge | In Toad version 9.0, the SQL Editor, Procedure Editor, and Text Editor have been merged into a single Editor. The new Editor features context sensitive execution (F9 key or green arrow button). The new execution routine can identify the statement at your caret and perform the correct execution action when a single Editor tab contains heterogeneous statements. PL/SQL can also be compiled directly from the Editor's navigator panel via the Right-click menu. Script Execution is still available in the new editor as well as 3 debuggers (PL/SQL, JDWP, and Script). Only 1 debugger may be used at a time, use the "debug" main menu to switch between debuggers. "Execute Statement at cursor" is still available via Shift+F9, Ctrl+Enter, and the button may be added back to the toolbar using customizable toolbars. The new Editor now has 5 different "Tab Styles" that are used depending on what you are doing in the Editor. For example, if "XML" tab is selected, the tab will be in XML editor mode using the HTML parser and an XML tree will appear. Tab styles are also associated with a Desktop layout and file extensions. |
| Object Loading | The Toad 8.6 option to include owner when extracting
source from database has been changed. There are 3 choices now in Options > Editor > Open/Save > Object
Loading options group. Always include, never include, and include when the owner of the object to load is
not that of the connected schema. In 8.6, if USER1 loads an object owned by USER2 and the include schema
option was unchecked then compiling would still compile that object in the USER2 schema. For 9.0 if the
schema name is not present then compiling will always occur in the connected schema. The new options set
is not mapped to the old "Include owner when extracting source from database" option and defaults to
always include owner.
|
| Options | Due to the Editor merge and the introduction of a new Editor component, there has been some significant options re-work throughout Toad. For example, options previously found in the stand-alone "Editor Options" are now included with the rest of the Toad options. All of the old SQL Editor and Procedure Editor options have been moved and reorganized to be more intuitive with the single Editor. The best way to find the option you are looking for it to use the Options window's search function. |
| Script Execution and DBMS Output | The script execution is an almost identical replacement for SQL*Plus so all script output will go to the script output tab in Toad 9.0. As with SQL*Plus, to see DBMS Output while running a script, a 'SET SERVEROUTPUT ON' command will have to appear at the beginning of your scripts. For frequent use of the server output command, we suggest adding this to your login.sql file. |
| Toad Main Menu | The Toad menus have been completely restructured for Toad 9.0. The new Session menu contains session-specific items such as creating and ending connections and anything else that can modify specific connections. The Database menu has been greatly expanded and generally contains all of the Oracle functionality, arranged by function. The new Utilities menu contains non-connection/Oracle windows for the most part, such as Network Utilities, Archive, and FTP. In the Files menu, you will now find items that operate on files only. The View menu toggles the visibility state of dockable windows along with a few other items that fit nicely in that category. The Search menu contains all search-related functionality from searching text to Oracle object search. The Edit and Grid menus have been left untouched. The "SQL Editor" menu has been renamed to "Editor" menu and the debug menu has not changed with the exception of removing items whose only function was to toggle the visibility of Editor sub-tabs. |
| eBiz Reports | As of Toad 9.0, eBiz Reports, which used to reside in the "eBiz" menu have been moved to Database > Reports > Reports Manager |
| Master/Detail Browser | As of Toad 8.6, this window no longer remembers previously selected relationships or filter conditions. This behavior has been replaced with the Open/Save Relationship functionality. |
| 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. |
| 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. |
| 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. As of Toad 9.0, When using TQ, the "Commit" and "Rollback" buttons on Toad's main toolbar now only act on the current threaded session, instead of acting on all open threads for the current connection. |
| 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. |
| 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. |
| 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. |
| Team Coding | If you plan to use Team Coding, we strongly recommend that you check Options > Editor > Execute/Compile > 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. |
| 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: |
| Parser and Syntax Highlighting in Editor | Due to the Editor merge and the addition of new functionality in Toad 9.0, we can no longer preserve custom syntax highlighting, or any other parser customizations made to Toad's pre-9.0 parser files. |
"Leave blank for no cache" not correct, you must input an integer value. QCM 27445.
"Not a valid component name" error when a component is in quotes. QCM 30012.
Drop Primary Key Cascade whenever you do an Alter Table with $col names. QCM 27361.
Error when changing a column name that has a column comment. QCM 30144.
Toad is querying for XML data even if table doesn't have any XML columns. QCM 27946.
Column-level grants not appearing in alter user window, Objects Granted tab. QCM 29013.
Proxy users not showing in SB. QCM 28361.
Autotrace shows all zeroes when logged in as SYS. QCM 27783.
Doesn't work when Threaded Queries enabled. QCM 27988.
Access Violation after killing concurrent session, then ending connection. QCM 29030.
Control 'dpSELiveGridFrame' has no parent window" Msg During Startup. QCM 27891.
"Period as separator" not working for substitution variables with "Execute as statement". QCM 21911.
Getting invalid date format when pressing
Not remembering the last bind variable value if NULL. QCM 28800.
Substitution variable not prompted for when select has comment without spaces. QCM 27851.
Variable values not remembered between toad sessions. QCM 27220.
Bind variable detected in quoted string. QCM 27126.
Compound Breakpoints, i.e. have an AND or OR condition do not work. QCM 27227.
"List index out of bounds (-1)" after changing categories and clicking in listview. QCM 24881.
CRUD MATRIX does not pick up all SELECT (Retrieve) statements. QCM 27417.
ER for CodeXpert to print the results tab and for there to be an expand all. QCM 28569.
Toad gets blown away on codexpert run. QCM 27929.
When the customer cancels or closes a Code Xpert window, he immediately receives Access Violation. QCM 28494.
9.2 is not a valid floating point value error in CodeXpert. QCM 28349.
Comments truncated at 1240 characters, oracle allows for 4000. QCM 27565.
Table comments area resize not saved. QCM 27377.
F9 of ALTER TABLE MOVE TABLESPACE of IOT cause tabledata to be truncated. QCM 28891.
Toad allowing ability to alter TEMP tablespace datafile and therefore throwing error. QCM 29564.
File>Print does not work in Compare Files. QCM 28190.
'Out of Memory' errors when generating and comparing schemas. QCM 29814.
Comparing schema against itself using DEF file - finds differences. QCM 27648.
Customer would like Compare Schemas to enable Fine Grained Access Control. QCM 28103.
Licensing Loophole: Sync Script tab allows "Schedule" for non-dba users. QCM 28108.
MV Index DDLs coming before the Views. QCM 27271.
ORA-00918 column ambiguously defined in Schema Compare. QCM 29794.
Redundant entry in sync script when altering a table. QCM 28731.
Schema Compare ignores differences in materialized views. QCM 28228.
Sync script attempts to drop indexes before constraints. QCM 30396.
Sync script tries to drop/recreate index that is necessary for a primary key. QCM 24618.
Synch script incorrect for PL/SQL code that contain RTF literals. QCM 27156.
Synch script incorrect for sequences where MAXVALUE < current value. QCM 27614.
ER to have compare results in format other than RTF, such as HTML. QCM 29248.
Unable to retain multi-selected items in results (interactive) tab. QCM 28986.
Procedure compiled in toad won't execute, compiled in SQL*Plus just fine. QCM 27581.
S360: parsing issue on CASE statement leads to NO CREATE OR REPLACE found error. QCM 26077.
ORA error when attempting to create a dupe link. QCM 30451.
Add Scrollbars. QCM 27268.
Sort list in queue table script always shows 'PRIORITY' although ENQ_TIME also selected. QCM 29768.
Columns of 'xmltype' not retaining their NOT NULL characteristics in SB generated script. QCM 28017.
Create script (r-click on LHS) does not work for table names enclosed in quotes. QCM 28214.
Drop synonym when 'include schema' option enabled not including right schema. QCM 27557.
User would like to see "create script" output tab to have ability to save in Unix format. QCM 28677.
Error when creating materialized view with DBLink. QCM 30045.
Synonyms created for a DBlinked object do not show RHS data or show wrong data. QCM 28037.
Create Like function not recognizing OVERFLOW parameters on table create. QCM 28300.
Compress radio control doesn't add COMPRESS to the script. QCM 27299.
Create user/Enterprise forces CAPS when it shouldn't. QCM 28676.
When truncating a table in a different schema and connected as OS user, error results. QCM 28985.
If view def has '&' in the query, then toad prompts for & substitution. QCM 27384.
Toad does not like reserved words in DB_LINK names. QCM 27346.
Toad is commiting all open SQL Editor sessions at once. QCM 28196.
Export source code-triggers causes double slash "/" in output. QCM 28392.
Exporting source code with comments results in error. QCM 28366.
Toad chokes on importing views with the FORCE keyword. QCM 30084.
"Cannot insert NULL" error when using DEFAULT NOT NULL. QCM 29958.
Access Violation when importing data from table source. QCM 28680.
Error "ORA-00928 missing SELECT keyword" when keyword used in column name. QCM 28628.
Getting error "Invalid variant type conversion" during Access import. QCM 30111.
TABLESPACES > takes much longer to load than 8.0 (due to TEMP tblsps included now?). QCM 27432.
Tablespaces -> Objects tab goes blank on refresh when connected as SYSTEM. QCM 27510.
Can't work with window if undocked. QCM 27372.
Isn't honoring FONT setting. QCM 27553.
Print to Landscape does not work. QCM 27164.
No DBMS output after closing and re-opening SQL Editor. QCM 28510.
Toad not correctly handling error when invalid index found in dupe data. QCM 29820.
ER to reintroduce ability to copy column names from sort dialog. QCM 29176.
Exporting data to flat file generates all columns despite number of selected columns. QCM 28189.
Odd scrolling behavior in data grid. QCM 28029.
Print Grid/Preview/Page Setup not retaining A4 setting. QCM 28400.
Print error in data grid. QCM 28127.
Record Count - ORA-00907 on ORA805 instances. QCM 27286.
Record count yields ORA-00942 error when resultset is from a different schema. QCM 28618.
Save As .XLS File does not display the correct data. QCM 28264.
Toad crash when external table file missing. QCM 27513.
Unable to update view under certain conditions. QCM 30234.
Data length shows as one byte less than is displayed when viewing BLOB in hex. QCM 28678.
User requests that Data Grid>>Find data dialogue store a list of values for repeated searches. QCM 28028.
ER to have values within SRV editable (ctrl+c, ctrl+v, etc). QCM 28686.
933 (ORA-00933: SQL command not properly ended) when viewing 'SCHEMA' tables. QCM 27804.
Data tab filters should be saved on change events, not when SB closes or table focus changes. QCM 24006.
Filter shouldn't clear when ORA error encountered for WHERE clause. QCM 27997.
Filter by Current Value doesn't handle strings with embedded quotes. QCM 27334.
Toad crash on data tab filter after ORA-01843. QCM 27657.
Toad crash on data tab filter type mismatch. QCM 27924.
qryData: Field 'PARAMETER_SET_ID' not found when scrolling thru tables. QCM 27523.
Add ability to hide toolbars for SE Results Tabs just like PE Debugging option. QCM 27524.
Grid missing 'Reset Column Order' on R-Click list. QCM 24237.
Grids in additional tabs do not default to View Options Grid settings. QCM 27573.
Record count doesn't respect SET SCHEMA dropdown control. QCM 27407.
Rowcount doesn't display after all rows are fetched. QCM 27302.
SQL Editor data grid output is treating column headers oddly. QCM 28106
XML GetClobVal function no longer works. Grid no longer shows any data for normal XML queries. QCM 22618.
Alert Log (option 6) not working on Oracle 8i instances. QCM 27298.
Invalid queries for 7.3.4 instances. QCM 27360.
Report doesn't run correctly for Redo Log check against multiple connections. QCM 27347.
TOAD not monitoring fully for errors while using the UTL_FILE package. QCM 28117.
Health Check not able to read alert logs with multiple sessions. QCM 29709.
Script to create user generates incorrect SQL after revoking Unlimited Tablespace. QCM 29747.
Overflow while converting variant of type (Double) into type (Integer). QCM 24766.
Entering SYSTIMESTAMP, toad strips out time component when sending insert to oracle. QCM 28005.
Commit Changes? prompt not being honored. QCM 27647.
ORA-0911 when compile dependent objects for debug session. QCM 27688.
DESC parsing not working correctly against certain synonyms. QCM 22992.
Copy and paste from describe window yields erratic results. QCM 28356.
Ctrl+Enter to execute code has the potential to erroneously launch describe window. QCM 28233.
Triple-Clicks should be highlighting entire lines in both SE and PE windows. QCM 23502.
Find and replace tool replacing partial even with "Whole words" option. QCM 28439.
Highlighting then using Find/Replace text gets truncated. QCM 28285.
ER to have r-click "close all other tabs" option. QCM 29040.
High CPU usage when Toad is idle and nothing loaded in editor pane. QCM 29100.
"Key Assignments" reset when opening Editor Options window. QCM 23285.
General Options -> Word Wrap Lines causes last line of selection not to print. QCM 24660.
Highlighting -> Left Margin Background Color not saved between toad sessions. QCM 24015.
Key Assignment -> Misc -> Indent not working. QCM 25946.
Key Assignment Change not displayed properly. QCM 27912.
Key Assignments -> Misc -> Indent/Unident block text not obeying key assignments. QCM 25326.
Key assignments loaded from custom file are not persistent between toad sessions. QCM 23899.
Using Alias for INNER JOINs can cause the column popup not to work. QCM 27863.
Autotrace returns all zeros in 10.2.0.2 server version. QCM 29752.
Columns in data grid disappear when using fix current column. QCM 28880.
Error when viewing data of type BINARY_FLOAT. QCM 29934.
Include ability to retain size/position of the "set parameters" dialog. QCM 29938
Dropdown picklist is empty after 2 or more UNION statements. QCM 30247.
ER to add more columns to Toad's Explain Plan table. QCM 29020.
Error ORA-00936 when running plan on query with sub variable. QCM 29870.
Sizing Load Object window to hide object list makes list disappear permanently. QCM 30060.
Add ability to display PLSQL Table results to DBMS Output. QCM 30116.
Cancel long query hangs Toad when run as script on 10.1 db. QCM 29665.
ER to have script engine display ref cursors as SQL*Plus does. QCM 29039.
ER not to insert line feeds when 'set serveroutput on' is used. QCM 29800.
Scientific notation gives wrong value with very small negative numbers. QCM 30200.
Editor font is always going back to default (courier new 10) when a new connection is made. QCM 28132.
Reload Files Option not being saved. QCM 28147.
"Cannot convert type" when filtering BLOB columns. QCM 27339.
Non-functional if another modeler is open and has run a query. QCM 27423.
Files do not get overwritten on Secure FTP xfer. QCM 29245.
DoubleClick on server file only works if file already exists in client folder. QCM 27971.
FTP not recognizing certain file structure in Sun OS. QCM 28181.
Local file timestamp shown in GMT. QCM 27272.
Remote System directory dropdown non-functional. QCM 27959.
Sort on "Modified" is not working. QCM 24287.
File -> Load in SQL Editor disabled. QCM 27495.
Connect query to determine Oracle version stumbles when "," is on Oracle version string. QCM 27341.
Exception Eureka Log when saving to non-existent directory. QCM 27208.
Opening file with breakpoints opens 'extra' tab(s) and on close causes multiple AVs. QCM 27960.
'Table name starts with' is reading value from 'Column name starts with' control. QCM 27296.
Doesn't work when a filter is placed in the 'View Name' and 'Column Name'. QCM 27412.
Storage clause missing in Generate Schema Script output. QCM 28529.
View DDL Script option not honored when running via Command-Line. QCM 27410.
Two clicks required to advance past step 7. QCM 22911.
Add log file functionality. QCM 24260.
Can't focus a disabled or invisible window. QCM 27450.
Can't focus a disabled or invisible window, Toad crashes - to map cols on data sheet2. QCM 27449.
Data duplicated on LONG column import. QCM 27350.
'Don't Commit' not being honored - data is being committed. QCM 27659.
Import fails on MS Access db table that has table with '/' in name. QCM 27264.
Mappings dialog screen, mouse focus doesn't remain, and the scrollbar moves when it shouldn't. QCM 27381.
Triggers getting schema name appended twice. QCM 27293.
Triggers load from user_triggers vs dba_triggers regardless of check access to DBA option. QCM 27087.
Toad removing backslash when building a dictionary file. QCM 29892.
Java has extra '+' added to make code statements. QCM 27556.
Detail set 5 - not able to scroll through records. QCM 27805.
Repeatable AV in Master Detail Browser. QCM 29947.
Toad crashes with customer toad.ini. QCM 27594.
Changing session highlights wrong editor tab. QCM 28966.
Main Toolbar Explain Plan button not obeying View->Options->Oracle Explain Plan settings. QCM 24955.
Executing MOP script after viewing SQL selects the wrong object. QCM 30225.
Changing font colors is not being saved. QCM 28743.
Logging into db with account about to expire will not let you actually login. QCM 21050.
Quoted user connections appear twice in connection history list. QCM 27569.
"Invalid Variant Type" when querying table containing type which contains dates. QCM 23343.
Trigger Source doesn't work on 8i (and probably 8 and 7) databases. QCM 27409.
SQL Editor -> SQL Recall page has the F1 lookup disabled. QCM 27219.
Selecting commit/rollback as the result of a search actually changes option. QCM 28873.
No support for parallel_enabled parameters. QCM 27280.
No ref cursor results and high CPU usage. QCM 28193.
Formatter does not insert newline between spec and body if loaded from db. QCM 28035.
Navigator panel tree not expanding when proc or func selected on RHS. QCM 28496.
Odd scrolling behavior in nav panel with CTRL+PgUp and CTRL+PgDn. QCM 29292.
Add a "change sessions" button. QCM 20921.
PLS-00201: identifier 'TOAD.TOAD_PROFILER' must be declared. QCM 27218.
Timestamp column being sorted as string, and not as Date. QCM 24181.
SYS_REFCURSOR variable is being pre-pended with PKG_SYS_REFCURSOR. QCM 26068.
Add/Split partition is double quoting timestamp values instead of single quoting. QCM 27301.
Column Total does not work from SB -> Tables -> Data. QCM 22852.
Incorrect tracing in debugger when object created with title on two lines. QCM 28728.
Context menu (F10) in PE has no hot key ability as it does in SE. QCM 28691.
File Splitting combined with Format Code of Package spec & body creates nonvalid file. QCM 22955.
General AVs in proc editor. QCM 28595.
If multiple connections open, execution of object in 2...n connection will occur in 1st connection. QCM 27344.
Procedure Editor doesn't remember cursor position. QCM 21771.
Double-click in Object Palette retrieves object in incorrect position in the editor. QCM 26969.
Table Multi-select -> Create script doesn't grab multiple tables. QCM 27904.
Query Viewer shows only minutes for queries running longer than an hour. QCM 29294.
Floating point error when sorting by Execution Time. QCM 28006.
SQL Truncated when copied or sent back to SQL Editor. QCM 27270.
Can't create a queue table if no DBA Module. QCM 27578.
Select Grant missing from Role Script. QCM 27282.
Copy table data dialog shows wrong schema in status bar when truncating. QCM 28793.
Spaces in CHAR datatype do not copy correctly. QCM 28990.
Help file for applying table filters in SB does not mention that table names need to be in quotes. QCM 28036.
Sort column on RHS does not retain correct column after refresh. QCM 28354.
Creating table script with not null constraints option. QCM 28344.
Incorrect bitmap index DDL created within table script. QCM 29545.
"Reset Original Column Order" does not work on Tables>Columns tab. QCM 29755.
Columns disappear in single record view if rownum is made visible. QCM 28240.
Toad hangs when viewing column of type XMLTYPE for certain table. QCM 29008.
Script tab yielding error when partitioned by range, subpartitioned by hash. QCM 28664.
Toad hangs when viewing table/partitions tab that has >=2000 partitions. QCM 28219.
Columns no longer show in RHS panel, constraints tab. QCM 28034.
DBLink to a DB2 database sends query request multiple times. QCM 28874.
CLOB/BLOB datatype not returning value in "load grid from memory". QCM 29924.
Stored procedure that returns a ref cursor throws error message. QCM 28203.
RHS code tab not refreshing properly if displaying scrollable proc. QCM 28197.
AQ Queue Tables show 0, 0 as the Primary / Secondary instance. QCM 28555.
CPU spikes at 100% when viewing user-defined type in queue table. QCM 29082.
The Grants tab in Schema browser is not listing the same users/roles as the Privileges popup. QCM 28477.
Script generation for a partitioned materialized view is missing partition clause. QCM 28174.
When selecting different synonyms from the list in Schema Browser the right hand pane does not refresh. QCM 28500.
Table name in foreign key reference not in double quotes if table created with double quotes. QCM 28554.
Database "Object Types" disappear from Schema Browser tree. QCM 28830.
OS Authenticated user on 9i db gets AV on reconnect. QCM 28288.
RHS Columns tab, print table output is badly misaligned. QCM 28038.
Script options are saved even if Cancel button is clicked. QCM 28697.
Deselecting columns in SGA Trace, RHS does nothing. QCM 28296.
Does not print model from File|Print. QCM 29788.
"List Index out of Bounds" error on open when tables joined by ROWID. QCM 28067.
Distinct property not being saved on reopen. QCM 28988.
A dml-file created with Toad 8.6 is not correctly reloaded in Toad 9.0. QCM 30724.
Modeled queries return no data when running multiple SQL Modeler sessions. QCM 28209.
When modeling an update query while using a subquery, the parent query changes. QCM 28208.
Doesn't import SQL statements from older versions (7.2?) properly. QCM 27987.
Replace Named SQL creates two entires of the same name. QCM 27645.
After script execution, focus should be on either SE or the Output tab. QCM 27300.
Execute via SQL*Plus with 8.0.6 client - directory name isn't getting parsed correctly. QCM 27382.
Not recognizing strings (highlighting) correctly. QCM 21923.
SHIFT + [left_arrow] fails to highlight first char before EOL when click beyond EOL is enabled. QCM 19776.
Valid SQL appearing as comments. QCM 19781.
Won't highlight strings on multiple lines. QCM 28522.
CPU spikes 100% for Read-Only Toad. QCM 27292.
Error when running .sql script with pathname > 79 characters in SQL*Plus. QCM 28675.
Exporting null date value to flat file results in a "0" instead of blank. QCM 28033.
Formatting not saved when loading file in Script Manager. QCM 28462.
General QCM entry for AV errors when launching SQL Tuner. QCM 28600.
Getting 'invalid character' when running large script. QCM 28305.
Nasty Cascade AV on CNTRL+F4 to close multiple SE windows. QCM 27269.
Persistent AVs when closing and reopening data grid in second SE window. QCM 28632.
Saving named SQL to an existing name, then deconfirming, overwrites anyway. QCM 28703.
Unable to launch SQL Tuner using OS Authentication. QCM 28229.
F4 does not pull data from correct schema. QCM 28493.
When importing data from Excel to a table, the Key word NULL is not recognized. QCM 28042.
Window Cascade on SE causes splitter to disappear in SE. QCM 24270.
Window label not indicating file is open after f9 on single file statement. QCM 23746.
Common complaint regarding out-of-control scrolling in editor. QCM 29053.
Right-click editing options now buried in a submenu. QCM 28092.
Execute as script (F5) tabs are being converted to spaces. QCM 28213.
Customize -> Add icon to toolbar. Open new SE -> Customization not present. QCM 25971.
Open File - .SQL File association not working on toad startup. QCM 27349.
Cannot load SQL Editor query into SQL Modeler. QCM 28031.
Values in global WHERE being converted to uppercase. QCM 29867.
Certain date format not recognized when loading data. QCM 28752.
Clone Cursor truncates date/time data. QCM 27226.
Incorrect data generated in XLS sheet. QCM 27860.
Incorrect date when using Save As XLS File and year is 1900. QCM 29031.
SQL*Loader option not playing nice with Timestamp data
Save As XML (plain) results in error if data grid contains smart quotes. QCM 28657.
XLS Instance takes out the leading 0's in the data. QCM 27285.
XLS slower than what it was in 8.5. QCM 27284.
Compare with another object (trigger) not querying DBA views even though they are accessible. QCM 27029.
Detail info disappears if you close any secondary DB connection. QCM 27599.
Dimension script incorrect. QCM 29551.
Toad does not allow the backslash "\" symbol inside a schema name. QCM 28216.
View/Edit privileges has lost some functionality in 8.6. QCM 29923.
Inconsistency between loading a script into the editor from LHS and RHS. QCM 29026.
Package body not showing on RHS when package name highlighted in tree view mode. QCM 28093.
SB title bar displays wrong schema. QCM 29932.
ORA-24801: illegal parameter value in OCI lob function when querying EMPTY_LOB. QCM 27644.
Ctrl+c does not work. Have to mouse -> copy to copy the text. QCM 27737.
Home editor entries turn red if the Windows PATH variable has a terminating "\". QCM 28725.
Login dialog not remembering its column grouping scheme on restart. QCM 28112.
Passwords are not being saved the first time Toad is loaded and "saved passwords" is checked. QCM 28243.
Black connection color does not show black bar in lower RHS. QCM 28265.
Number of sessions incorrect on graph. QCM 26864.
"Go to session" from locks display can select wrong session. QCM 28267.
AUDSID reported incorrectly for sessions on RAC instance. QCM 27666.
After Reconnect, refresh no longer works. QCM 27554.
Can't kill a connection on a RAC database across instances. QCM 26985.
Explain Plan not available for some sessions when "Use a separate connection..." enabled. QCM 24541.
Long Ops tab, completion bar doesn't always reflect % displayed. QCM 27404.
Sessions disappear when connection re-established via Test (Reconnect). QCM 26372.
Waits Tab -> Total_Waits doing a character sort with customer's Toad.ini file. QCM 27422.
Synch script creates two constraints to handle named not null constraint. QCM 27399.
"A call to an OS function failed" on table with CRLF in data. QCM 27236.
Last Column not shown if Rownum and ROWID selected. QCM 27515.
Snapshot log script has erroneous comma after "sequence" when adding a column. QCM 28974.
ORA-00955 when running script - happens with long snapshot names. QCM 27705.
Synonyms excluded. QCM 27672.
AV if click on a snapshot that no longer exists. QCM 27598.
PRIMARY KEY not noted on Status info. QCM 27337.
Create or Replace Type Body fails to show compilation errors. QCM 22390.
Execution time displayed often incorrect. QCM 27403.
Holding F9 causes Toad to shut down. QCM 26902.
Invalid Blob - ORA-22275. QCM 27457.
Query should fail with ORA-01422 and ORA-06512. QCM 26607.
Valid SQL not working as expected in TOAD. QCM 19308.
User would like to be able to designate the default Input Files path in TKProf Wizard. QCM 28699.
Error when deleting unused TNS entries from connection dialog. QCM 28524.
When opening very large tnsnames files in TNS Editor, other potential users are locked out. QCM 28223.
AV when switching between windows, at address 41444D45. QCM 27288.
Dual Monitor issue, toad not visible when switching to single monitor. QCM 27388.
Compare with another object - ORA00942 on 7.3.4 and 8.0.6 instances. QCM 26182.
Rebuild - Toad loops when trying to rebuild table previously rebuilt. QCM 27560.
Gets stuck in loop and hangs Toad. QCM 27687.
Compile Invalid Objects is compiling for LoginUser schema, not selected schema. QCM 24461.
Save to File prepends schema name even if option is off. QCM 27869.
Triggers source is displaying source for ALL triggers, not just ones for the table. QCM 27525.
Unix Monitor disconnects when SGA=>10GB. QCM 28134.
DDL Script for user leaves no space between user name and 'REVOKE' for unlimited tablespace. QCM 27281.
Users not being populated when switching from Roles tab. QCM 27558.
Doesn't show MAX MB for temp tablespaces correctly. QCM 27580.
Script Tab doesn't support column level constraints. QCM 25884.
'Undeclared Identifier' for watch on variable that has procedure prefixed to var name. QCM 27411.
Window will only remember MAXIMIZED if AUTO-OPEN enabled. QCM 23605.
Format XML is converting processing instructions in an XMLTYPE object into elements. QCM 27587.
Unable to use mouse scroller anywhere in Toad if eBiz Monitor open. QCM 28836.
Trial version hangs when using eBiz feature. QCM 28832.
Base Toad
New window added which offers the right-click actions of the Schema Browser in the following locations: Object Palette, Object Search results grid, Schema Browser and Editor data grids if you a cell contains a database object and the Editor Navigator Panel.
Now runs commands in a threads so as not to lock-up TOAD during execution.
New "MINIMIZE=YES" flag added to make TOAD minimized during command line operations.
A 'Start' button has been added to the toolbar, to take the user back to the first panel. Also, if the word "Where" is not specified in the conditions, the window will add it automatically.
Added 2 options: Exclude byte/char & Exclude column length, precision, scale
Creation of foreign keys now appear at the end of the sync script.
Interactive tab now breaks constraints out by constraint type.
New option added to format PL/SQL before displaying differences.
Policies and Policy Groups can now be compared.
Support added for copying Timestamp, Interval and Raw data in arrays, improving processing. No support for copying REF columns at this time.
"Rollback" button added to Schema Browser data grids. This new button is located next to the commit button and only rolls back data posted in the current data grid.
Added the ability to hide unwanted columns by dragging a column header to a place where the icon turns into a circle with a slash.
Refresh button will now be enabled when the dataset is read only.
Sort/Filter conditions may now be named and saved for future use by the user. Also, the operators 'IN' and 'NOT IN' operators have been added to the list and a new look up column values button has also been added. When 'IN' or 'NOT IN' are selected as an operator, the value lookup dialog will be multi-select enabled. If the user selects date, timestamp, or interval data types, a TO_DATE, TO_TIMESTAMP, or TO_INTERVAL expression will be built.
When printing results grids, the print dialog will now display the query and an option to print the query either before or after the grid print.
Query improvements made when 100% of the data is to be copied
A new Editor Component is now being used. New features include block Select, triple click line select, code folding, and highly customizable languages.
New R-click option added for tabs, "Close all other tabs" will close all non-active tabs in your current Editor.
SQL Editor, Procedure Editor, and Text Editor have been merged into a single Editor. The new Editor features context sensitive execution (F9 Key, or green arrow button). The new execution routine can identify the statement at your caret and perform the correct execution action when a single Editor tab contains heterogeneous statements. PL/SQL can also be compiled directly from the Editor's navigator panel via the Right-click menu. Script Execution is still available in the new editor as well as 3 debuggers (PL/SQL, JDWP, and Script). Only 1 debugger may be used at a time, use the "debug" main menu to switch between debuggers. "Execute Statement at cursor" is still available via Shift+F9, Ctrl+Enter, and the button may be added back to the toolbar using customizable toolbars. The new Editor now has 5 different "Tab Styles" that are used depending on what you are doing in the Editor. For example, if "XML" tab is selected, the tab will be in XML editor mode using the HTML parser and an XML tree will appear. Tab styles are also associated with a Desktop layout and file extensions. Editor desktop layouts are now used on a per-tab basis by default. To view "Tab Styles", R-click In the editor and choose "Configure Editor tab styles" or select from the new tab dropdown button. Depending on which style of tab is selected in the SQL Editor, the associated desktop will be used. Tab styles are configurable and can be unassociated with desktops if desired.Object Status panel added. The Status panel appears below the navigator and is context sensitive. Database object information is updated depending on your caret position. The Editor can be used off-line if a connection has not been established in Toad.
Save desktops button in Editor toolbar now includes a dropdown with "Revert to last saved desktop" and "Restore default desktop" options.
Text-backup feature added. If enabled, Toad will automatically create backups of editor text using
temporary file names in the User Files folder. If Toad shuts down abnormally, then you will be prompted
to recover or discard backups. There is also a menu item to recover documents off of the "File" menu.
There are options to turn this on and off and control the backup interval (Options > Editor > Behavior).
The Error panel from Toad version 8.5 and previous versions has been restored. Errors will no longer
appear in an "Errors" sub-tab. Instead, they will appear in the Editor itself.
"Merged" toolbar added. This is now the default editor toolbar and can be toggled on/off via R-click
on the toolbar. The merged bar gives you a 2 row single bar that doesn't include spacers. It gives you
the appearance and feel of a single, static toolbar.
New right-click menu item Desktop > Configure Desktop. Allows the user to select multiple desktop
panels for inclusion/exclusion at the same time. Also allows the user to assign individual panel
locations.
Option added to Options > Editor > Behavior: "Use a single editor instance for PL/SQL if possible".
This option tells Toad to use an instance of the editor that already contains PL/SQL when loading PL/SQL
into the Editor from another source. If an instance of the Editor containing PL/SQL source is not found,
then a new Editor instance is created.
Functionality added to Import/Export the indexes listed, including checked status and user-defined row counts.
Functionality added to Import/Export the tables listed, including checked status and user-defined row counts. Also, when estimating index size from the selected tables, the table row counts are carried over.
Drag/Drop support added for valid XML explain plan files. You can drag from Windows Explorer to any explain plan in Toad.
New Explain plan comparison window can be accessed via R-click from explain plans. Plans can be compared across databases and loaded from file. Results are displayed in a graphical mode, or text compare mode.
The explain plan tree has been replaced with the one used in the SQL Tuner module. The new explain plan allows for various visual styles, customization, and the ability to load and save plans as xml files.
When "Save previous Explain plan" is checked in options > Oracle > general, and the table TOAD_PLAN_SQL (Toad server-side object that holds previous explain plan results) is not found, a dialog will ask you if you want to create it and create it for you.
When an explain plan is not found (Options > General > Oracle > Explain plan), a dialog now asks you to select an existing plan table or create a new one.
Toad Data Modeler added to "Auto add" function.
Improved performance when sorting server objects by Name, Date or Size.
Search engine is now faster and regular expression support has been significantly improved.
New field added to specify the space between fields.
Report printing and exporting from command line is now available. You can also specify parameters, in your query when you run reports from the command line.
Support has been added for report printing or exporting from the command line.
New Health Check Item - "Foreign Keys w/o matching index on child table"
A new dropdown box has been added to the main data importer screen: "Action". You can now select to just create the insert statements, rather than inserting the data into the table.
Added option for text files: "Trim spaces". Choices are None, Left, Right, or Both.
On Detail windows, the '...' button to define the detail dataset has been changed to a button with an icon. If "Other" is selected as the dataset type (i.e., not "Table(FK)"), then the button will have a drop-down with a "Reverse Foreign Keys..." menu item. This will allow the user to define the Master-Detail relationship by going through a foreign key "in reverse".
New option added in Data Grids > Visual: "Keep Focused Column in view". This option allows the focus to change to other cells as you scroll horizontally and prevent "jumping" back to the focused column.
Options > Files > General tab, the two sets of filters/extensions have been merged into one. Changes are now live (before you had to reboot).
New 'Object loading' option for including schema name with PL/SQL code. The user now can choose to never include, always include or only include schema name on load from other schemas.
Options > Files > Open/Save Dialogs: "Favorite Folders" list added. Folders added to this list will appear in all of Toad's open and save dialogs in the "Favorites" dropdown box. Favorites can be added, edited, deleted, and reordered from the options window. Favorite folders can also be added directly from the open/save dialogs throughout Toad.
Background color and font settings for both sides of the Schema Browser can now be individually defined in the Options window. Note: RHS script tabs will still have colonization controlled by editor highlighting options.
"Menu shortcuts" has been moved to the main options screen as a child node of the Toolbars/Menus options. These options were previously only available via the main Toad toolbar's popup menu.
An option has been added for setting the Compile Optimization Level on 10g databases. The default value for the option (View > Options > Procedure Editor > General > Set optimizing compiler value) level is 2, for the most aggressive, maximum possible code transformations, and biggest impact on compile time. Optimize level 1 has less of an impact on compile times and level 0 compiles PL/SQL code without any optimization.
"Add to Project Manager" check boxes have been added to most object create windows.
New "Note" property added to all DB object nodes, which can configured as a hint in the PM options. Also "Default folder path" property added to project nodes, for use as the default when folder nodes are created under a project node.
Scrolling through connection list (now a tab) changes active connection.
Now able to send a SQL statement from the editor to the SQL Modeler by right clicking.
Reverse Engineering: Build a model in the SQL Modeler based on a query.
The SQL Modeler has been renamed as Query Builder, to better reflect the existing functionality as well as new enhancements added for this newest version of Toad.
Two new buttons added to the Query Builder windows. An 'Execute SQL*Plus Report' button has been added to the Generated Statement tab to surface the existing r0ght-click menu functionality. Also, a 'Send to Editor' button has been added to the SQ*Plus Report window.
'Copy SQL' command now includes all of the SQL data. Previously limited to the first 255 characters.
New window: "Reports Manager" replaces the old "Toad Reports" (view > Reports) and "eBiz Reports" (eBiz > Reports). All of the old reports from Toad Reports have been recreated using the "Fast Reports" Reporting engine. Now called "Sample Reports", you can import a sample set of reports into the new Reports Manager which contain the same information as the old Toad Reports. The new Reports engine is more powerful and feature-rich. You can now create, copy, print, categorize, and modify reports among other things.
Added "Include Grants" checkbox in the Schema Browser Scripts tab. This option affects the scripts tab and the "create script" function on the left side of the Schema Browser
New Schema Browser tab: Contexts. Includes Info tab, Script tab, and Create/Alter windows.
All data filters for a connection are now stored in a single XML file (User Files\*_tablefilters.xml)All data filters for a connection are now stored in a single XML file (User Files\*_tablefilters.xml) Additionally, a "Filter Name" edit box has been added to the dialog for saving conditions indefinitely. A drop-down has also been added to the filter button, for easy access to the named sort/filter conditions.
If the table or Materialized View is partitioned, a "Partitions" dropdown will appear on the filter dialog.
Domain Indexes now display an extra panel in the RHS columns tab: "Domain-Related Tables and Indexes". F4 and Shift+F4 work from this new object list.
New "Invalid Objects" tab added to the Schema Browser. This new tab also includes unusable indexes (or indexes with an unusable partition or subpartition).
Create Script: Check boxes added to specify export of package specs only, bodies only, or both.
"Last Refresh Date" added to right hand side info tab.
Saving script to file now obeys the UNIX format option set in Options > Files.
"Rename column" button added - disabled for pre 9iR2 databases.
New panel added to quickly locate a constraint by column name.
"Read Only" checkbox added above the data grid
Referential information is now displayed in columns, which allows for sorting within the tree hierarchy and incremental searches. The new column layout also allows for columns to be enabled or disabled by right-clicking on the column header, reordered and have column visibility, widths, and order remembered. Additionally, the tab now supports print or copy to clipboard and viewing the constraints in "compact mode" to show minimal info in one column.
Button added for 9i and newer to rename your trigger
Drop Datafile button on files tab. Only for 10gR2 or newer.
"Compile Invalid" r-click item has been added to the Triggers tab.
Oracle's V$SQL_PLAN is now used for the explain plan in this window for 9i + database versions if found.
The "Use RAC Views" checkbox has been replaced with a drop-down labeled "Instance". The user can now view and individual RAC instance or all RAC instances simultaneously. The drop-down defaults to the current instance, which is the equivalent of having the old checkbox unchecked. The bottom choice "ALL" is the equivalent of having the old checkbox checked.
New option "Specify Fields" which allows the user to create fields and map them to columns.
"Launch after export" option is now available for command line execution.
Added an option to quote column names
Added options to not quote string columns, single quote string columns, or double quote string columns.
GUI redesigned
New option added for exporting to XLS Instance "Start with Active Cell". If checked, this option will make the exported data start with (i.e., top left corner will be) the active cell in excel. If unchecked, the data will start in cell A1.
New option added to XLS file format: "Paper Size" passes in the selected paper size for page setup options in excel.
"Favorites" have been added to the tree view style Schema Browser.
F12 toggles the right side of the Schema Browser on and off. While the right side of the Schema Browser is off, extra queries will not be run.
New button added to filter Schema Browser object lists by Project Manager file and project name.
Right hand side tabs are now customizable: reorder, rename, and hide.
Right click - Send to CodeXpert for procedures, functions, triggers, packages and views.
Right click menus added to tables, views, snapshots: import data from text, excel, or access.
Support added for displaying more complex Oracle datatypes, including CLOB, BLOB, BFILE and LONG.
Support added for printing Ref Cursor bind variables, including Ref Cursors with embedded Cursor results.
"Auto-size data" button added to toolbar and column widths are now preserved.
"Remove" item added to popup menu.
Datafile defaults added. This allows you to associate Toad connections with datafiles. Datafile defaults can be used by opening the "connections to execute against" dropdown and selecting "Set to datafile defaults". Selecting this will check all those connections which were stored in the "Default execution connections" section in the Script Manager options.
New option added to associate output files or output directories with datafiles.
Now has the ability to run scripts against any of your databases, not just those you're currently connected to. An "Inactive" connection list flyout menu has been added to the "Connections to execute against" dropdown.
3 Tabs added to server login window to support different methods of connecting to your database. The "TNS" tab contains the "Database" dropdown seen in previous versions of Toad. This tab is used to connect via TNS Names or using "Easy Connect" strings (host:port\service_name). The "Direct" tab is used to directly connect to databases by using the host, port, and service_name. Use the "LDAP" tab if connecting via an LDAP Server. The "LDAP Descriptor" dropdown will be populated with services from your LDAP server. There are some Oracle issues in resolving the LDAP entries if the instant client is in the user's system path.
Custom connection colors are now available.
LDAP Editor is now available from the Server Login window. The LDAP Editor is similar to the SQLNet.ora Editor and allows you to manage how Toad connects using LDAP.
SQLNet Editor has been rearranged and now supports more parameters.
New 'Group by' option added "Program (no path)" which strips the full filename from the Program cell if applicable.
Oracle's V$SQL_PLAN is now used for the explain plan in this window for 9i + database versions if found.
Selecting the 'Group by' button now displays the dropdown menu.
New QSR button added for executing procedures, functions and packages. Instead of processing the object in the background or in the Editor, this button will launch QSR and run the object there. The QSR button will be disabled if the Set Parameter Output Options including loading Ref Cursor results from memory.
New option added: "Left align column names" found in Data Grids > Data
Print button added
Improved performance when opening the alter table window for a table with hundreds of columns.
New button added to columns tab "Create Cols form File". This function reads column names out of the first row of an excel, delimited text, or MS Access table file.
Compatibility with Visual SourceSafe 2005 verified.
"Send to Editor" buttons added to all create/alter "Show SQL" popups.
Application Change: You can now set a different directory from which to load your user files (default is \user files). Options > General > User Files Directory.
Saved Oracle passwords now reside in a separate file (connectionpwds.ini). The new file is completely encrypted and is tied to the volume on which it resides. If the new passwords file fails encryption, then Toad is loaded without saved passwords and file is overwritten.
The following windows (some DBA and some non-DBA) now have a checkbox to switch between RAC views and regular V$ views: Database Probe, Database Monitor, Session Browser, SGA Trace, and Top Session Finder.
Toad will now be able to identify and connect with 32 bit Oracle clients when installed on 64 bit Windows XP Server and 64 bit Windows 2003 Server. 64 bit Oracle clients will not be displayed in the server login window.
New window under the help menu. This window offers Warnings, Alerts, Hints, and Performance suggestions concerning the current state of your Toad installation. This is a self-diagnosis window and should be checked on occasion when having difficulties with Toad you can't iron out.
New connection button on Toad's main toolbar has been supplemented with "New/End" connection combo, which are also "quick connect/disconnect" buttons showing top active sessions (for connecting) and active sessions (for disconnecting)
2 options added to Options > Toolbars section: "Multi-line Window/Connection Bar"
Customization screen now displays 3 new categories in the "Commands" tab. The [All] category displays all items. The [New] category will show all new items after Toad is upgraded starting with 9.0. The [Removed] category displays all items that have been removed from the menus and/or toolbars
F4 describe functionality has been added to the tablespaces dropdown boxes in the "Tablespaces" tab and also the "Roles" tab.
Proxies tab added to create and alter user screens.
Added "Include Grants" checkbox in the Schema Browser Scripts tab. This option affects the scripts tab and the "create script" function on the left side of the Schema Browser
Proxies clause is now included in the User scripts.
Resource Group privileges are now included.
The 'Files' has been modified to improve performance on databases with many tablespaces.
Enhancements in the Debugger
Added standalone CodeXpert window.
Added the ability to run CodeXpert from the command line. The results tree of the CodeXpert analysis is exported to an HTML file with the code itself. This HTML page is dynamic and behaves similar to the results tree in the CodeXpert window and supports Firefox browser in addition to Internet Explorer. A parameter file can be created directly from the CodeXpert window via the R-click menu > "Create Command line parameter file" (this method encrypts Oracle passwords) or may be created programmatically without using password encryption.
Added the ability to save CodeXpert run data to database for PL/SQL objects. Server side objects for this functionality is setup via Toad's Server Side Object Wizard. Reports have been added to Toad's Reports Manager to make sense of the saved run data.
Debugger timeout maximum increased from 999 to 9999.
Functionality added to auto-resolve watches on Package variables. If the variable to be watched is declared in the Package Spec or in the Body outside of a sub procedure, the Schema and Package fields will be populated for the current Package. The user will still have the ability to Edit the watch for externally defined package variables.
Functionality re-enabled for debugging multiple PL/SQL objects within a single Editor tab. This is most applicable to debugging packages, but can also be applied to PL/SQL script objects.
JDWP debugger option for Oracle versions 9.2 and greater added. In addition to supporting PL/SQL debugging, this option allows for: Creating Java source in the Procedure Editor, Stepping into Java code, Setting breakpoints in Java code, and Watching values of Java variables. Does not support Just-in-Time Debugging for this release.
Just-in-Time debugging no longer requires the user to set a breakpoint before debug. Attaching to the external Session now functions like a Trace Into, automatically stopping at the first executable line.
Modify watch values has been disabled for JDWP debugging, due to conflicts between OCI and the JDWP interface.
Support added for returning Collection type Out Parameters and Return Values. The option to enable this has been combined with the existing Print Ref Cursor to DBMS Output support.
There are 3 debuggers available in Toad 9.0: DBMS (Probe), JDWP and Script. Each debugger is a single global option within Toad, which will span all active Toad sessions. A specific debugger can be selected in 'Toad Options... > Editor > Open/Save' or from the Debug menu.
Ability added for watches to persist across sessions. This functionality is similar to how breakpoints are stored.
DBA Module Enhancements
The ADDM and AWR reports have been combined into the first tab. Additionally, the user can now copy Snapshot ranges from one report to another and Instance ID and start/end Snapshot edit boxes will now remember their last values, on a per-connection basis.
New DBA Module window added DBA menu. This wizard is an interface to the DBMS_REDEFINITION Oracle supplied package that lets you rebuild tables online. Toad only supports DBMS Redefinitions through this wizard on Oracle 10g and 10gR2.
Added ability to export chart data to Excel/HTML (Bitmap was already present)
Control added to select the amount of data to display in the grids. The user may elect to display data for the past hour, 2 hours, 6 hours, 12 hours, day or two days.
When connected to RAC, the user can now choose which instance to monitor. Also, the toolbar has been cleaned up a bit with the miscellaneous controls having been moved to an options dialog.
Runs entirely in background now.
When connected to RAC, the user can now choose which instance to probe.
Window is now non-modal and stays open after export is complete.
"Format Code" checkbox added for Functions, Procedures, and Packages in Script options > Other objects section.
Use Relative path in "Build All" script option added. This option creates and extra file called
Check for unanalyzed indexes now excludes lob indexes.
New item: List Redundant Indexes (Indexes with same leading columns)
Window is now non-modal and stays open after import is complete.
Edit window modified for RAC connections, adding the option to apply a parameter change to all instances or just the current instance Also, a quick filter, similar to that in the Schema Browser, has been added to the main toolbar.
GUI has been rewritten as an MDI form with the data presented in a Master/Detail arrangement. Functionally is unchanged but function commands are now on the toolbars.
Policies tab added to right panel
Data files can now be dropped via the "Alter Tablespace" window for Oracle 10gR2 instances.
The "Use RAC Views" checkbox has been replaced with a drop-down labeled "Instance". The user can now view and individual RAC instance or all RAC instances simultaneously. The drop-down defaults to the current instance, which is the equivalent of having the old checkbox unchecked. The bottom choice "ALL" is the equivalent of having the old checkbox checked.
Added ability to export chart data to Excel/HTML/Bitmap
Other Changes to Note
Ending a connection was an unstoppable event in previous versions. The connection would always end, regardless of what you selected to the file save prompt or if you had running queries. Now, a session end can be stopped under such circumstances.
Editors, SQL Editor, and Procedure Editor Options within the main Toad options window have all been centralized into a single Options node called "Editor". These options have been re-organized within their new location. "Editor Options" link which previously launched a stand-alone options window has been removed. Now, all Editor and Editing options appear in Toad's main options window. There has been many options relocations and re-arranging, use the options window search function to find the new location of options.
Options > Editors > SQL/Procedure: "Navigator Font" button has been removed. The navigator font can now be set in the navigator itself using the popup menu.
Query Viewer window and Query Viewer Editor sub-tab no longer use refresh. Due to CPU issues, it was redesigned to use a 'push' model instead of a 'pull' model. All threaded queries now automatically post their information directly to the Query Viewer as it occurs.
The former "Procs" tab has been broken out into 3 separate tabs for procedures, functions, and packages.
Default schema has been moved from the "Schema Browser" tab to the "Oracle, General" tab of the options screen.
TNSNames editor/parser has been completely rewritten
When using TQ, the "Commit" and "Rollback" buttons on Toad's main toolbar now only act on the current threaded session, instead of acting on all open threads for the current connection.
| WINDOW | DESCRIPTION | WORKAROUND |
|---|---|---|
| CodeXpert | Saving PL/SQL results to database may fail or save invalid data to database for invalid PL/SQL objects. | To ensure PL/SQL results get saved to database correctly, verify the validity of all objects before CodeXpert is run. |
| CodeXpert | Saving results to DB: When dealing with nested procedures, CodeXpert can only insert run data from procs one level deep. | |
| DBMS Output | DBMS Output doesn't display in the DBMS Output sub tab or the DBMS Output window while debugging or executing pl/sql with debug. | If DBMS Output is enabled in the Editor sub-tab or DBMS Output window, DBMS Output will not show while debugging or executing pl/sql in debug mode unless the following option is checked: View > Options > Debugger > "Enable DBMS Output before debug session" |
| 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". |
| Describe | Viewing XML_TYPE data in the F4 describe window may cause memory leaks. | Try to limit the amount of times the describe window is used to view XML_TYPE data during a given Toad session. Use the Editor or Schema Browser data grid to do the majority of your work with XML data. |
| Editor | "Capitalization Effects" applied from the language parser are not saved to file with the case applied by capitalization effects function. | Type the code in the case desired, do not rely on the lexer to change the case of your code. Configure Toad's formatter (View menu > Formatting options) to change case as desired and format code before saving. |
| 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. |
| 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 |
| 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. |
| Editor | Parameter hints for overloaded packages are no longer scrollable. The parameter hint will be limited to the size of your screen. | |
| Editor | Toad's column dropdown in the Editor (Ctrl+T, or typing a period after a table name) only displays on the primary monitor when using a multi-monitor setup. | |
| 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. |
| Query Builder Reverse Engineering | The Query Builder now supports, for the first time ever, the reverse engineering of queries. SQL Reverse Engineering represents a considerable technological advancement for the Builder. Although it was heavily tested throughout its development lifecycle, due to the vast array of possible queries there may be some queries it can create but cannot reverse. We encourage users to inform Quest if they discover such queries. The main limitations of reverse engineering are that it only supports single-level subqueries in the SELECT and WHERE nodes, and no subqueries in the FROM clause, and some calculated fields that include arithmetic operators might not be reversed correctly. | |
| 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 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 | Installed Script Manager files are not found in Citrix and Client/Server Environments. | Toad installs packaged SQL Scripts with it's
Script Manager. When Toad runs in a Citrix or Client/Server 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 | In RAC databases, version 10.1.0.3 (and possibly
other 10.1 versions), the query used to show the populate the "Current Statement" in the Session Browser
fails with the following error:
Runtime error occurred: 12801 (ORA-12801: error signaled in parallel query server PZ99, instance ORA-01008: not all variables bound) This problem does not occur in Non-RAC environments. Uncheck the "Use RAC Views"
checkbox, and log into the appropriate instance of the database, if necessary. | |
| 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 -Oracle 10gR2 database with Oracle 10gR2 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. |
Windows Removed from Toad
OptionsOptions > General > "Prompt to close windows when closing connections". The behavior now is that all windows associated with a closing connection will close on a connection end. Connection-specific windows are useless and cause errors if they remain open after a connection is closed.
OptionsOptions > Procedure Editor > General: "Search for dependent objects after compile" option has been removed. This option can no longer be supported with multiple object support in the new editor.
OptionsOptions > Parser Scripts section has been removed. You can find similar options here: Options > Editor > Behavior > Languages
Options > EditorsOptions > Editors Options > General > Two "TNSNames Files" options removed: "Reload last used files" and "Backup Files during saves". The window now behaves as if both of these items were checked.
Options > EditorsOptions > Editors > SQL/Procedure: "Variable Prefixes" section has been removed. This option was for sending text between the SE and PE and nothing else. With one editor that option is no longer needed.
ReportsToad Reports have been removed. All of the reports previously available from this window have been recreated in Toad's new "Report Manager" (View menu). 3 previously available reports were not recreated because of redundancy. These reports include "Stand Alone Stored Arguments", "Arguments of stand alone stored programs", and "Stored objects with source"
eBiz ModuleeBiz > Reports menu item has been removed. The same reports can now be found in the Reports Manager for eBiz module users (View > Reports Manager)
Before installing Toad for Oracle, ensure your system meets the following minimum hardware and software requirements:
Hardware
Software
This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.
This release supports any single-byte character set. Double-byte or multi-byte character sets are not supported. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.
This release has the following known capabilities or limitations: Updating multi-byte or bidirectional character data, exporting multi-byte character data to excel. Visual display in some grids/views.
| info@quest.com | |
| Quest Software, Inc. World Headquarters 5 Polaris Way Aliso Viejo, CA 92656 USA |
|
| Web |
Refer to our Web site for regional and international office information.
Quest Support is available to customers who have a trial version of a Quest product or who have purchased a commercial version and have a valid maintenance contract.
Quest Support provides around the clock coverage with SupportLink, our web self-service. Visit SupportLink at http://support.quest.com.
From SupportLink, you can do the following:
View the Global Support Guide for a detailed explanation of support programs, online services, contact information, and policy and procedures.
The guide is available at: http://support.quest.com/pdfs/Global Support Guide.pdf
| Number of Bugs Fixed | 337 |
| Number of Enhancements | 151 |
| Number of Known Issues | 45 |
This document contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software, Inc.
© 2006 Quest Software, Inc. ALL RIGHTS RESERVED.
Quest, Quest Software, the Quest Software logo, Aelita, AppAssure, Benchmark Factory, Big Brother, DataFactory, DeployDirector, ERDisk, Fastlane, Final, Foglight, Funnel Web, I/Watch, Imceda, InLook, IntelliProfile, Internet Weather Report, InTrust, IT Dad, JClass, Jint, JProbe, Knowledge Xpert, LeccoTech, LiteSpeed, LiveReorg, Matrix Insight, Matrix.Net, MIQ, NBSpool, NetBase, Npulse, PerformaSure, PL/Vision, Quest Central, RAPS, SharePlex, Sitraka, SmartAlarm, Speed Change Manager, Speed Coefficient, Spotlight, SQL Firewall, SQL Impact, SQL LiteSpeed, SQL Navigator, SQLab, SQLGuardian, SQLProtector, SQL Watch, Stat, Stat!, StealthCollect, Tag and Follow, Toad, T.O.A.D., Vintela, Virtual DBA, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.
If you have any questions regarding your potential use of this material, contact:
|
Quest Software World Headquarters
LEGAL Dept 5 Polaris Way Aliso Viejo, CA 92656 Email: legal@quest.com |
The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.