Toad for Oracle 16.2 Beta

[ButtonPusher]

We are proud to announce the Toad for Oracle v16.2 beta

We encourage you to participate in the beta program to help us deliver a high quality product. This is your opportunity to participate in the development, direction, and testing of Toad for Oracle. By becoming a beta tester you will have direct access to the development team and product management via the Toad World forum.

Instructions for joining the Beta program:

• Read the Beta Agreement. Downloading the Beta code constitutes usage agreement.

• If you have not yet done so, install Toad for Oracle version 16.1 (Non-subscription) and run it at least once. The Toad Beta will not run without it.

• IMPORTANT: Do not install Toad Beta into your commercial Toad folder

Which version?

If you have a 32-bit Oracle client currently installed in a 32-bit or 64-bit environment:

• Download/Update 32-bit Beta

If you have a 64-bit Oracle client currently installed in a 64-bit environment:

• Download/Update 64-bit Beta

Beta Expiration

Each beta expires after 4 weeks, but new versions with later expiration dates are released often, typically on Mondays. An indicator will appear on Toad's status bar when a new version is available. You can just click it to download and install the update (No need to remove the old beta first, just install the new one on top of it). It's very easy. In this way you can continue to use the beta until the next version of Toad is officially released. We encourage you to stay up-to-date with the most recent beta version.

A change log is below

[JohnDorlon]

Toad Beta Change Log: 86 bug fixes, 25 enhancements for version 16.2

Notes:

• Oracle clients: 12cR2 and 18c are the recommended client versions.
  • 19c and 21c will work, but are not recommended due to memory leaks with LOBs, as well as hangs when cancelling queries against 11gR2 servers.
  • 12cR1 and older clients don't handle XMLTYPE natively.
  • Toad's no-client option works well, and is a bit faster than using a client, but it has a few limitations such as Tracing/logging, proxy connections, and TCPS. However, LDAP, TNSNames.ora, Oracle Encryption and Data Integrity are all supported in no-client mode. This post has a good discussion about it. Uncheck the "Use Oracle Client" box on the login window to try it.
• Fonts
  • Segoe UI is Toad's new GUI font.
  • Consolas is Toad's new Editor (fixed-width) font.
  • So nice.

No more 16.2 betas are planned. 16.2's release date is 29-Sep-2022

Bug Fixes (86)

• 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 (25)

• 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