We are pleased to announce the GA of our new version: Toad for Oracle 16.2.98.1741.
This version of Toad for Oracle Subscription allows for easier installation of bundled products you may be entitled to. Discover Xpert Plus edition which offers all the features and functionality of Toad for Oracle Professional DB Admin plus SQL Optimizer. The Toad for Oracle Base Edition, Toad for Oracle Professional, Toad for Oracle Professional DB Admin, and the fantastic Toad for Oracle Xpert Plus are available for an affordable annual price.
To learn more about these subscription offerings, visit https://www.toadworld.com/products/toad-for-oracle.
For all of our existing customers, Toad for Oracle 16.2.98.1741 contains many new fixes and enhancements. (Many of which have been suggested by our Toad World members—Thank you all!)
For more information on these and other stability and performance improvements, view the release notes at https://support.quest.com/technical-documents/toad-for-oracle/release-notes.
To download this latest release, visit https://support.quest.com/toad-for-oracle/download-new-releases.
To learn more about Toad for Oracle, visit https://www.quest.com/products/toad-for-oracle.
Change Log
Bug Fixes
- Alert Log Viewer: opening files too slowly
- Alter Scheduler Job: Can't alter job with unnamed arguments
- Alter Table: Wrong column affected on the first click into columns grid
- Automation Designer
- AD was allowed to close while actions running, leading to error
- Script action verification messages inaccurate
- Code Snippets: Access violation after editing snippets with auto-hide
- Command line: "-c" overriding the "allow multiple copies of Toad" option (when disabled)
- Compare Multiple Tables: Decimal separator incorrect in sync script
- Connections
- Improved handling of reconnect when opening Schema Browser, Import Table, Data, Describe, Single Object Compare, Database Browser, SGA Trace, Chained Rows
- LDAP not working with 21c client
- Set Role/Transaction feature not working in no-client mode, and also not after auto-reconnect
- Window border colors sometimes disappear
- Create Pluggable Database: TNSNames.ora not found in no-client mode
- Data Generation: Failure when FK field names differ between tables
- Data Grids
- Can't edit VARCHAR2 fields with up/down arrow keys
- Cascade of errors when pasting invalid number
- Data Import: Import from Excel slow when date format differs Options window
- Database Browser: "Import database browser file" non-functional
- DBMS Output: Not returning complete text when output contains multibytes chars
- Describe Objects
- F4 not finding package constants
- Can get stuck in an "Empty" state
- Editor
- "Save As" folder location sometimes incorrect
- Brace highlighting flashing
- Caret placement incorrect when attempting to select a line
- Cursor movement slow when arrow key held down
- Invalid regex replace caused unhandled exception
- Variables dialog sometimes stays on top of other apps
- Whitespace background is black
- Wrong colors after restoring Editor Font and Syling defaults
- Export Dataset
- Access violation when exporting to location where file cannot be saved
- Clipboard changing to "File" if "Excel Instance" selected
- Excel Instance - Excel staying behind Toad after export
- SQL Loader format - can't set string delimiter to null
- Export Dataset: SQL Loader format - Null date fields should not have dbl-quote
- Export DDL
- Materialized views always show as NOLOGGING
- Tablespace script incorrect for encrypted TEMP and UNDO
- File Compare: Access violation when trying to save results
- File Recovery: Connection duplicated if recovered file is an on auto-connect connection
- Formatting/parsing: "Enable/Disable On Query Computation" not handled
- Generate Schema/DB Script, Compare Schema/DB: SOS files now saved as text. Also, files can be specified in parameter files in Automation Designer
- Login Window
- Duplicated entries if connections added manually in lower case
- Selection changes to another group after delete
- Options
- "Find" animation not working when scaling > 100%
- Decimal and Thousand settings not retained
- File associations silently failing
- Jump search graphic not locating target if screen scaling > 100%
- Windows -> Create Table settings getting mixed up with Create Queue Table
- QSR: Connection Error when launched from Toad's Project Manager
- Query Builder
- Fixed bad column sizing
- Join order was inconsistent
- Run Procedure: "Cannot focus disabled or invisible window" error
- Schema Browser
- Create Insert for selected rows - bogus "no data found" message
- Error on Data tab refresh after connection lost
- Filter/Sort dialog adding parens when not needed
- Font size change resulted in wrong spacing between objects <!-- TOR-6358 -- >
- Object Type dropdown's incremental search was clumsy
- Object Types not displayed correctly when Team Coding enabled
- Popup menu for Types can get lost/broken
- Quick Filter selecting item from history when it should not
- Refresh LHS not working for Funcs, Procs, Packages, Types
- Rowselect disabled by default in Columns grid, resulting in drag of columns to Editor not working well
- SQL error when revoking object privs from mixed-case schema
- Tablespace script missing encryption algorithm for Temp/Undo
- Team Coding icons missing for sequences
- Triggers not updating after enable/disable
- Schema Compare: Access violation if closed while busy
- Script Execution
- A significant memory leak was fixed
- Cascade of errors after a select returning lots of data
- Error when ']]>' present in query result
- login.sql and glogin.sql not working for no-client connection
- SQL Keywords not accepted as script arguments
- Session Browser
- "Additional Privs Required" dialog not working
- "Engine is currently busy" error
- "Field not found" error after connection lost
- SerialNum = 0 in lower/right "Sessions" tab
- Single Object Compare
- Access violation if Toad closed while running from SB
- Target object not always auto-selected
- SQL Recall: Unhandled exception if auto-saved while file was in use
- Team Coding
- Global filter exclusions getting merged
- TFS annotation text appears corrupt
- TNSNames Editor: Not available from menu in no-client mode
- Toad Script Runner: Can't connect with EZConnect syntax
- utPLSQL Manager
- Access violation when closing Toad
- Context menu flickers while test running
- Workspaces: Connection not restored if Automation Designer open
Enhancements
- Automation Designer
- Added ability to Copy/Paste Apps and Folders
- Added ability to enable/disable connections in connection iterator
- Didn't handle large ToadActions.dat well.
- Compiling: Added option to check to see if package in use before compiling
- Connections
- Added error handling after connection initialization pl/sql block
- No-Client mode now supports LDAP
- Dark Mode: Minor enhancements to editor colors
- Data Grids
- Copy/Paste to MS Teams now pastes in a nice table format
- Options -> Data Grids -> Visual -> Edit -> Simple. Dialog improved to prevent accidental coloring of header background color
- Describe Dialogs: Added an option to remember size/position
- Editor
- Font and Styling: Added "User Words 1" word list for user customization
- Font changed to Consolas.
- All tabs now marked Deleted/Modified at same time when files change on disk
- Better variable names when selecting SQL from PL/SQL, then CTRL+Enter to run
- File Compare: Added shortcuts for next/prev diff
- FTP: Controls better spaced in Server Settings window
- GUI font changed to Segoe UI.
- HTML Schema Doc, Schema Compare, Schema Script: SOS filters now saved as text, files can be now specified in automation
- Login Window
- Added a confirmation prompt when unchecking the save passwords option
- LDAP and TNSNames editor buttons moved to better location
- Options
- Simplified selection of thousand/decimal separator
- Toad debug logging can now be enabled from options window
- Schema Browser: Clone User - added a "Show SQL" button
- Script Execution: Feedback dialog now updates once per second during row retrieval. It's faster that way.
- Toad Script Runner: Added color schemas like Toad (configured separately)
The change log for Toad version 16.1 is here