We are pleased to announce the GA of our new version: Toad for Oracle 14.1.120.
This version, in addition to Toad for Oracle Base Edition, introduces two new subscription offerings of Toad for Oracle Professional and Toad for Oracle Professional DB Admin for an affordable annual price. To learn more about this subscription offering you can visit https://support.quest.com/toad-for-oracle.
For all of our existing customers, Toad for Oracle 14.1.120 contains many new fixes and enhancements (many of which have been suggested by our Toad World members—Thank you all!)
Release Notes:
https://support.quest.com/technical-documents/toad-for-oracle/14.1/release-notes
Download:
https://support.quest.com/toad-for-oracle.
Change Log:
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.