Toad Beta Change Log
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. Uncheck the "Use Oracle Client" box on the login window to try it. Pros and Cons of no-client mode are:
- No setup required
- It is is a bit faster than using a client.
- Supported: LDAP, TNSNames.ora, Oracle Encryption and Data Integrity, Spool SQL, and as of 3-July-2023: SSH, TCPS, and Oracle Wallet connections.
- Not supported: tracing/logging, proxy connections.
- Known issue: Timestamps display wrong offsets in no-client mode.
Toad Beta 17.0.294, Released 2-Oct-2023
Bug Fixes
- Alter Table: Access violation if connection ends while window is opening
- Data Grids: Invalid Pointer Operation after posting change in text popup editor after connection loss
- Data Grids: Crash after open/close/open user-defined object popup editor
- Editor/Workspaces: Multiple
*'s added after repeated close/open of workspace
- Explain Plan: Access Violation after closing connection, then changing dbms_xplan format
- Grid Find: Access Violations after multi-column find
- Schema Browser: Access violation after dropping subobject
- Workspaces: Split files marked as modified when not modified
- SQLNet Editor: Dash-style comments after numeric values causing errors
Enhancements
- Editor: "Export all grids to Excel" now handles "file in use" errors gracefully
- Error Dialogs: Removed "Search Forums" in error dialogs caused by loss of DB connection
- Grid Find/Filter: Added ability to find a value in any column
Toad Beta 17.0.274, Released 25-Sep-2023
Bug Fixes
- Automation Designer: Internet Access option blocking FTP actions
- Automation Designer: Excessive file writes of app backup files
- Automation Designer: Variables not processed in FTP downloads
- Connections: Test Connections dialog doesn't cancel when clicking the X to close
- Database Browser: Typing in the filter causes excessive refresh
- Data Grids: Access Violation if connection lost, then attempt to edit a date field
- DB Health Scan: A few things looked wrong in dark mode (Beta only bug)
- Editor: Opening maximized if previously minimized, then procedure dbl-clicked from Schema Browser
- Editor: Simple Navigator sometimes does not show package proc/func
- Schema Browser: Access violation in Mat. View "Used By" tab
- Settings: "File in use" error when saving some settings
- Team Coding: Access Violation after dropping Mat. View
- Schema Browser: Error when F5 to refresh if quick filter is dropped down
- Workspaces: Modified files loaded incorrectly when split to multiple editor tabs
Enhancements
- Options: Internet access can now be disabled from Toad options window
Toad Beta 17.0.256, Released 18-Sep-2023
Bug Fixes
- SB-Tables Add Constraint: Removed unneeded "Close w/o saving" prompt
- Automation Designer: Export Dataset file extension not always remembered for multi-table exports
- Create Table: Datatype lost after cancelling out of interval/timestamp gui
- Data Compare: Unneeded queries run when launched from Schema Browser
- Editor: Refactoring causes "Group function now allowed here" error when setting the "Remove Subqueries" option
- Schema Browser: Synonyms and "Uses/Used By" RHS tabs running unneeded SQL in some cases
- Single Object Compare: Unneeded queries run when launched from Schema Browser
Enhancements
- DB Health Scan: New window similar to DB Health Check, but looks nicer. Improvements to follow.
- Editor: Add prompt when multiple matching tables exist on Shift+Rt-Click
- Options: Toolbars/Menus, shortcuts: Added a search box
- Schema Browser: Improved performance of Package/Proc/Func nodes
- Schema Browser: Moved Table's right-click "n Selected Items" items to "create" submenu
Toad Beta 17.0.240, Released 11-Sep-2023
Bug Fixes
- Connection Colors: Schema Browser border color lost when selecting an object
- Beta only: Misc bug fixes with new "Fetch Trace Files from Server" window
Enhancements
- Automation Designer: Action Palette is now much more user-friendly
- Automation Designer: Export Dataset - Parameters can now be passed into SQL Files
- Debugger: Added a "Check Privileges" window on the main menu
- Editor: Backup Engine now does a much better job of cleaning up after itself
- Editor: Added option to dumb down the smart upper/lowercase feature
Toad Beta 17.0.231, Released 5-Sep-2023
Bug Fixes
- Schema Compare: Invalid parameter in sync script with LOBs:
Next -1
- Shutdown: Attempt #1 at fixing incomplete shutdown issue
- Editor: Code Insight not showing PL/SQL elements with caret after SQL
- Editor: Code Insight sometimes duplicating suggestions
- Export DDL: PLSQL block for refresh groups (after MV script) missing slash
- Export DDL: Dialog too small
- Login: SSH icon not visible in some dark modes (Beta Only Bug)
- Toolbars: Flickery when color schemes enabled
- Automation Designer: Text of selected action hard to see in some color schemes
- Schema Browser: Procedure node not selected in navigator after FIND parameter and parameters not displayed
- Schema Browser: Treeview selected node not visible in many color themes
Enhancements
Toad Beta 17.0.216, Released 28-Aug-2023
Bug Fixes
- Schema Compare: Option for "Clusters" not always remembered
- Schema Compare: Some "no action taken" comments in sync script did not mention which object they are talking about, making the comment useless.
Enhancements
- Schema Compare: Add options (under Options -> Script) to verify that a) tablespace exists in target DB and b) Oracle option exists in target DB. Either of these could make the SQL in the sync script fail. With the new option checked, if a statement will fail, the difference is colored red and unchecked on the difference details page. This will exclude it from the sync script. You can check it if you want to include it in the sync script anyway.
- Schema Browser: Added options to exclude Domain Index tables, Toad Feature tables, and Oracle feature tables
Toad Beta 17.0.204, Released 21-Aug-2023
Bug Fixes
- Editor: In no-client mode, a cancelled script wouldn't cancel until current SQL finished
- Editor: In no-client mode, SQL feedback not correct for some statement types
- Editor: Explain Plan sometimes connects to wrong DB in RAC
- Create Materialized View: Not detecting MV Log through synonyms
- Script Creation: Incorrect script created for comments which begin and end with a single quote
- Schema Compare: False diffs on LOBS, Tables, and Indexes found if segment exists on source DB but not target
- Schema Compare: False diffs on triggers if FOLLOWS clause contains schema name
Enhancements
- Automation Designer: Replaced navigator with nodes in the tree.
- Manage User Files: Grids, desktops and window positions can now be restored after resetting user files
- Connection Colors: Color now visible on Toad's main form when Color Scheme also enabled
Toad Beta 17.0.194, Released 14-Aug-2023
Bug Fixes
- Dark Mode: Colorization not always applied fully to SQL Recall window
- Editor: Script execution not cancelling in no-client mode until current query finishes
- Editor: "Invalid Floating Point Operation" error from minimap (rare)
- Schema Compare: Sync script attempting to alter tables automatically created for materialized view logs
- Schema Compare: Sync script attempting to drop materialized view as a table
- Schema Compare: Sync script attempting to modify constraints in the recycle bin
- Schema Compare: "Include schema in migration DDL" option ignored if "format" also checked
- Schema Compare: Create Materialized View including default comment on underlying table
- TNSNames Editor: SSL_SERVER_SN_MATCH parameter not supported
- TNSNames Editor: Formatting caused unsupported parameters to disappear without warning
Enhancements
- Editor: Added refresh button above data grids
- Oracle 23c: Added new keywords for syntax highlighting
- Schema Browser: Added options for Show SQL and Commit when refreshing refresh groups
Toad Beta 17.0.183, Released 7-Aug-2023
Bug Fixes
- Dark Mode: Editor tab coloring in slightly off in Aqua (and Golden) Graphite
Toad Beta 17.0.177, Released 1-Aug-2023
Bug Fixes
- Dark Mode: Editor data grid looked bad in dark mode after yesterday's beta
Toad Beta 17.0.172, Released 31-July-2023
Bug Fixes
- Editor: "DB Contents Newer - compile anyway" prompt displayed even after compile (related to workspaces)
- Login Window: "Test" failed when no Oracle client in use
- Login WIndow: Oracle home text didn't clear when unchecking "Connect Using Oracle Home"
- Session Browser: Filter settings lost
- Session Browser: Explain plan failed when connected to RAC without an Oracle client
- Schema Compare - Statements generated for tables auto-created by domain indexes
Enhancements
- Editor: Added ability to pin data grids (after F9 or CTRL+Enter). Look for the pin icon on the toolbar above the grid.
- Editor and Schema Browser: Improved package parse time when "Show References" unchecked
- Other: License expiration warning was too imposing. We dialed it back a bit.
Toad Beta 17.0.163, Released 24-July-2023
Bug Fixes
- Data Grid: Missing ellipsis when very long data is shown
- Editor: Refactor not working in SQL with only one package constant
Enhancements
- Minor GUI Improvements to new SSH feature
- SQLNet Editor: Improved look of this window and added a few parameters for SSL
- TNSNames Editor: Added support for Retry Delay, Retry Count, and Compression parameters
- Schema Browser: Minor improvements to filter for triggers
- Schema Browser: Tables-Partitions - added a note to clarify that some data is from statistics and may not be exact
Toad Beta 17.0.150, Released 10-July-2023
Bug Fixes
- Code Insight: Not working in subqueries
- Datagrid: "Invalid value for field" Error on DELETE key in cell of numeric data.
- Color Schemes: MDI Min/Max/Restore buttons painting badly after minimize/restore
Enhancements
- Schema Browser: Work around ORA-01873 which can occur when querying DBA_JOBS after database upgrade to 19c or newer
- Editor: Parameter assistance will now appear faster for Oracle built-in functions which exist in the SYS.STANDARD package. For example, when you type
TO_CHAR( then wait.
Toad Beta 17.0.144, Released 3-July-2023
Bug Fixes
- Code Insight: Filtering was slow on databases with large numbers of objects
- Code Analysis: SQL Scan didn't return results with Oracle Proxy connections
- Connection Bar: Missing icons on right-click menu item for open windows
- Datagrid: Popup text editor throws "cannot modify read-only dataset" when formatting SQL
- FTP: File timestamps not displayed in local time zone
Enhancements
- Connections: SSH connections can now be defined within Toad. You no longer need to use PuTTY or similar to do this
- Connections: TPCS protocol can now be used in no-client mode
- Data grids: Can now sort by column header click when SQL already has ORDER BY
- Describe windows: Added server info to window caption (ungrouped describe windows)
- Window Bar: Added "Current Connection Only" menu item on right-click menu
Toad Beta 17.0.134, Released 26-June-2023
Bug Fixes
- Editor: Refactor not working for SQL with only one package constant
Enhancements
- Copy Table Data: 'Default Settings' behavior made more clear
Toad Beta 17.0.128, Released 19-June-2023
Bug Fixes
- Misc: Fixed ghosty "grid lines" that have been appearing in recent betas
- Startup: Fixed slow startup due to system proxy settings not being detected properly
Enhancements
- Object Palette: Can now display subobjects as Schema Browser does
- Schema Browser: Dropping an object from Invalid Objects tab now gives a more descriptive prompt
Toad Beta 17.0.113, Released 12-June-2023
Bug Fixes
- Editor: Fixed multiple "reload file" prompts after clicking "Yes to all"
- Open Trace File dialog: Some files showing NULL for date (fix requires drop/recreate of ToadDirList java source object)
- Team Coding: Unicode lost when comparing files
- Trace File Browser: contrast problems in dark mode
- WINE compatibility: Fixed access violation from Schema Browser
Enhancements
- Create Table: Added prompt to launch Import Table Data after creating columns from file
- Import Table Data: Added "Create new table" button
- Generate Schema Script: Added option to combine files for some object types
Toad Beta 17.0.101, Released 05-June-2023
Bug Fixes
- Docked Panels: An undocked, floating panel can go behind Toad after switching to another app and back
- Login window: Selected/Focused row not in sync in tabbed display style
- Schema Browser: Data tab Filter/Sort dialog - "Columns" dropdown not wide enough
Enhancements
- Editor: Added option in script output to sync currently selected grid with SQL in script, and vice versa
- Editor: Added an optional mini-navigator panel at the top of the edit area
- Logging: Added enhanced logging for internet activity
- Generate Schema Script: New option to include schema in object file names
- Single Record Viewer: Added ability to copy column name and value to clipboard
Toad Beta 17.0.91, Released 30-May-2023
Bug Fixes
- Grid Sort Dialog: Fixed tab order
- Session Browser: Statistics and Processes tab not loading (beta only bug)
- Workspaces - Minimized window position lost after multiple saves
Enhancements
- Connection Bar Button: Added "Frequently Used Windows" right-click option
- Schema Browser: Added separate icons for Session and Transactional Global Temporary Tables
- Session Browser: "Filter" dropdown and funnel icon consolidated into one, and moved so it is nearer to "Limit" controls.
- Oracle 23c: Added support for new DEFAULT ON NULL options
- Oracle 23c: Added support for domains
- Oracle 23c: Added support for annotations
- Window Bar Button: Rearranged items for a cleaner and more useful look
Toad Beta 17.0.77, Released 22-May-2023
Bug Fixes
- Add Column dialog: Column names were limited to 30 characters
- Automation Designer: Script action fails if output path contains variables
- Export DDL: Semicolon missing when exporting views with "query only" option
- Schema Browser: Tablespace's RHS Objects tab not displaying grid
- TSR: Added missing color themes
- Window Menu: Minimized windows always restored as maximized
- Window Menu: Minimized Editor tabs not restored
Enhancements
- Connections: If logged in as a common user with the SET CONTAINER privilege, you can now right-click on connection bar button to change to a different pluggable/container
- Editor: Added a summary page to "Export all grids to Excel"
- Oracle 23c: Added support for JSON Relational Duality Views
Toad Beta 17.0.64, Released 15-May-2023
Bug Fixes
- Export DDL: Incorrect script for encrypted tablespaces
- Report Designer: F1 not downloading Fast Reports user manual
- Schema Browser: Double clicking on trigger errors not finding the errors in source tab
- Schema Browser: Dragging multiple objects from Favorites only including one object
- Subscription: Access violation after update
Enhancements
- Oracle 23c: Added support for PRECHECK keyword on constraints
Toad Beta 17.0.56, Released 8-May-2023
Bug Fixes
- Toad's internal beta updater wasn't updating
- Connection Error dialog: Fixed incorrect advice on "no listener" error
- Schema Browser: Load Trigger Into Editor ignored Editor's Schema Name options
- Schema Browser: Save Procedure/Function defaulted to wrong extension in save dialog
- Workspaces: Removed artifact on mainform when workspace toolbar hidden
- Workspaces: Not able to toggle Workspace toolbar's visibility
Enhancements
- Connection Error dialog: Added suggestion to verify installation of MS Visual Studio redistributable if using instant client
- Object Search: Now remembers settings per-connection
- Object Search: Now remembers settings when launched from Export DDL
- Oracle 23c: Added support for boolean datatypes
- Oracle 23c: Added support for "create if not exists"
- Oracle 23c: Added support for "drop if exists"
- Oracle 23c: Added support for schema privileges
- Schema Browser: Added "Copy script to Editor" in SB-Tables-Triggers
Toad Beta 17.0.41, Released 1-May-2023
Bug Fixes
- ADDM Report: Text cut off in "drop baseline" dialog
- Analyze Table: Table not being auto-selected when window launched from Schema Browser
- Export Dataset: DBLink containing a dot was confusing schema auto-detect
- Import Table Data: Not continuing to import after error with array DML
- Schema Browser: SQL error displaying Scheduler job run log on Oracle version 10.1
- Session Browser: Open Cursors subtab changes selected row in parent grid.
- Workspaces: Position of minimized windows was lost
- Workspaces: Unicode data was lost
- Workspaces: Dropdown doesn't support incremental search
- Workspaces: Changes in Editor contents lost if loaded object from DB
Enhancements
- Editor: Added option to trim whitespace when saving files
- Object Search: Now remembers settings per-connection
- Workspaces: Can now be specified from command line like "Toad.exe -workspace X" where X is workspace name. Put X in double-quotes if it contains spaces.
Toad Beta 17.0.18, Released 17-Apr-2023
Bug Fixes
- Alter Datafile: "UNLIMITED" appears in SQL after other edits
- Editor: Profiler data generated by Code Tester not summarized
- Editor: Script Execution moves caret to the wrong location after execution
- Editor: Toolbar AV while customizing
- Login Window: Grid grouping changes after deletion
- Export DDL: Scheduler Job script with unnamed arguments produces SQL error
- Generate Schema Script: Tablespace inmemory and compression options ignored
- Schema Browser: Can't rename favorites folder
- Schema Browser: Single Row of tabs mode - Right/Left arrows not shown in Windows 11
- Window Bar: Not sorting correctly when connection bar also sorted
Enhancements
- Schema Browser: Added ability to pin quick filters
- Session Browser: Added "Kill Session" button to Locks tab.
- Session Browser: Added status column to Locks tab
- Options: Got rid of DBA page. Moved those options out to their respective windows
- Workspaces: Combined buttons into one dropdown to save space on the toolbar
The change log for Toad version 16.3 is here