Toad for Oracle 13.1 - Release Notes

Resolved Issues

Resolved issues

The following is a list of issues addressed and enhancements implemented in this release of Toad for Oracle.

Toad for Oracle

The following list of resolved issues includes issues received from the Toad for Oracle forum and Toad Beta users.

Issue ID Link to Forum Post Resolved Issue
TOR-1052   Creating a new trigger gets TC out of sync
TOR-1158   Can't delete a folder after Toad has loaded a file from it
TOR-1208 link Code Template window size does not adjust as needed
TOR-1262   Script engine fails to handle parameters properly
TOR-1264 link Asterisk in Editor tab name remains when it should not
TOR-1335 link TC doesn't auto-add constraints/indexes to TC when run from the Editor
TOR-1393   Code Assist does not bring up filtered column list for more complicated queries (APPS)
TOR-1534 link "Show recyclebin" command does not work in Editor
TOR-1745 link Navigator panel closes unexpectedly
TOR-1976 link On script execution, <F5>, the reported statement being executed is off by one.
TOR-1996   TIMESTAMP(0) columns have a unecessary period (.)
TOR-2230 link Code Insight list filtering slow against a large schema (APPS)
TOR-2270   If a nested table has timestamps and intervals, the nested table popup throws an access violation.
TOR-2427   Enhancement: You can now specify whether or not the ESC key cancels a query when the threaded queries feature is enabled in Options | Oracle | Transactions. The specified behavior applies in the Editor and Schema Browser Data tab.
TOR-2479 link ORA-01756 executing Q-Quote
TOR-2589 link Data Generation generates incorrect SQL when using foreign columns
TOR-2613 link When "Use lower case object names from select windows" in Options | Editor | Behavior is selected, the behavior is now applied to inline parameter assistance.
TOR-2624   Different NLS_SORT setting causes Data Compare to lock up
TOR-2626   Triggers from other schemas are not shown on Tables>RHS Triggers.
TOR-2646 link Schema Browser Treeview scrolling too slowly
TOR-2656 link Switching between packages slower in 13.0 than 12.12
TOR-2663   Export Dataset not switching to current schema
TOR-2664 link Possible attempt to use wrong connection for EP in Session Browser
TOR-2672 link Code Template improperly prompting for variable
TOR-2686   Saving package with dot in name can cut off part of name
TOR-2688 link AV in Schema Browser Treeview after compile
TOR-2690 link Policies sometimes excluded from Generate Schema Script
TOR-2692   "Path not found" exception raised preventing startup
TOR-2695 link Toad extension for 'Grant' didn't work
TOR-2708   Enhancement: Add ability to compare cell values
TOR-2730 link1, link2 Enhancement: In the Export Dataset action, you can now specify a source file for your SQL query.
TOR-2744   Can't compare PUBLIC schema
TOR-2749   Generate Schema Script creates different output paths in Toad 13 than prior versions
TOR-2750   Cannot determine which schemas are not included
TOR-2751 link Missing SQL Wait cursor on script generation
TOR-2753 link Multiple "wake up" prompts on multiple sleep cycles
TOR-2755   Enhancement: Add option to ignore constraint validity in Schema Compare
TOR-2769   Improve query to load users
TOR-2777 link Schema Browser Constraint Script wrong for not null constraints
TOR-2784   Windows bar not being ordered under connection
TOR-2790   Enhancement: Record Count for Query Builder results grid now displays the total record count rather than just the number of records fetched
TOR-2816 link Beta update dialogs show off-screen in SDI mode
TOR-2821 link Partial painting when Triggers selected in "Load Database Object" window
TOR-2830   Incorrect Code Analysis Validation on Package Specifications
TOR-2860 link AV encountered after sleep-wake cycle and then reconnecting.
TOR-2889   Team Coding incorrectly report fail conditions when CA settings are low
TOR-2907 link Loading workspaces causes window list to be out of order
TOR-2908 link Trace File Browser not handling multiple deadlocks
TOR-2912   ORA-29275 in Session Browser
TOR-2916   File Save and Save As menu items disabled in Query Builder and ERD
TOR-2917   File entries corrupted in the "File | Reopen File" menu.
TOR-2918   If you double-click a column in the Describe dialog (F4) it is not sent to Editor, as the user expects.
TOR-2919 link Add copy to clipboard and improve text display of error dialog
TOR-2942   Workspaces don't import from 12.12
TOR-2977 link Stream read error from CLOB columns
TOR-2981 link Missing "By default" in identity columns
TOR-3048 link LISTAGG function gets rewritten in Query Builder
TOR-532   Drag-n-Drop not working from Editor to Project Manager
TOR-885   Splitting in chunks doesn't work with saved workspaces.

 

Known Issues

Known issues

The following is a list of issues, including those attributed to third-party products, known to exist in this release line at the time of the current release.

General known issues

Known Issue Issue ID
Toad's help cannot be opened from an installation path that contains Unicode characters. 72966

If you check "Indexes" on the Scripts tab for snapshots, then the primary key for the snapshot will be included in the script, even though the CREATE MATERIALIZED VIEW statement implicitly creates this primary key.

Toad currently does not differentiate between indexes created explicitly on the snapshot and indexes created automatically when the snapshot is created.

Workaround: If you are running the generated script to recreate the snapshot, then you can simply ignore the error that occurs when the script tries to recreate the primary key index for the snapshot. If you do not normally create indexes on snapshots, then you can uncheck "Indexes" when generating the snapshot script.

N/A

If you use 11g Oracle ODP.NET client or any other client that does not have the oci.dll in the BIN directory, Toad has the following problems:

  1. Client shows as invalid
  2. Client version is not detected
  3. As a result of #2, columns of the following datatypes are not shown in the Schema Browser table data: CLOB, BLOB, NCLOB, XMLTYPE, TIMESTAMP, INTERVAL, BINARY_DOUBLE, and BINARY_FLOAT
N/A

Debugger

If there is an exception during debugging on a 10Gr2 or greater database, REFCURSOR output and DBMS output will not be available when debugging is completed. This is due to the target session not being available.

Workaround: To see REFCURSOR output and DBMS output, execute the procedure without the debugger.

N/A

Connections

While Toad supports LDAP connectivity, some features of Toad depend on tnsnames.ora file to operate correctly, such as Toad Script Runner (TSR).

N/A

Schema Browser

Sometimes after pressing "Compile invalid objects", you may get ORA-20000, ORA-06512, or ORA-06512 errors. This could mean that you do not have the privileges to compile the object, but it also happens when the schema contains a package body that does not have an associated spec.

Workaround: Look in the schema that you are trying to compile to see whether there are any orphan package bodies. If it is your own schema, then do:select * from user_objects o1 where object_type = ''PACKAGE BODY'' and not exists (select ''x'' from user_objects o2 where o2.object_name = o1.object_name and o2.object_type = ''PACKAGE'') Then drop any orphan package bodies that are found.

N/A

Virtualization

An access violation error may display when you close Toad in a Citrix XenApp environment.

76354

Import/Export

Constraint scripts from Export DDL do not contain the "using index" or "tablespace" clause.

59228

Data Modeler:

  • Generation of HTML reports of large diagrams may fail during generation of an image of the ER Diagram.
  • Comparison of large models may consume too much memory.
N/A

Data Grids known issues

Known Issue Issue ID

You may receive an "ORA-00902 invalid datatype" error when editing an object, nested table, or varray data if you have redefined the data type for that data during the current session.

Workaround: If you redefine an object type, nested table, or varray and then need to edit data in a table based on that type, end your current connection and begin a new one.

N/A

Full table data is not displaying in the live data grid (results from F9) if the data contains "zero" characers (ACII 0). In this case, all data after the zero character will not show in the grid.

Workaround: Double click on the data cell in the data grid to view full contents of data in a popup editor.

 

Code Analysis known issues

Known Issue Issue ID
Saving results to a database: When dealing with nested procedures, Code Analysis can only insert run data from procs one level deep. N/A

Saving PL/SQL results to a database may fail or save invalid data to the database for invalid PL/SQL objects.

Workaround: To ensure PL/SQL results are saved to the database correctly, verify the validity of all objects before running Code Analysis.

N/A

Editor known issues

Known Issue Issue ID

Toad errors when you query on a field of Oracle collection types.

Workaround: Execute using SQL*Plus.

64373

When spooling to an unpinned output window, the window becomes unresponsive and errors are given when Toad is closed ("Canvas does not allow drawing").

Workaround: Keep the output window pinned.

68523

If you use a non fixed-width font, the results are misaligned in the of Script Output tab in Editor after executing a SQL script.

Workaround: Go to Options | Scripts and select a fixed-width font for script output.

62234

Session Browser known issues

Known Issue Issue ID
The Program name in the Session Browser may be blank or may be the full path to the executable instead of just the executable name. This depends on the Oracle client, not on Toad. N/A

In RAC databases, version 10.1.0.3 (and possibly other 10.1 versions), the query used to populate the "Current Statement" in the Session Browser fails with the following error: Runtime error occurred: 12801 (ORA-12801: error signaled in parallel query server PZ99, instance <instance name> ORA-01008: not all variables bound) This problem does not occur in Non-RAC environments.

Workaround: Clear the "Use RAC Views" checkbox, and log into the appropriate instance of the database, if necessary.

N/A

Team Coding known issues

Known Issue Issue ID

Creating a new revision or attempting to force a check-in to Visual Studio Team Services may result in a "404: Not Found" error. The current version of Team Foundation Server used by Visual Studio Team Services compares the source being uploaded with the source already in the repository. If the source has not changed, it may incorrectly return an error rather than allowing the forced revision. This appears to be a Microsoft issue. As a result, these two commands may fail.

N/A

When using the Team Foundation Server internal client and Team Foundation Server 2012 or 2013 alternate Team Project Collections, workspaces created outside of Toad are not visible from within Toad. A workspace may be created from Toad by clicking the ‘New’ button during the Team Foundation Server log in.

This is not an issue when using the Team Foundation Server external client.

114334
Team Coding is disabled for mixed-case object names. N/A

With CVS, Toad may fail to retrieve the list of projects for you to select from in the CVS browser or in the Code Control Groups configuration.

Workaround: See "Missing CVS\Entries File Error" in the online help.

N/A
Team Coding and Clearcase: Dynamic Views are not supported via SCC interface. Snapshot Views must be used instead. (Rational case ID v0830629, Rational Defect # CMBU00053934) N/A

Unicode known issues

Known Issue Issue ID

The following features in Toad do not support Unicode:

  • ASM Manager
  • Export File Browser
  • Hex Editor

In addition, Java itself does not allow Unicode class names or file names. This is relevant to the Java Manager, Editor, and Schema Browser.

N/A

Editor options to highlight object names may not work for object names that contain Unicode characters.

N/A
Script Execution in Editor: Error offset can be incorrect when running scripts with multi-byte object names. N/A
XML (Plain) format creates bad XML if Unicode string values and Unicode column names are exported through Export Dataset. N/A

Import mapping for Unicode characters is incorrect if the characters are not a fixed width (such as Korean).

63221
In Team Coding, objects with Unicode contents are supported, objects with Unicode names are not. Supported Version Control Providers do not support Unicode names. N/A

Third-party known issues

Known Issue Issue ID

Help

(Affects the 64-bit version of Toad only)

If IE9 is installed, clicking a link in the Help file may crash Toad 64-bit, even if IE9 is not the default browser.

Workaround: Users who have IE9 installed can open Help from outside of Toad.

N/A

ODAC

ODAC does not support Unicode in XMLTYPE (editing of XMLTYPE data is not supported). Querying of XMLTYPE with binary storage will lead to an error.

62654

System Requirements

System requirements

This section contains the hardware, software, and privileges required to run Toad for Oracle, as well as the database and virtual environments that Toad for Oracle supports.

Hardware requirements

Requirement

Details

Memory

  • 1 GB RAM - Toad for Oracle 32 bit
  • 2 GB RAM - Toad for Oracle 64 bit

Note: The memory required may vary based on the following: 

  • Applications that are running on your system
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

Hard disk space

    • 120 MB - Toad for Oracle 32 bit
    • 150 MB - Toad for Oracle 64 bit

    Operating system

    • Windows Server 2008 R2 (64-bit) - 2 CPU required
    • Windows 7 (32-bit and 64-bit)
    • Windows 8 and 8.1 (32-bit and 64-bit)
    • Windows Server 2012 (32-bit and 64-bit) - 2 CPU required
    • Windows Server 2012 R1 and R2 (64-bit) - 2 CPU required
    • Windows Server 2016
    • Windows 10

    Database requirements

    Requirement

    Details

    Database client

    An Oracle client must be installed and configured on the system where you are running Toad. The following are supported:

    • Oracle Client or Instant Client 10.2.0.5
    • Oracle Client or Instant Client 11.2.0.1/11.2.0.3
    • Oracle Client or Instant Client 12c Release 1 and 2
    • Oracle Client or Instant Client 18c

    Note: You must use the 32-bit version of Toad with the 32-bit Oracle client, and the 64-bit version of Toad with the 64-bit Oracle client.

    Database server

    Oracle versions:
    • 10g R2
    • 11g, 11g R2
    • 12c Release 1 and 2
    • 18c

    Exadata:

    Toad has been tested on Oracle Exadata 5.0 running Oracle database 12.1.

    Important: It is recommended that your client version be of the same release (or later) as your database server. This is an Oracle recommendation to prevent performance issues.

    Cloud database service

    Oracle Database as a Service on Amazon EC2 and Oracle Cloud

      Network

      Internet Protocol Version 6 (IPv6) is being adopted by the US Federal Government and industries around the world. In its most basic format, the new protocol uses 128-bit addresses instead of 32-bit addresses, which are used by the current IPv4 to route packets over the Internet. Toad for Oracle features, such as FTP, access the Internet through third-party vendors that are IPv6 compliant, such as /nSoftware's IP*Works. For access to Web sites by way of the Toad Online window, Toad simply invokes the user-defined or default Web browser.

      Additional requirements

      Requirement

      Details

      Additional Software

      • Microsoft Internet Explorer 6.0 or later (to view video from the Jump list within Toad, and to view the product documentation in HTML format).
      • Microsoft Office 2016 and recent earlier releases are supported for Word and Excel output.
      • Adobe Acrobat Reader 7.0 or later (to view the product documentation in PDF format).
      • Microsoft .NET Framework 4.0 to support the Toad for Oracle Editions Installer.

      Virtualization support

      Type

      Details

      Application virtualization

      Citrix® XenApp

      Desktop virtualization (VDI)

      vWorkspace™ 7.0 has been tested.

      Server virtualization

      Oracle VM 3.1 has been tested.

      VMware ESX Server 3.5, 4.0, and 5.5 have been tested.

      Note: Toad may work in virtualization environments other than the ones listed.

      Windows Privileges

      In order to install and run Toad, make a connection, and do basic operations, you must have the following privileges.

      Operating System

      Requirements

      Windows 7

      • Read access to the Oracle client folder
      • Read/write privileges on the Oracle Home directories that you use for your connections

      Windows 8 and later

      Windows Server 2012 and 2016

      • Read access to the Oracle client folder
      • Read/write privileges on the Oracle Home directories that you use for your connections

      Note: Other functionality in Toad may require additional privileges.

      Product Licensing

      To activate a trial

      1. Go to the trial download web page: https://www.quest.com/products/toad-for-oracle/software-downloads.aspx, accessed through the product page.
      2. Select the Toad for Oracle Edition that you want to try.
      3. Log in to your account or register.
      4. Accept the license terms.
      5. Download the trial file.

      To activate a purchased commercial license

      1. Go to the Quest Support website: https://support.quest.com/
      2. Type the name of the product that you want to activate in the Enter your product to find support field.
      3. Select Download New Releases.
      4. Download the installer file.

      NoteS:

      • License keys compatible with Oracle 9.7 and earlier versions are no longer supported.
      • Only the newer 48-character license keys are supported.
      • If you have an older license type, the Editions installer points you to the license web page where you can update it.
      Related Documents