Toad for Oracle 14.2 Beta

[ButtonPusher]

We are proud to announce the launch of Toad for Oracle v14.2 beta . We want to encourage you to participate in this beta program to help us to deliver a high quality product. Quest’s beta programs are your opportunity to participate in the development, direction, and testing of our products. By becoming a beta tester you have direct access to the development team and product management.

Instructions for joining the BETA program:

• The Beta requires that you are running the current commercial copy of Toad for Oracle (Non-Subscription). If you are not running v14.1 you need to go here.

• Read the Beta Agreement. Downloading the Beta code constitutes usage agreement.

• IMPORTANT: Do not install Toad Beta into your commercial Toad folder or the previous beta folder, if it exists.

• Installation: If you have Toad 14.1 Beta installed or any other previous beta, we recommend uninstalling the previous Beta(s) before installing the Toad 14.2 Beta.

Which Beta version to download?

If you have a 32-bit Oracle client currently installed in a 32-bit or 64-bit environment:

• Download/Update 32-bit Beta

If you have a 64-bit Oracle client currently installed in a 64-bit environment:

• Download/Update 64-bit Beta

See comments below for change log.

[JohnDorlon]

Toad Beta Change Log

Version 14.2.35, 12-Apr-2021

Bug Fixes

• Minor Memory leaks
• Code Analysis - Old parser version used with custom rules
• Tablespaces - Free space info showing 0 for some tablespaces
• Explain Plan - Single Record Viewer gave error if thousand separator is dot
• Schema Dropdown - Dropped down into multiple monitors in some cases
• Schema Browser - "Compile" menu items not kept in sync with main "debug" option
• Data Grids - Queries with @ characters were read-only
• Editor - Taskbar notification when Toad does not have focus and query completes

Enhancements

• Toad can now auto-reconnect and continue after disconnect error
• Compare Multiple Tables, Compare Data - Now more efficient comparing LOBs
• Compare Multiple Tables, Compare Data - Lobs can now be optionally compared only by length, which is much faster but not 100% accurate

Version 14.2.17.957, 31-Mar-2021

Bug Fixes

• Alter Table - "Loading Constraints" message stuck on statusbar
• Alter Tablespace - MAXSIZE 32T specified instead of MAXSIZE UNLIMITED
• Alter Datafile - Extra SQL given
• Automation Designer - Access Violation when deleting apps
• Connections - Connecting from main toolbar does not allow password entry
• Compare Multiple Tables - ORA-00972 if CLOB columns nearing 30 chars
• Copy Table Data - Too many prompts when error occurs
• Create Table - Data conversion error if Extent size blanked out
• Data Grids - OCI Array Auto/Manual setting is reversed
• Misc - Memory leaks in Editor and a few other places
• Misc - Blank dock panels after switching from SDI to MDI
• Editor - Backup occurring even when not changed since last backup
• Editor - Complex SQL involving XMLTYPE causes ORA- errors due to bad internal SQL
• Editor - Desktop including all tabs after restoring workspace
• Editor - Freeze when debugging triggers
• Editor - Grid columns too narrow if grid panel hidden
• Editor - Script execution counts items incorrectly
• Editor - Shortcuts not following settings in options window
• Editor - Slow to change connection after loading large script
• Export Dataset - Missing double-quotes on some table names
• Export Dataset - Insert Statement lines too long for SQL*Plus
• Login window - Minor inconsistencies
• Login window - TNSPing not working
• Options - Left hand side too narrow
• Schema Browser - Edition scripts missing grants
• Schema Browser - PL/SQL objects missing column header on left hand side
• Schema Browser - Tablespace info missing in LHS after refresh RHS
• Session Browser - Splitter position wrong when window opens
• Team Coding - Excessive refresh prompts when opening package in editor
• Team Coding - "Check in all" not enabled
• Undo Advisor - Privileges dialog not showing if DBA role is missing
• Update downloader - prior update not always cleared from cache
• utPLSQL - GUI not updating correctly when exceptions enabled and disabled
• utPLSQL - Create Unit Test: "not contain" matcher missing from the list of available matchers
• utPLSQL - Create Unit Test: Incorrect suite DDL on the default values for "All Tests Setup/Teardown" and "Test Setup/Teardown"
• utPLSQL - Add Unit Test: Rollback(auto) automatically added
• Workspaces - Editor dock layout settings lost after loading workspace

Enhancements

• Automation Designer - Added option to not scan for variables so ampersands in file path can be ignored
• Automation Designer - Connections on Apps/Actions can now be changed
• CLOB Popup Editor - SET NULL is now used to delete CLOB data
• Compare Data - Added ability to save/reload settings
• Connections - "No valid Oracle client" message is now more helpful
• Schema Browser - Work around Oracle error with DBA_JOBS.TOTAL_TIME in 19c
• Toolbars - User will be prompted for toolbar reset if toolbars changed since prior version
• Workspaces - Now includes Quick Filter and active RHS tab
• Workspaces - Editors of failed connections are now loaded w/o connection

[JohnDorlon]

Changes in Version 14.1, Officially Released 30-Mar-2021. Get it here.

Scroll to the top of this page to get the 14.2 beta.

Bug Fixes

• Actions - Access Violation after internal action vault trims off old actions
• ADDM Report - Error - '' is not a valid floating point integer
• Alter Datafile - Backspace key not working in Size field
• Alter Datafile - Can't enter decimal values for datafile size
• Alter Table - Access Violation on OK, then Cancel
• Alter Table - External table props are read-only
• Alter Table - Generate Data should not be visible with base Toad key
• Analyze Objects - Error if attempt to close window while it is busy
• Automation Designer - Errors running apps that quickly connect and disconnect
• Automation Designer - Selection/Paste problems
• AWR Browser - Bad data and error in "Overall Phys Reads and Writes" chart
• BFile viewer - Opens only once
• Code Analysis - Example code not always showing flagged rules in options
• Code Analysis - Rule 6405: Dramatic performance increase
• Code Analysis - Rule 6405: Variables declared at top of package body yielding false positives.
• Connection Bar - Lost connection icon not showing in some cases
• Connection Export/Import - "Include passwords" not always enabled
• Connections - 64 bit now able to connect with DynaTrace installed
• Connections - Access Violation on End Connection if grid in dialog is filtered
• Connections - Misc errors when no Oracle client installed
• Connections - Misc errors when SESSIONS_PER_USER=1 in profile.
• Connections - Password box sometimes disabled on export/import connections
• Connections - Toad was sometimes prompting for reconnect when connection ending
• Copy Table Data - Occasional errors when opening
• Create Constraint - Wrong SQL if adding constraint to view.
• Create Trigger - Template error in create trigger window
• Data Grids - AV if connection lost while editing data or scrolling grid
• Data Grids - Error thrown if invalid values in grid filter
• Data Grids - INTEGER or SMALLINT in user-defined types causing crash
• Data Grids - Double-clicking in multiple Editor grids caused errors, lockup
• Data Grids - Error on CTRL+Insert with no active connection
• Data Grids - Insert cancelled after invalid date value entered
• Data Grids - Odd behavior in nested table popup dialog
• Data Grids - Pasting into read-only grid yielded error
• Data Grids - Slow performance of "create insert for selected rows"
• Data Grids - Unable to edit grid data when schema contains dot
• Data Import - Bad data was causing crash (instead of "nice" error)
• Data Import - Can't run from Automation Designer w/o GUI after showing properties
• Data Import - Import from clipboard, List Index Out of Bounds error
• Database Browser - Incorrect Drag/Drop behavior with list of databases
• Describe - Blank describe window left open if object not found due to lack of privs
• Dialog Boxes - Sometimes appear on wrong monitor
• Editor - Access Violation after attempt to add breakpoint where on a non-breakpoint line
• Editor - Always saves files as ANSI after splitting file
• Editor - Can't close Editor if connection lost during debugging
• Editor - Code Insight hang/errors fixed
• Editor - Connection gets out of sync switching connections after connection lost
• Editor - CTRL+P is shortcut for print even if you change it to something else
• Editor - Describe through DB Link picking wrong schema
• Editor - Error if run script on disconnected session
• Editor - Not backing up files after recovery
• Editor - Occasional hangs while using spacebar to replace selected text
• Editor - Poor performance with large file and Sensitive Data Awareness enabled
• Editor - Prompting for reconnect on shutdown
• Editor - Prompting twice if edited files deleted externally
• Editor - Query result showing junk data after literals
• Editor - Reconnect prompt not always shown after connection lost
• Editor - Script Grid numbers got skipped by empty result sets
• Editor - SQL running in wrong connection
• Editor - Toad freeze/"not responding" if selected text is collapsed by code folding
• Editor - Toad hangs temporarily if "Run as Script" and then cancel
• Explain Plan - Corrupt user settings files caused crash
• Explain Plan - INST_ID Invalid Identifier in RAC (Beta only)
• Export Dataset - Export to Excel broke pivot tables in existing file
• Export Dataset - Null fields excluded in delimited text format in some cases
• Export DDL - "Add to refresh group" option not remembered
• Generate Schema Script - Filtering incorrect when filtering by triggers and views
• HTML DB Doc Generator - Roles excluding granted object privileges
• HTML Schema Docs - "Is Referenced By" should be "References" in output
• HTML Schema Docs - Exclusion file missing line feeds
• HTML Schema Docs - Long object names not supported
• Login window - Custom fields missing from grid after changing view style
• Master-Detail Browser - Error after cancelled "add detail"
• Misc windows - Invalid output folders not handled gracefully
• Object Palette - Display messed up if window sized too small
• Object Search - Not able to search for partition name
• Object Search - Wrong popup menu items in some cases
• PL/SQL Template Files - Access Violation if file settings wrong
• Popup Text Editor - Closes immediately if opened on last row in grid
• Project Manager - Error on CTRL+Click in empty space
• QSR: EXTERNAL connection not allowed
• QSR: Favorite Folders not being retained after restart
• Query Builder - Data grid edit errors not handled well
• Query Builder - error during import of DML files from older Toad version
• Rebuild Multiple Objects - Access Violation when closing quickly after cancel
• Rebuild Table - If table has foregin key constraint, [NO]Validate was excluded.
• Rename Datafile - Can't rename datafile in non-Enterprise edition 12c and newer
• Schema Browser - "Argument out of range" error on referential tab
• Schema Browser - Access Violation if drop package from local subprogram node
• Schema Browser - Access Violation in Packages on right-arrow key and nothing selected
• Schema Browser - Alter CDB Resource Plan not working correctly
• Schema Browser - Column Listing: Team Coding columns missing
• Schema Browser - Duplicate Row in grid now working if table has identity column
• Schema Browser - Error if attempt to close window during refresh
• Schema Browser - Error if memory sorting enabled, then "create insert for selected rows"
• Schema Browser - Error on CTRL-Click in SB-Favorites-Package RHS
• Schema Browser - Invalid Objects not refreshed after compile in treeview mode
• Schema Browser - Missing information on objects with object_id greater than 2147483648
• Schema Browser - Package Body w/o spec caused errors in treeview mode
• Schema Browser - Sequence Cache Size listed under "Increment By" in object listing
• Schema Browser - Tables, Data tab - Toad crashed on UNDEFINED datatype
• Schema Browser - Tablespaces - Error thrown on "Recover Tablespace"
• Schema Browser - Treeview, Refresh all not returning to prior selected object
• Schema Compare - Byte/Char differences not always highlighted in side-by-side viewer
• Script Generation - Job Class scripts missing some values for logging level
• Script Runner - Can't set variables on declaration line
• SDI Mode - CTRL+Tab, CTRL+Shift+Tab not always working to toggle between Toad windows
• Sensitive Data - Actions not saved properly
• Session Browser - RAC not detected on 10g
• Set Role/Edition - Not following settings when role/edition cannot be set
• Single Object Compare - Multiselect broken and final ')' missing
• Single Object Compare - Roles excluding granted object privileges
• SQL Optimizer - Possible error if comma as decimal separatator
• SQLNet Editor - Error thrown if comments present after numeric field value
• SQLNet Editor - Not closing on ESC
• Startup - Document Recovery window can be slow with large files
• Syntax Parser - ALTER TABLE … MODIFY PARTITION … UPDATE INDEXES parse error.
• Syntax Parser - FETCH FIRST inside a WHERE EXISTS query was not parsed.
• Syntax Parser - Keyword ILM used as a as table reference alias was not parsed.
• Syntax Parser - parsing of EXTRACT function with conditional compilation directives produced false syntax errors
• Syntax Parser - Query with inline external table: parse error on table alias
• Syntax Parser - The COLLATE clause was not always supported in SELECT and DDL statements
• Tablespaces - Fast double-clicking (to alter tablespace) caused error
• Team Coding - Can't navigate LHS of the TC Config screen with keyboard
• Team Coding - Prompt for checkin of wrong object on editor close
• Team Coding - SVN Config "Cannot focus disabled or invisible window" error
• Team Coding - VCS Errors shown in wrong error dialog
• Team Coding Manager - Blank if not pinned before connecting to database
• Team Coding Manager - Keyboard navigation not enabling toolbar buttons
• Text Compare - Access violation if closed while it is comparing
• TNS Error Dialog - Added message for unsupported client on Windows 7
• TNSNames, SQLNet, LDAP Editors - Nicer error now displayed if file cannot be saved
• Toad - Z-order problems from Login and Describe windows
• VCS - Materialized Views don't get versioned in the VCS when recreated
• VCS Debug Viewer - Error with custom time formats

Enhancements

• Connection Colors - Now visible under "Window" menu
• Connection Error Dialog - now checks for an invalid OraAccess.XML
• Data Compare - Allow data comparison to be controlled manually
• Data Compare - Column names can now be manually mapped when they don't match
• Data Grids - "Huge" text removed from BLOB/CLOB caption, "Null" text added
• Data Grids - Single Column Export now available in Automation Designer
• Data Import - Can now resume after lost connection
• Editor - Added option for ORA_NCHAR_LITERAL_REPLACE
• Editor - Code Insight now uses main DB session (optional)
• Explain Plan - Adaptive Plans now supported in tree mode
• Options - Toad now verifies that Temp folder is accessible
• Schema Browser - Tablespaces, space tab, added autoextend info
• Session Browser - Added CLIENT_DRIVER columns
• Session Browser - Added tolerance for missing fields from V$SESSION
• Workspaces - All connections are now made before any windows are opened. Loading of workspace continues after failed login.