Toad for Oracle 16.3.231.2085 is now available

Toad for Oracle
1

We are pleased to announce the GA of our new version: Toad for Oracle 16.3.231.2085.

This version of Toad for Oracle Subscription includes new features like minimap and faster start-up time. Check-out the new minimap in Editor to see a high-level overview of your source code and other new enhancements. Discover DBA Plus Subscription Edition which offers even more features and functionality and includes, bundled for the first time, our excellent Code Tester for Oracle product for advanced PL/SQL unit testing.

Choose from the best subscription offerings of Toad for Oracle Base, Toad for Oracle Professional, Toad for Oracle Professional DB Admin, Toad for Oracle Xpert Plus and, newly added, Toad for Oracle Developer Plus and Toad for Oracle DBA Plus Editions now for an affordable annual price.

To learn more about these subscription offerings, visit https://www.toadworld.com/products/toad-for-oracle.

For all of our existing customers, Toad for Oracle 16.3.231.2085 contains many new fixes and enhancements. (Many of which have been suggested by our Toad World members—Thank you all!)

For more information on these and other stability and performance improvements, view the release notes at https://support.quest.com/technical-documents/toad-for-oracle/release-notes.

To download this latest release, visit https://support.quest.com/toad-for-oracle/download-new-releases.

To learn more about Toad for Oracle, visit https://www.quest.com/products/toad-for-oracle.

Bug Fixes

  • Alert Log Viewer: Multiple date formats in same file not handled well
  • Alter Table: Toad crashes if table has hundreds of constraints
  • Auto Optimize SQL:
    • "Invalid password" given for globally authenticated users
    • Inaccurate error message when no oracle clients are installed
  • Automation Designer:
    • Can't set up archive action with Folder Iterator
    • CTRL+C non-functional in some areas
    • DBMS_Output not available from script actions
    • Drag/drop of actions sometimes wrongly allowed
    • Non-responsive when opened not maximized
    • Order of actions doesn't stick after drag-drop
  • AWR/Statspack Browser:
    • Can't sort custom grids
    • SQL Error when creating snapshots in 10gR2
    • Not scrolling to checked snapshots when window opens
    • "Check last 24 hours of snapshots" not working when sorted descending
    • Repeated error message when no snapshots selected
  • Code Snippets: Access Violation after Open, then Cancel Toad options window
  • Color Schemes:
    • "Calypso" theme did not have enough contrast for selected cells in grid
    • "Search Match" editor color hard to see
    • Active connection color on window bar buttons difficult to see
    • Current step not easily identifiable in wizards
    • Editor background color didn't update when color scheme changed
    • Editor tab colors not consistent with other tabs in Toad
    • File Compare: colors too bright in dark mode
    • Glitches in Export File Browser and other misc. windows
    • Grid lines difficult to see in some themes
    • Hex Editor: Colors too bright in dark mode
    • Increased contrast on window/connection bar buttons in dark modes
    • Lilac Night theme lost on update from 16.1
    • Some docked panels missing edges
    • Toolbar dropdowns checkboxes not always visible
  • Compare Data:
    • Error when comparing timestamp to date fields
    • Summary report causes error in run after compare was cancelled
  • Connections:
    • "Invalid Release" error if Oracle version number has more than 5 digits
    • Connection error dialog not displayed in no-client mode
    • Missing primary LDAP port, but supplied SSL port prevented connection
  • Create Sequence: Missing field validation leading to errors
  • Create/Alter Scheduler Job: "Parallel Instances" attribute missing
  • Create/Alter Tablespace:
    • Maxsize 0 added to SQL instead of maxsize unlimited
    • File size units changing when changing max size to unlimited
  • Create View/Materialized View: SQL error if semicolons included in SQL
  • Data Grid:
    • Access Violation if paste into read-only grid
    • ANYDATA causes access violation if it contains certain data types
    • Can't paste into newly inserted row
    • Can't easily re-show a fixed, then hidden column
    • CTRL+C including column headers. CTRL+Ins should do that.
    • Errors and ugly styling if settings file is lost
    • Find Next/Prior not working in some grids
    • Lost connection not handled well when cached editing enabled
    • Mouse wheel scrolling wonky after memory sorting enabled
    • Mouse-wheel scrolling causes grouped grid to expand
    • Multi-cell paste was throwing an error if grid was grouped
    • Multiline data only pastes first line
    • Paste error after Duplicate Row
    • Summary panel badly placed, scrolls out of view
    • Sorting not working if "Include column ID" option checked
  • Data Pump, ASM, and ADDM Report: Errors if opened after lost connection
  • Database Browser:
    • Connection not found after changing from Redo Logs tab
    • Invalid connection attempt when no saved login info present
    • Toolbar button behavior inconsistent if no connection present
  • Database Monitor: AV after lost connection
  • DBMS Output:
    • Blank lines sometimes not displayed
    • Tabs not trimmed after 10th line
  • Editor:
    • "File has been changed" dialog stacks if not answered
    • "Rollback to savepoint" rolling all the way back
    • Access Violation on CTRL+C in grid w/o running a query first
    • Blue dot locations wrong for script debugging
    • Can't connect with external authentication using CONNECT command
    • Caret position lost in primary memo after formatting from secondary
    • Code Analysis rule tip dialog is blank
    • Code Insight Access Violation
    • Code Insight goes blank in some circumstances
    • Code Insight inserting join suggestion incorrectly
    • Code Insight not popping up when caret within a function call
    • DBMS Output tab shows (disabled) when it's in Auto mode
    • Delay before execution of long script
    • Excessive "Not connected" errors if not connected (duh) and UTPLSQL installed
    • File modified prompt displayed too frequently for split packages
    • Find Dialog - "Not found, retry" sometimes not shown
    • Find dialog - "Whole Words" becoming checked
    • Formatting loses cursor position in split Editor mode
    • Hex Editor throws error if file is locked
    • Navigator splitter getting misplaced after Shift+F2
    • Not passing protocol to QSR with Direct Connect
    • ORA-06502 from DBMS_Output
    • Rare Toad crash after splitter movement
    • Run in QSR/SQL*Plus - not setting current schema
    • Shift+F2 (full screen grid) not working if F2 (full screen editor) used first
    • SQL Desktop panels disappear after rearranging tabs
  • Export Dataset:
    • "Invalid Pointer Operation" after cancel export to Excel File format
    • Bogus error when unknown variable used for path
    • Current_schema not always set
    • SQL longer than 32K not being exported to Excel.
    • Timestamps treated as dates and not showing 12:00:00 in XML format
    • Export DDL: DBMS_IJOB being used when user does not have privileges
  • Export DDL:
    • Materialized View Script missing "Using Untrusted Constraint" before first refresh
    • Not Null constraints missing from table scripts when IOTs included
  • Export File Browser:
    • Dates not shown correctly on data tab
    • Default folder for script creation was Toad's install folder
    • Freeze/crash on data tab with some files
  • Export Tablespace: Access violation after cancel, then re-open
  • Generate Database Script: Roles not sorting for dependency order
  • HTML Displays: Error: "Microsoft Edge can't read and write to data directory"
  • Import Connections: Skips existing connections without notice. No option to overwrite.
  • Import Table Data: Missing field validation leading to errors
  • Instance Manager: Minor GUI improvements
  • JDWP Configuration: Missing field validation leading to errors
  • Licensing: Wrong message on startup in some cases
  • Login window:
    • Last connection not always remembered
    • If grouped, random group expands after record deletion
    • Toad goes to background after closing login window
  • Main Toolbar glitchy on shutdown
  • Master Detail Browser:
    • Edited SQL lost after filter error
    • Label too short for long table names
  • Misc windows: Text cut off in some labels/checkboxes (due to font change last version)
  • No-client connections: "Change Password" dialog not appearing for expired passwords
  • Object Palette: Actions Console has been missing for several versions
  • Object Search:
    • List Index Out of Bounds error in some cases
    • Results toolbar draggable
  • Options:
    • Files -> General: New File Type not saved
    • Unable to specify space for thousand separator
  • QSR: Copy/Paste behavior not right with respect to row headers
  • Scheduled Task Wizard:
    • Colors bad in dark mode
    • Text cut off
  • Schema Browser:
    • Analytic Views and Hierarchies data tabs not supporting fast mouse wheel
    • AV after dropping objects
    • Color scheme painting problems on RHS deps tabs
    • Excessive scrolling in data tab on Shift+PgDown to select rows
    • Function Based Indexes not displayed properly in SubObjects
    • Icon legend glitchy when opening
    • MV "Used By" tab blank
    • Object counts can be wrong after dropping in treeview mode
    • RHS blank if opened with only one item in LHS list
    • SB Icon Legend has no info about colors in treeview
    • Selected item scrolled out of view after filter change
    • SQL error when expanding subobjects on 21c
    • Subobjects - FK Constraint columns not colored correctly
    • Subobjects can cause toolbar actions to have unexpected behavior
    • Tables-RHS-Triggers getting out of sync
    • Wrong popup menu on multiselect after using subobjects
  • Schema Compare:
    • AV when previewing result diffs
    • Bad SQL when index and constraint renamed
    • Bad SQL when moving LOBs
    • Result diff preview blank
    • Filter intolerant of parenthesis with "In" or "Not In"
    • Parameters listed backwards on RHS Arguments tab
    • Sync script created public synonyms when it should not
  • Script Manager: Does not attempt to create output folder
  • Session Browser: "TOAD_SESSBROWFILTERS.ini is locked by another process" error
  • Single Object Compare: Object Type dropdown causes a slow query
  • SQL Recall: Bad handling of invalid regex filter
  • Team Coding:
    • Crash caused by extra slash in SVN repo URL
    • Errors after object with a double-quoted name created
    • Excessive queries on startup
    • Minor GUI problems in source control config dialogs
    • SVN repository URL with trailing slash caused stack overflow
  • Toolbars: "NewBarItemsIniFileName not specified" error
  • Trace File Browser: Multi-file trace not handled
  • TSR: Execution error when calling from a different folder
  • Variables dialog: getting on top of other apps
  • Window Pop Out: Connection info disappears from window title when popped out
  • Workspaces: Toad crash when loading some workspaces

Enhancements

  • About: Added link to copy version info to clipboard
  • Application Logging: Options -> General: All application logging can now be enabled here
  • Automation Designer:
    • Actions are now better organized on tabs
    • Added ability to cancel running actions
    • Added Run Report action to run report from Reports Manager
    • Added sample apps to demonstrate iterators and passing variables from one action to another
    • Added Single Column Import action
    • Allow move of actions with CTRL+up/down arrow
    • Progress dialog is now optional for Execute Script actions
  • AWR/Statspack Browser:
    • "New Chart" wizard updated to a newer look
    • Window now opens faster
  • Code Analysis: Results now limited to 1000 rule violations
  • Color schemes:
    • Added several new color schemes
    • Editor Gutter colors improved
    • Options -> Color Schemes loads faster
    • Switching windows within Toad is faster
  • Connections:
    • Added "Retry" button to connection error dialog
    • Added a way to restore connections already known to be lost (that is, the ones with the "disconnected" icon on the connection bar. Right-click a connection bar button to reconnect. There is also a new menu item under the "Session" menu, but you'll have to reset toolbars or use "customize" to make it visible.
    • SEC_USER_AUDIT_ACTION_BANNER and SEC_USER_UNAUTHORIZED_ACCESS_BANNER messages now displayed when connection is made, if configured in server side SQLNet.ora
  • Copy Data to Another Schema:
    • New "Save settings as default" option
    • New option to prevent "Table is empty" message"
    • Added Indexes/Constraints/Except Foreign Key options
    • Added rt-click "uncheck all"
  • Copy User Settings:
    • Renamed to "Manage User Settings"
    • Added automatic backup of Toad settings
    • Added ability to recover some settings from backup when resetting
  • Create/Alter Materialized View: Added a way to set/clear refresh group
  • Data Grids:
    • Added ability to paste a value into multiple cells
    • Added ability to sort by multiple columns (Use Shift+Click)
    • Improved popup menu -> Appearance
  • Editor:
    • Added parameter numbers (optionally) to navigator
    • Added "Resolve Constants" feature (right-click -> Refactor)
    • Added an option to highlight dependent tables/views/mviews which exist in other schemas. Options -> Editor -> Display. Object names are loaded for colorization when the package/proc/func that uses them is loaded or compiled (without errors) in the editor.
    • Added local references to Navigator
    • Added option to not sort parameters in navigator
    • Added options for parenthesis highlighting style (Options|Editor|Display)
    • Added options to reload modified files from all tabs at once
    • Added support for ligature fonts
    • Auto-replace now optional in strings and comments
    • Context menu is now customizable
    • Don't prompt to save an empty tab which was not loaded from file
    • Enhanced bracket highlighting (see Options -> Editor -> Display)
    • Made look of splitters consistent with other splitters in Toad
    • Mini-map feature added.
    • Multiline tabs don't move after selection (see Options -> General)
    • Reload File/Reload DB Object toolbar buttons moved to a more obvious place and and given more consistent/meaningful icons.
    • SQL Recall now includes semicolon when sending to editor
    • SQL Recall workflow improved and options centralized into a dialog
    • Team Coding toolbar no longer visible by default unless TC is installed.
    • UTPLSQL toolbar no longer visible by default unless UTPLSQL is installed.
  • Export Dataset:
    • Added "Retry" option if excel file in use
    • Added an "Allow formulas" option (for non-numeric columns)
    • Added GZip and 7-Zip compression formats
    • Cancels faster when "Display all results in grid" enabled and unchecked
  • Export DDL:
    • Added option to exclude "Bequeath" for views
    • New option to export into object type subfolders
  • External Tools: Added macro for Active Editor Folder
  • Find in Files: Now also can find/replace in Editor tabs
  • Flat File Export: Added line option for feed style
  • HTML Schema Doc Generator: Updated to a newer look
  • Import Table Data: Updated to a newer look
  • LDAP:
    • Right-click -> Test LDAP added to to login window's database dropdown.
    • Also, Options -> General -> Enable Logging now includes LDAP logging
  • Log Miner: Updated to a newer look
  • Login Window:
    • "Edit" now allows you to update passwords for multiple logins
    • "Test" now allows you to update passwords
    • Added ability to edit Custom Columns of multiple logins at once
    • Export Connections - Removed obnoxious password hint
    • New option to create multiple login records from tnsnames entries
    • Tabbed by User/Server view styles now include a filter
  • Master-Detail Browser:
    • Now has Save/Save As buttons
    • Refresh now enabled after connection lost
    • Grid heights no longer reset after column sort
    • "Find missing columns" feature added (under "add missing columns")
    • Form context info added
  • Recover Documents:
    • Added options to recover automatically, remove all, recover all
    • "Make connection" checkbox is now functional
    • "Reconnect All" button now shown when clicked "Recover" w/o first having selected something to recover.
  • Report Manager - use of parameters is now more clear
  • Schema Browser
    • Added parameter numbers to Procs -> RHS -> Arguments
    • Added support for sharded queues
    • Added ability to change colors in Treeview mode (from SB Icon Legend)
    • DBA_LMT_FREE_SPACE now an option on Tablepsace RHS Files tab
    • Filter/Sort dialog - auto-add quotes for in/not in
    • Filter/Sort dialog - make save size/pos optional
    • Flattened out toolbars
    • Multi tab-rows: Now follows the "Lock tabs in place" option
    • Package declaration expansion is now optional (Options -> Schema Browser -> LHS)
    • Quick filter now supports regular expressions
  • Schema Compare: Added an overall summary file for multiple comparisons
  • Team Coding:
    • A warning is now displayed if merging a table will cause data loss
    • Any out-of-sync Object IDs will now get remapped when user goes to TC Config window and clicks OK
  • Toad.ini: Added a shortcut to edit with notepad: Shift+Click on the Toad Options toolbar button
  • Toolbars: Improved look of toolbars in misc windows
  • TSR: Added no-client support
  • Upper/Lowercase shortcuts: Now apply to all edit controls
  • View/Edit Query dialog: Now accepts drag/drop of columns from describe dialog
  • Window Menu: Added option to list all Editor tabs (Options -> Toolbars/Menus -> Toolbars
  • Window Toolbar: You can now right-click the window toolbar's buttons to rename windows

The change log for Toad version 16.2 is here

2 Likes