Toad for Oracle 2025 R2 Beta

Toad Beta Change Log

Toad Beta 25.2.249.5632, To be released 17-Mar-2025
Bug Fixes

  • DBMS Output: Attempted fix on occasional ORA-03120 when fetching 10 or more lines of output

Enhancements

  • DBMS Output: Added TRIM options
  • DBMS Output: Exposed option to fetch without using CLOB

Toad Beta 25.2.228.5567, Released 10-March-2025
Bug Fixes

  • Oracle Tuning Advisor - multiselect in the grid not allowed
  • Import Table Data - if launched from create table with excel file, the file type isn't correctly selected in import table data
  • Schema Browser: Typo in the truncate table dialog:

Enhancements

  • Schema Browser: Drop objects dialog will now include schema name if schema is different than the login schema
  • Oracle Tuning Advisor: Added "Send to" button to send SQL to create tuning tasks to SQLPlus, TSR, Editor, or Show SQL dialog

Toad Beta 25.2.207.5497, Released 3-Mar-2025
Bug Fixes

  • QSR: Access violation when color schemes enabled
  • Editor: Find dialog not closing on ESC and missing first character typed

Enhancements

  • QSR - Added Eurekalog exception handling

Toad Beta 25.2.77.5385, Released 10-Feb-2025
Bug Fixes

  • Data Grids: Looping access violation if wrong number format entered
  • Script Output: Extra line feed in output compared to SQL*Plus

Enhancements

  • New lightweight script engine introduced for internal operations
  • Schema Browser: Quick filter now searches favorite folder names

Toad Beta 25.2.157.5323, Released 3-Feb-2025
Bug Fixes

  • Export DDL: Incorrect script for XMLINDEX type indexes
  • Generate Schema Script - Constraints excluded from script when only some constraint types selected
  • Schema Browser - "Configure" menu item disappears when all but one object type hidden
  • Schema Compare: XMLINDEX type indexes should be dropped and created, not altered
  • Schema Compare: "Convert Datatypes using DBMS Redef" option not working unless "Add/Reorder columns with DBMS Redef" also checked

Enhancements

  • Accessibility: Enhanced screen reader support in Export DDL and misc editor popup windows
  • Connections: Connection bar buttons -> Right-click -> Containers is now alphabetical
  • Single Object Compare: Added option to convert column datatypes using DBMS_Redef
  • Trace File Browser - Added an option to purge local copies of trace files

Toad Beta 25.2.141.5271, Released 27-Jan-2025
Bug Fixes

  • Export Dataset: "Filename" field painted badly in dark mode when Excel Instance format selected
  • Text Compare/Merge: "Merge" diamond icons sometimes do nothing
  • Toad for Mac: Toad hangs when clicking license agreement in Help->About

Enhancements

  • Accessibility: Enhanced screen readers support in Login, Login Edit, and Export Dataset
  • TLS 1.3 now supported
  • Schema Browser: Option added to select CLOBs through DB Links

Toad Beta 25.2.122.5205, Released 20-Jan-2025
Bug Fixes

  • AWR/Statspack Browser: Sometimes no advice on pluggable databases
  • AWR/Statspack Browser: Advice hard to see in dark mode
  • Schema Browser: Filter/Sort window doesn't remove "order by desc" correctly

Enhancements

  • Accessibility: Buttons with '...' for captions now give meaningful context to screen readers
  • Object Search: Window now opens with search text pre-selected so you can just type to replace it

Toad Beta 25.2.110.5153, Released 13-Jan-2025
Bug Fixes

  • Test/Reconnect: Dropdown arrow size inconsistent when large icons in use
  • Connections: "Cannot open file" error if wallet location specified with double-quotes and connecting in no-client mode
  • Team Coding: Able to drop table if controlled by, but not logged into VCS
  • Team Coding: Lock status incorrect after Toad is killed

Enhancements

  • Test/Reconnect: Toolbar button now launches window which lets you choose which connections to test/reconnect, so behavior is consistent with "Close connection"
  • Team Coding: Option added to make VCS errors more noticeable via popup messages

Toad Beta 25.2.100.5114, Released 6-Jan-2025
Bug Fixes

  • Wrong icons appearing in Schema Browser
  • Export DDL had wrong icon in main menu and form

Toad Beta 25.2.94.5090, Released 30-Dec-2024
Bug Fixes

  • Workspace: Not loading correctly in some environments
  • Instance Manager: Fails with localhost entries
  • Automation Designer: Connection Iterator displays connection colors incorrectly

Toad Beta 25.2.83.5058, Released 16-Dec-2024
Bug Fixes

  • Editor: Query viewer "clear inactive" button missed some
  • Editor: Query viewer showed full TNS info on no-client connections
  • Toolbars: Window bar button grouping failed on multiple same connections

Enhancements

  • Connections: Don't show "Cannot change to disconnected session" message
  • Data Compare: Full SQL can now be entered
  • FTP: Added an option to not convert timezone
  • Trace File Browser: Added ability to cancel a file load

Toad Beta 25.2.70.5014, Released 9-Dec-2024
Bug Fixes

  • Team Coding: Fixed capitalization on several messages
  • Trigger DDL: Minor bug fixes caused in last beta regarding capitalization and schema name of FOLLOWS clause
  • Alter Trigger window: "Show SQL Including Schema" option overridden by "Include SQL" checkbox

Enhancements

  • Compare Data: SQL can now be entered for comparison
  • Connection Colors: Color can now be overridden with another color if specified role is enabled for session
  • Space Manager: Added ability to specify grantees during setup
  • Automation Designer: CTRL+F can now search property values of actions

Toad Beta 25.2.61.4981, Released 2-Dec-2024
Bug Fixes

  • Generate Schema Script: "Never parse triggers for schema name" behaves backwards
  • Object Palette: Unnecessarily refreshing when multiple connections being made
  • Editor: Unable to execute/debug PL/SQL with complex arguments in 18c and newer databases
  • Misc: Toad's main title bar flickers when switching between maximized windows

Enhancements

  • Export DDL/Schema Compare/Generate Schema Script: Trigger Scripts generation is now more efficient

Toad Beta 25.2.51.4947, Released 25-Nov-2024
Bug Fixes

  • Connections: Cursor does not change to SQL Wait cursor on disconnect/reconnect
  • Editor: Navigator contents not displayed if initially unpinned
  • Fast Shutdown: Message on dialog incorrect about rollback/commit
  • Editor: ORA-06550 thrown when executing pl/sql with DBMS Output options enabled due to ALL_ARGUMENTS change in 18c and newer
  • Object Palette: Columns panel not remembering height

Enhancements

  • Automation Designer: Added right-click option for command line parameters
  • Connections: Connection error dialog didn't always render HTML content
  • Data Grids: "Order by" dialog now appears for BLOB/CLOB columns so you can at least copy column name
  • Data Grids: Right-click menu item added to copy column names to clipboard
  • Login Window: Grid now shows fewer columns by default

Toad Beta 25.2.23.4900, Released 18-Nov-2024
Bug Fixes

  • Editor - Access violation with some custom desktops
  • Accessibility - Screen readers not reading some trees/lists (TVirtualStringTree) correctly
  • Connections - can't connect with SSH in no-client mode
  • Connections - "Net: PKCS#12 Data is broken" when trying to connect in no-client mode with Oracle wallet

Toad Beta 25.2.23.4845, Released 11-Nov-2024
Bug Fixes

  • Occasional access violation when session ending
  • Schema Browser: Access violation if materialized view dropped externally while viewing in Schema Browser

Enhancements

  • Schema Browser: Now conserves GDI and User Objects resources when usage starts to get high

Toad Beta 25.2.19.4832, Released 7-Nov-2024
Bug Fixes

  • Accessibility: Many windows have been updated to be usable by keyboard only.
  • Accessibility: Tab order in many windows in Toad has been fixed.
  • Data Grids: OCI Array Buffer Size setting behaves as automatic when set to manual
  • Editor: Both (deleted) and (modified) displayed if a file was externally deleted
  • Jump Search: Incorrect images were displayed
  • Jump Search: Removed invalid entries named "Test Case Name"
  • New Version Dialog: Date conversion error thrown if date format changed after "Remind me later" clicked
  • New Version Dialog: Reappears without content after clicking "skip this version" or "Remind me later"
  • Project Manager: File treated as folder when dragging
  • Single Record View: Timestamp columns too narrow
  • SQL Firewall: "Violations" schema combobox not refreshed after violations have been generated
  • Text Compare: "Reload file and recompare" button does not reload if text didn't come from file (button hint changed)
  • Workspace: If auto-load fails, partially loaded workspace can be overwritten and contents lost

Enhancements

  • Administer Tablespaces: Added "Bigfile" column
  • Editor: Dock panel tabs are now created as needed. Editor now opens faster and now initially consumes fewer GDI and User objects
  • Editor: Indicators for externally modified/deleted files is now optional in Options -> Editor -> Display
  • Editor: Instead of showing (deleted) or (modified) for externally modified files, editor tabs will be drawn in strikeout or italics
  • Find Dialog: Now opens in the center of the the Editor from which it was launched
  • GDI and User Object usage monitoring: If Toad approaches the limit for either of these resources, an warning will be displayed
  • GUI: Buttons to move something Up/Down/Left/Right are now consistent throughout Toad.
  • Login Window: Connections can now be imported from SQL Developer JSON files
  • Options: Startup tab simplified
  • Main Menu: Reopen File now prompts before removing files which could not be found
  • Toolbars: Main and Editor toolbars have been redesigned to have fewer buttons visible by default for a less overwhelming user experience

The change log for Toad version 24.2 is here

4 Likes