Quest has been named as an ASP "Ten Best Web Support Sites" award winner. Learn more.

Toad for Oracle 12.5 - Release Notes

Known Issues

Known issues

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

Table 12: 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

Data Grids

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

Schema Browser

Sometimes on Oracle 8.1.7 or higher, 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

 

Table 13: Code Analysis known issues

Known Issue Issue ID
Saving results to a database: When dealing with nested procedures, CodeXpert 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 CodeXpert.

N/A

 

Table 14: Editor known issues

Known Issue Issue ID

When file splitting is used in the Editor, Code Analysis does not automatically check the code in the Editor.

Workaround: Click the "Analyze Code in Editor" button.

85604

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

 

Table 15: 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

 

Table 16: Team Coding known issues

Known Issue Issue ID

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

Team Coding and SourceSafe:

  • Integration via the SCC API is available but not recommended for SourceSafe 6.0
  • SourceSafe 5.0 ignores the "Force revision" flag and ''Create a new revision for existing objects'' option when exporting.
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

 

Table 17: 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
Connections to Service Names with Unicode Characters are not supported. N/A

The Editor does not fully handle Unicode words, and as a result highlight object names, CTRL + Click, and mousing over watch hints may not work.

Workaround: The fix is to change a regular expression in the PL/SQL language parser. New installations will not have this issue, but the language parser is not applied for upgrading users (so you do not lose any language parser customizations). If you are upgrading, you need to modify the PL/SQL language parser and add "?r)" (without quotes)  to the beginning of the “Any name" parser rule’s expression if you want full Unicode object name support. For detailed instructions, please see the Unicode Troubleshooting topic in the Help file.

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

 

Table 18: 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

E-Control (Editor component)

Odd word-wrapping behavior in some languages. Word wrapping may appear between symbols, with no space required to wrap, and some characters cannot be word-wrapped at all (for example, multi-byte characters in ANSI text).

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

Was this topic helpful?

[Select Rating]



System Requirements

System requirements

Table 19: System requirements

Requirement Details
Memory

1 GB RAM required for 32-bit

2 GB RAM required for 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 2003 (32-bit and 64-bit)

Windows XP (32-bit and 64-bit)

Windows Vista (32-bit and 64-bit)

Windows Server 2008 (32-bit and 64-bit) - 2 CPU required

Windows Server 2008 R2 (64-bit) - 2 CPU required

Windows 7 (32-bit and 64-bit)

Windows 8 (32-bit and 64-bit)

Windows Server 2012 (64-bit)

Exceptions:

64-bit Toad's SQL Tracker requires Windows Vista or later.

Database requirements

Table 20: Database requirements

 

Requirement

Details

Database client

Oracle Client 9.2.0.8

Oracle Client or Instant Client 10.2.0.3/10.2.0.4

Oracle Client or Instant Client 11.2.0.1/11.2.0.3

Oracle Client or Instant Client 12c

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

Oracle 8.0.6; 8.1.7; 9i; 9i R2; 10g; 10g R2; 11g, 11g R2, 12c.

Exadata

Toad has been tested on Oracle Exadata 2.0 running Oracle database 11g R2.

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 databases running on Amazon EC2

IPv6 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 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 such as /nSoftware's IP*Works that are IPv6 compliant. For access to Web sites by way of the Toad Online window, Toad simply invokes the user-defined or default Web browser.

 

Additional requirements

Table 21: Component requirements

Requirement

Details

Additional Software

Microsoft Internet Explorer 6.0 or later (to view video via the Jump list within Toad, and the Release Notes).

Adobe Acrobat Reader 7.0 or later (to view the Installation Guide).

Virtualization support

Table 22: Virtualization support

Before installing Toad review the following for virtualization support:

Type

Details

Application virtualization

Citrix XenApp 5.0 and 6.5 have been tested.

    Desktop cirtualization (VDI)

    Dell™ vWorkspace™ 7.0 has been tested.

      Server virtualization

      Oracle VM 3.1 has been tested.

        VMware ESX Server 3.5 has been tested.

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


          Was this topic helpful?

          [Select Rating]



          Product Licensing

          Product licensing

           

          To activate a trial:

          1. Visit trial download web page: http://software.dell.com/products/toad-for-oracle/software-downloads.aspx, accessed through the product page.

          2. Find your job function and select corresponding trial.

          3. Sign-in to your account or register.

          4. Complete brief survey.

          5. Download trial file.

           

          To activate a purchased commercial license:

          1. Visit support website: https://support.software.dell.com/

          2. Click Download New Releases in the self-service section.

          3. Select product, select Edition and click Download.

          4. Sign-in to your account or register.

          5. Download commercial file.

           

          License keys compatible with Toad for Oracle 9.7 and earlier versions are no longer supported.

          To upgrade your key:

          1. Go to Help | Licensing to find your license number in the current version of Toad.

            If not explicitly listed, it may be included as part of the Site Message associated with your key.

            Example: ACCOUNTNAME-nnn-nnn-nnn.

          2. Go to the License Key Upgrade page: http://license.quest.com/upgrade.
          3. Enter your e-mail address and your existing license number, and follow the prompts.

          If you need help finding your license number or an upgrade key, please contact the License Administration team: https://support.software.dell.com/licensing-assistance


          Was this topic helpful?

          [Select Rating]



          Getting Started with Toad for Oracle 12.5

          Getting started with Toad for Oracle 12.5

          The Toad release package contains the following:

          1. Toad for Oracle 12.5

            Toad is available in different editions. The release package includes the edition that you purchased.

          2. Product Documentation, including:
            • Installation Guide
            • Beginner's Guide to Using Toad
            • Online Help
            • Release Notes

          Upgrade and installation instructions

          Please refer to the Installation Guide for installation and upgrade instructions.

          Upgrades for Toad install side-by-side with any previous versions you have installed. You can run the new and previous versions concurrently.

          The first time you run the new version of Toad, settings files from the previous version will be automatically imported. If you wish to start with a clean set of user files, run the Copy User Settings utility under the Utilities menu and select 'Create a clean set of user files from the base installation.'

          Note: Toad supports importing settings only if the new version is within two releases of the previous version. If your versions are more than two releases apart, you need to install an intermediate version to successfully import the files.

          Additional resources

          Additional information is available from the following:


          Was this topic helpful?

          [Select Rating]



          Related Documents