Toad Beta Change Log
There will be no more betas for version 2025 R2. The official release date is June 2. Betas for the next version will start up again after that.
Thank you to all of you who reported bugs and suggested enhancements. We appreciate your help!
Bug Fixes
- Accessibility
- Screen readers not reading some trees/lists (TVirtualStringTree) correctly
- Many windows have been updated to be usable by keyboard only.
- Tab order in many windows in Toad has been fixed.
- Add/Edit column dialog: Minor GUI issues
- Alter Tablespace
- Datafile dialog briefly displays wrong datafile size
- GUI shows "General" briefly, then switches to "Files"
- Alter Trigger: "Show SQL Including Schema" option overridden by "Include SQL" checkbox
- Automation Designer
- Connection Iterator not passing connection to grandchild actions
- Connection Iterator displays connection colors incorrectly
- AWR/Statspack Browser
- Advice hard to see in dark mode
- Sometimes no advice on pluggable databases
- Connections
- "Net: PKCS#12 Data is broken" error when trying to connect in no-client mode with Oracle wallet
- Can't connect with SSH in no-client mode
- Can't connect to mounted but not opened database without errors
- "Cannot open file" error if wallet location specified with double-quotes and connecting in no-client mode
- Cursor does not change to SQL Wait cursor on disconnect/reconnect
- Error when connecting to mounted but not opened database
- Failed login from tnsnames entry in iFile causes access violation
- Occasional access violation when session ending
- Create/Alter Queue Table: Controls were misaligned
- Create/Alter Table
- Subpartition template toolbar was wrong color
- Subpartitions of hash partitions not supported
- Data Grids
- Looping access violation if wrong number format entered
- OCI Array Buffer Size setting behaves as automatic when set to manual
- Database Browser
- AV after disassociate of connected DB
- Can't change "connect as" after failed login
- Possible to connect to wrong DB
- DBMS Output: Attempted fix on occasional ORA-03120 when fetching 10 or more lines of output
- Edit Instance parameter dialog: Minor GUI issues
- Editor
- Access violation with some custom desktops
- Backup files deleted too quickly after recovery
- Both (deleted) and (modified) displayed if a file was externally deleted
- Code Insight does not show exception declarations
- Find dialog not closing on ESC and missing first character typed
- Modified flag not shown after compile and then further edits
- Navigator contents not displayed if initially unpinned
- ORA-06550 thrown when executing pl/sql with DBMS Output options enabled due to ALL_ARGUMENTS change in 18c and newer
- Query viewer "clear inactive" button missed some
- Query viewer showed full TNS info on no-client connections
- Script Output has extra line feed in output compared to SQL*Plus
- Unable to execute/debug PL/SQL with complex arguments in 18c and newer databases
- Export Dataset: "Filename" field painted badly in dark mode when Excel Instance format selected
- Export DDL
- Wrong icon in main menu and form
- Incorrect script for XMLINDEX type indexes
- Subpartitions of hash partitions not supported
- Export File Browser: Open dialog columns resize slowly
- Fast Shutdown: Message on dialog incorrect about rollback/commit
- Generate Schema Script
- Constraints excluded from script when only some constraint types selected
- "Never parse triggers for schema name" behaves backwards
- Import Table Data - if launched from create table with excel file, the file type isn't correctly selected in import table data
- Instance Manager: Fails with localhost entries
- Jump Search
- Incorrect images were displayed
- Removed invalid entries named "Test Case Name"
- Misc
- Toad's main title bar flickers when switching between maximized windows
- Random small toolbars throughout Toad have wrong background color
- New Version Dialog
- Date conversion error thrown if date format changed after "Remind me later" clicked
- Reappears without content after clicking "skip this version" or "Remind me later"
- Object Palette
- Columns panel not remembering height
- Scrolls to top on when clicked for the first time
- Unnecessarily refreshing when multiple connections being made
- Oracle Tuning Advisor: multiselect in the grid not allowed
- Project Manager: File treated as folder when dragging
- QSR
- Access violation when color schemes enabled
- "NET" error when trying to connect independently of Toad
- Schema Browser
- "Configure" menu item disappears when all but one object type hidden
- Access violation if materialized view dropped externally while viewing in Schema Browser
- Filter/Sort window doesn't remove "order by desc" correctly
- Index columns not displayed as subobjects if from a different schema
- Object type dropdown painted badly when font size increased
- Typo in the truncate table dialog:
- Schema Compare
- "Convert Datatypes using DBMS Redef" option not working unless "Add/Reorder columns with DBMS Redef" also checked
- XMLINDEX type indexes should be dropped and created, not altered
- Single Record View: Timestamp columns too narrow
- SQL Firewall: "Violations" schema combobox not refreshed after violations have been generated
- Team Coding:
- Able to drop table if controlled by, but not logged into VCS
- Fixed capitalization on several messages
- Lock status incorrect after Toad is killed
- No warning of data loss when a merge conflict involves table structure changes
- Text Compare
- "Merge" diamond icons sometimes do nothing
- "Reload file and recompare" button does not reload if text didn't come from file (button hint changed)
- TNS Names Editor - Sometimes opens looking blank
- Toad for Mac
- Toad hangs when clicking license agreement in Help->About
- VCS login displayed after logging into DB with VCS enabled (VCS should be disabled for Mac)
- Toolbars
- Window bar button grouping failed on multiple same connections
- Dropdown arrow size inconsistent when large icons in use
- Workspaces
- If auto-load fails, partially loaded workspace can be overwritten and contents lost
- Not loading correctly in some environments
Enhancements
- Accessibility
- Buttons to move something Up/Down/Left/Right are now consistent throughout Toad.
- Buttons with '...' for captions now give meaningful context to screen readers
- Enhanced screen reader support in Export DDL and misc editor popup windows
- Enhanced screen readers support in Login, Login Edit, and Export Dataset
- Administer Tablespaces: Added "Bigfile" column
- Automation Designer
- Added right-click option for command line parameters
- CTRL+F can now search property values of actions
- Details of connection errors are now written to error log
- Compare Data: SQL can now be entered for comparison
- Compare Databases/Schemas, Export Database/Schema Script: Got rid of annoying "clear before loading" prompt in the filter
- Connections:
- Color can now be overridden with another color if specified role is enabled for session
- Connection bar buttons -> Right-click -> Containers is now alphabetical
- Connection error dialog didn't always render HTML content
- Don't show "Cannot change to disconnected session" message
- Errors will now include connection info
- New lightweight script engine introduced for internal operations
- Wallet location and SSL server DN match can now be specified on Direct tab
- Data Compare: Full SQL can now be entered
- Data Grids
- "Order by" dialog now appears for BLOB/CLOB columns so you can at least copy column name
- Right-click menu item added to copy column names to clipboard
- Data Pump Export - updated look
- Data Pump Import - updated look
- DBMS Output
- Added TRIM options
- Exposed option to fetch without using CLOB
- Describe: List of objects can now be saved without schema or connection
- Editor
- Dock panel tabs are now created as needed. Editor now opens faster and now initially consumes fewer GDI and User objects
- Indicators for externally modified/deleted files is now optional in Options -> Editor -> Display
- Instead of showing (deleted) or (modified) for externally modified files, editor tabs will be drawn in strikeout or italics
- Export DDL
- Updated look
- Trigger Scripts generation is now more efficient
- Export File Browser: Added ability to export all tables to CSV
- Find Dialog: Now opens in the center of the the Editor from which it was launched
- FTP: Added an option to not convert timezone
- GDI and User Object usage monitoring: If Toad approaches the limit for either of these resources, an warning will be displayed
- Help: Local PDF files removed, now available online via Help menu
- Login Window
- Connections can now be imported from SQL Developer JSON files
- Grid now shows fewer columns by default
- Main Menu: Reopen File now prompts before removing files which could not be found
- Object Search: Window now opens with search text pre-selected so you can just type to replace it
- Options: Startup tab simplified
- Oracle Tuning Advisor: Added "Send to" button to send SQL to create tuning tasks to SQLPlus, TSR, Editor, or Show SQL dialog
- QSR: Added Eurekalog exception handling
- Schema Browser
- Added ability to show proxy users from both directions for users
- Drop objects dialog will now include schema name if schema is different than the login schema
- Now conserves GDI and User Objects resources when usage starts to get high
- Option added to select CLOBs through DB Links
- Quick filter now searches favorite folder names
- Single Object Compare: Added option to convert column datatypes using DBMS_Redef
- Space Manager: Added ability to specify grantees during setup
- Team Coding: Option added to make VCS errors more noticeable via popup messages
- Test/Reconnect: Toolbar button now launches window which lets you choose which connections to test/reconnect, so behavior is consistent with "Close connection"
- TLS 1.3 now supported
- Toad for Mac: Now includes Instant client version 23.7
- Toolbars: Main and Editor toolbars have been redesigned to have fewer buttons visible by default for a less overwhelming user experience
- Trace File Browser
- Added an option to purge local copies of trace files
- Added ability to cancel a file load
The change log for Toad version 24.2 is here