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

The beta expires after a few 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.

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.35)
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 multiple queries
Export Dataset -> Display all results in grid -> Default Value not saved
Beta Released (14.2.17)
Beta Posted (16.0.83)
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 Released (14.2.93)
Beta Released (15.1.75)
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

Notes:

  • Oracle clients: 12cR2 and 18c are the recommended client versions.
    • 19c and 21c 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.

Running Total for 16.2: 60 bugs fixes, 20 enhancements

Beta 16.2.next, To be released 15-Aug-2022

Bug Fixes

  • Connections: Set Role/Transaction feature not working in no-client mode, and also not after auto-reconnect
  • Query Builder: Join order was inconsistent
  • Create Pluggable Database: TNSNames.ora not found in no-client mode
  • Schema Browser: Quick Filter selecting item from history when it should not
  • Editor: Cursor movement slow when arrow key held down
  • Data Grids: Copy/Paste Arabic text into MS Word or Teams missing/misformatting data

Enhancements

  • Connections: Added error handling after connection initialization pl/sql block
  • Editor Font and Styling: Added "User Words 1" word list for user customization

Beta 16.2.58, Released 10-Aug-2022

Bug Fixes

  • Script Execution: A significant memory leak was fixed
  • Editor: Caret placement incorrect when attempting to select a line

Enhancements

  • Schema Browser: Added Quick Filter match modes (right-click on quick filter to set)

Beta 16.2.54, Released 8-Aug-2022

Bug Fixes

  • Alter Table: Wrong column affected on the first click into columns grid
  • Session Browser: "Field not found" error after connection lost
  • Code Snippets: Access violation after editing snippets with auto-hide
  • Describe Objects: F4 not finding package constants
  • Run Procedure: "Cannot focus disabled or invisible window" error
  • Connections: Improved handling of reconnect when opening Schema Browser, Import Table, Data, Describe, Single Object Compare, Database Browser, SGA Trace, Chained Rows
  • utPLSQL Manager: Access violation when closing Toad
  • Editor: Wrong colors after restoring Editor Font and Syling defaults
  • Alert Log Viewer: opening files too slowly
  • Single Object Compare: Access violation if Toad closed while running from SB

Enhancements

  • Login: LDAP and TNSNames editor buttons moved to better location
  • Dark Mode: Minor enhancements to editor colors

Beta 16.2.43.1663, Released 1-Aug-2022

Bug Fixes

  • Login window: Selection changes to another group after delete
  • Compare Multiple Tables: Decimal separator incorrect in sync script
  • Schema Browser: Object Type incremental search was clumsy
  • Schema Browser: Error on Data tab refresh after connection lost
  • Schema Browser: SQL error when revoking object privs from mixed-case schema
  • Session Browser: "Additional Privs Required" dialog not working
  • utPLSQL manager: Context menu flickered while test ran

Enhancements

  • Describe Dialogs: Added an option to remember size/position
  • Editor: Better variable names when selecting SQL from PL/SQL, then CTRL+Enter to run
  • Editor: All tabs now marked Deleted/Modified at same time when files change on disk
  • Login Window: Added a confirmation prompt when unchecking the save passwords option
  • Schema Browser: Clone User - added a "Show SQL" button

Beta 16.2.34.1649, Released 25-Jul-2022

Bug Fixes

  • Options: Windows -> Create Table settings getting mixed up with Create Queue Table
  • Schema Browser: Object Type incremental search treating 2nd letter as 1st
  • Schema Browser: Team Coding icons missing for sequences
  • Schema Browser: Font size change resulted in wrong spacing between objects
  • Schema Browser: Create Insert for selected rows - bogus "no data found" message

Enhancements

  • Automation Designer: Didn't handle large ToadActions.dat well.
  • Connections: No-Client mode now supports LDAP
  • Compiling: Added option to check to see if package in use before compiling
  • Data Grids: Options -> Data Grids -> Visual -> Edit -> Simple. Dialog was worked to prevent accidental coloring of header background color
  • Data Grids: Copy/Paste to MS Teams now pastes in a nice table format
  • File Compare: Added shortcuts for next/prev diff

Beta 16.2.22, Released 18-Jul-2022

Bug Fixes

  • Export Dataset: Access violation if exporting to folder that can't be written to
  • Generate Schema/DB Script, Compare Schema/DB: SOS files now saved as text. Also, files can be specified in parameter files in Automation Designer
  • Schema Browser: Refresh LHS not working for Funcs, Procs, Packages, Types
  • Schema Browser: Popup menu for Types can get lost/broken
  • Toad Script Runner: Can't connect with EZConnect syntax

Enhancements

  • Toad Script Runner: Added color schemas like Toad (configured separately)

Beta 16.2.12.1608, Released 12-Jul-2022

Bug Fixes

  • Export Dataset: SQL Loader format - Null date fields should not have dbl-quote
  • Export DDL: Materialized views always show as NOLOGGING

Beta 16.2.7.1608, Released 5-Jul-2022

Bug Fixes

  • Connections: LDAP not working with 21c client
  • Connection Colors: Window border colors sometimes disappear
  • Data Grids: Cascade of errors when pasting invalid number
  • Data Generation: Failure when FK field names differ between tables
  • DBMS Output: Not returning complete text when output contains multibytes chars
  • Describe window: Can get stuck in an "Empty" state
  • Editor: Variables dialog sometimes stays on top of other apps
  • Export Dataset: Excel Instance - Excel staying behind Toad after export
  • Export Dataset: SQL Loader format - can't set string delimiter to null
  • Export Dataset: Access violation when exporting to location where file cannot be saved
  • File Compare: Access violation when trying to save results
  • Login Window: Duplicated entries if connections added manually in lower case
  • Options: Decimal and Thousand settings not retained
  • Query Builder: Fixed bad column sizing
  • QSR: Connection Error when launched from Toad's Project Manager
  • Schema Browser: Triggers not updating after enable/disable
  • Schema Browser: Filter/Sort dialog adding parens when not needed
  • Schema Browser: Object Types not displayed correctly when Team Coding enabled
  • Script Execution: SQL Keywords not accepted as script arguments
  • Script Execution: Memory leak when processing comments
  • Team Coding: Global filter exclusions getting merged
  • TNSNames Editor: Not available from menu in no-client mode
  • Workspaces: Connection not restored if Automation Designer open

Enhancements

  • GUI font changed to Segoe UI.
  • Editor font changed to Consolas.
  • HTML Schema Doc, Schema Compare, Schema Script: SOS filters now saved as text, files can be now specified in automation

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.39.807)
Beta Released (14.1.42.811)
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 (15.1.111)
Beta Released (14.1.108)
Beta Posted (16.0.47)
Beta Posted (16.0.83)
Beta Released (14.1.10.751)
Beta Released (14.1.30.790)
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 Released (14.2.93)
Beta Released (15.1.75)
Beta Released (14.2.102)
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.0.78)
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.1.92)