Toad for Oracle 16.2 Beta

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:

Which version?

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

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

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

8 Likes
Beta Released (13.2.0.16)
Beta Released (13.2.0.37)
Beta Released (13.2.0.4)
Access violation at address 00000000046DB240 in 'Toad.exe' (Toad for Oracle Xpert v 13.0.0.80)
TOAD_FILE_CHUNK split issue (tfo v13.1.0.78)
Beta Released (14.2.102)
Beta Released (15.0.42)
Toad for Oracle Version 14.0
Beta Posted (16.1.52)
BUG: Quick describe / CTRL+D bugg
Export Dataset -> Display all results in grid -> Default Value not saved
Beta Released (14.2.35)
Beta Posted (16.0.83)
Export dataset multiple queries
Beta Released (14.2.17)
Beta Released (15.1.52)
'Not Responding' Freezes Session
Beta Posted (16.2.43)
[16.0.90] revoke privilege doesn't work from schema browser
Automation Designer Change Connection
Beta Released (15.1.61)
Beta Released (15.1.64)
Option problem: Desktop SQL o PLSQL
Team coding toad 14.0 not compatible with 14.1
Beta Released (15.1.67)
Export dataset multiple queries
Beta Posted (16.2.54)
JSON syntax error (conversion Collection type to Clob)
Beta Released (14.2.87)
Object Type LHS drop down won't work on extra monitors
Toad Script execution very slow
Beta Posted (16.2.64)
Beta Released (14.2.93)
Beta Posted (16.2.77)
Beta Released (15.1.75)
Beta Posted (16.2.72.1705)
Beta Posted (16.2.92)
Beta Posted (16.2.85)
Menu Animation Fade Effect
Toad for Oracle 14.1 - Shortcut changes not working
Automatic reconnect
Toad popup window do not show all records
Dark Mode in Toad12.6
Beta Released (15.1.84)
Beta Released (15.0.37)
Toad 14 Editor loses a character
TOAD 13/14 - Leading tabs in the editor truncate the sql statement by 3 characters
Beta Released (15.1.86)
"Next/Previous Navigator Node" keyboard navigation do not work
Beta Released (15.0.33)
Beta Released (15.0.47)
Beta Released (15.0.55)
Beta Released (15.0.61)
Beta Released (15.0.69)
Beta Released (15.0.66)
Beta Released (15.0.78)
Beta Released (15.1.92)
Beta Released (15.1.104)
Beta Released (15.1.111)
Beta Posted (16.0.4.1390)
Beta Posted (16.0.9)
Beta Posted (16.0.12)
Beta Posted (16.0.16)
Beta Posted (16.0.25)
Describe dialog size/location
Beta Posted (16.0.36)
Opening files with existing /*<TOAD_FILE_CHUNK>*/
Toad 13.1.0 Schema Browser RHS shows wrong object
Java compile F9 ORA-24344: success with compilation error
Bug in New toad version compare to very old version
Toad for Oracle blocked by VPN
Beta Posted (16.0.47)
VARCHAR2 values not DESC correctly in Toad
VARCHAR2 values not DESC correctly in Toad
Beta Posted (16.0.53)
Toad 15.1 schema Browser Public synonyms - out memory
Beta Posted (16.0.64)
On Monday, you can do this
Toad showing incorrect TEMP tablespace / datafile size
Beta Released (16.0.74)
Comparing schemas: list indexes with table creation scripts
Trace File Browser blocking
Toad for Oracle New Unit Testing Capability Available in Beta
Connection error External exception C0000006
Toad for Oracle appears an alert with ORA-29275: partial multibyte character when i execute session browser feature on Toad for Oracle.
Toad for Oracle New Unit Testing Capability Available in Beta
TOAD Memory Leak & Crash on SB Synonyms
BUG: data editing fat fingered bummer
AV on Explain Plan using Threaded query session
Old BUG: Table Rebuilder removes INTEGER numeric type
How to display the actual execution plan of the last executed query using dbms_xplan.display_cursor?
Export dataset with XMLTYPE column
ORA-01775: looping chain of synonyms with TOAD_PLAN_TABLE
Schema Compare doesn't generate script for table diffs
Nested Table Edit always shows one row
Object Palette does not conform to Windows Display setting for High Contrast
Object compare jumps pages
AutoConnect doesn't work on TOAD 13.2
Schema compare default collation difference
Unable to edit dataset of query in Editor
Naming Excel sheets when Exporting data from SQL Queries
Automatic update fails
Beta Posted (16.0.86)
SQL-Error when comparing a single object
Access violation at address 00000000041A44AB in module 'Toad.exe'. Read of address FFFFFFFFFFFFFFFF
TOAD for Oracle 15.1 and 16.0 BETA - Issue with Synonyms Tab in Schema Browser
Toad for oracle 15.1.113.1379 tnsnames editor not working
Toad 13.3 session browser does not work properly on RAC
Batch file for Toad
Toad 13.3 session browser does not work properly on RAC
Toad Editor behaviour copy paste ctrl chars
Tooltips in TOAD appear black
Error ORA-01741 when editing table (F4)
Beta Released (14.1.10.749)
Access violation 041A3E6C, TOAD shuts down
Displaying cached execution plan in "tree display" without inactive steps for adaptive plans
Beta Released (14.1.10.751)
Problems with Toad 14.0 crashing
Problems with Toad 14.0 crashing
Displaying cached execution plan in "tree display" without inactive steps for adaptive plans
Highlight hangs up Toad
Beta Released (14.1.22.778)
How to get the most out of this forum and support
TOAD 14 Export Dataset is broken
Toad for Oracle 14.1.10.751 Bug When Adding Constraint to View
Beta Released (14.1.30.790)
Expired 15.0.23.x?
Beta Released (14.1.39.807)
Toad Beta version 16.1.7.1521 is posted
Toad 13.1.1.5 getting ORA-22053
Toad 15.1.113.1379 - sFTP issue
Highlight hangs up Toad
Beta Released (14.1.42.811)
Problems with Toad 14.0 crashing
Problems with Toad 14.0 crashing
Beta Released (14.1.73)
Beta Posted (16.1.25)
Beta Posted (16.1.37)
Beta Posted (16.1.32)
Beta Released (14.1.54.830)
Beta Released (14.1.57)
Lockout with Oracle saved workspaces
Importing connection and passwords from 12.8 to 14.0
Dark Mode Cobalt - Current Tab Highlighting
Beta Posted (16.1.39)
Problems with Toad 14.0 crashing
Beta Posted (16.1.44)
Toad For Oracle 14.0 High sys utilization & crashing when idle
Beta Released (15.0.87)
Beta Released (14.1.84)
Search Results - Chinese (?) characters in Results grid
Beta Released (15.0.94)
Beta Released (14.1.96)
Running a build script - API Guard Error Function 5308
When clicking SAVE to save SQL - Export Dataset dialog pops up instead
Beta Released (14.1.108)
Pasting from Vim into the editor
Inconveniente despues de actualizar Toad 14.2
Beta Released (14.1.114)
Toad connection time when instance is down
Beta Posted (16.2.7)
Beta Posted (16.2.12)
Beta Posted (16.2.22)
Comportamiento exraño editor
Beta Released (15.1.24.1225)
Change of keyboard shortcuts doesn't work in TOAD 14
Beta Released (15.1.29)
Notification on SQL completion
14.2.104.1069 Toad Adds extract character (non-ASCII) when loading
Beta Released (14.2.43)
Ctrl + c broken in beta
Option problem: Desktop SQL o PLSQL
Beta Released (14.2.52)
Beta Released (14.2.55)
Beta Released (14.2.59)
Grid Popup Editor for Clob Values displaying corrupted data
Beta Released (14.1.114)
Beta Released (15.1.33)
Beta Released (14.2.65)
Beta Posted (16.2.34)
Dark Mode Coming to Beta on Monday!
Dark Mode Coming to Beta on Monday!
Beta Released (14.2.71)
Runtime Exception when running UnitTests
Running a build script - API Guard Error Function 5308
Import data - datetimefromstring
Beta Released (15.1.41)
Beta Released (14.2.73)
Big bug in rebuild table, Toad 14.1.120

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

2 Likes
Beta Released (14.1.2.726)
Problems with Toad 14.0 crashing
Beta Posted (16.0.86)
Beta Released (14.1.84)
Beta Released (15.1.61)
Beta Released (14.1.114)
Beta Released (14.1.73)
Beta Released (14.1.54.830)
Beta Released (14.1.57)
Beta Posted (16.1.52)
Beta Released (15.1.86)
Beta Posted (16.1.44)
Beta Released (15.0.47)
Beta Released (14.1.108)
Beta Released (15.1.111)
Beta Posted (16.0.47)
Beta Posted (16.0.83)
Beta Released (14.1.10.751)
Beta Released (14.1.30.790)
Beta Released (14.1.39.807)
Beta Released (14.1.42.811)
Beta Released (15.0.87)
Beta Released (15.0.94)
Beta Released (14.1.96)
Beta Posted (16.2.7)
Beta Posted (16.2.12)
Beta Posted (16.2.22)
TOAD Menu Bug when Connection Lost
Beta Released (15.1.24.1225)
Beta Released (14.2.17)
Beta Released (15.1.29)
Beta Released (14.2.35)
Beta Released (14.2.43)
Beta Released (14.2.52)
Beta Released (14.2.55)
Beta Released (14.2.59)
Beta Released (15.1.33)
Beta Released (14.2.65)
Beta Posted (16.2.34)
Beta Released (14.2.71)
Beta Released (15.1.41)
Beta Released (14.2.73)
Beta Released (15.1.52)
'Not Responding' Freezes Session
Beta Posted (16.2.43)
Beta Released (15.1.64)
Beta Released (15.1.67)
Beta Posted (16.2.54)
Beta Released (14.2.87)
Beta Posted (16.2.64)
Beta Released (14.2.93)
Beta Posted (16.2.77)
Beta Released (15.1.75)
Beta Posted (16.2.72.1705)
Beta Posted (16.2.92)
Beta Released (14.2.102)
Beta Posted (16.2.85)
Beta Released (15.1.84)
Beta Released (15.0.37)
Beta Released (15.0.42)
Beta Released (15.0.33)
Beta Released (15.0.55)
Beta Released (15.0.61)
Beta Released (15.0.69)
Beta Released (15.0.66)
Beta Released (15.1.92)
Beta Released (15.1.104)
Beta Posted (16.0.4.1390)
Beta Posted (16.0.9)
Beta Posted (16.0.12)
Beta Posted (16.0.16)
Beta Posted (16.0.25)
Beta Posted (16.0.36)
Beta Posted (16.0.53)
Beta Posted (16.0.64)
Beta Released (16.0.74)
Beta Released (14.1.10.749)
Beta Released (14.1.22.778)
Toad Beta version 16.1.7.1521 is posted
Beta Posted (16.1.25)
Beta Posted (16.1.37)
Beta Posted (16.1.32)
Beta Posted (16.1.39)
Beta Released (15.0.78)