Statistica is now part of TIBCO. Beginning June 5th, Statistica customers will need to use TIBCO Support's customer portal, to receive assistance with Statistica.

SQL Navigator for Oracle - Knowledge Base

Filter Your Results
Search All Products

Self Service Tools
Knowledge Base
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
How to find the license number
Contact Support
Contact Support

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 1037
Error: "Invalid authorize key" when registering a commercial key. (21747)

"Invalid authorize key" error message displayed when entering a commercial key at the product authorization prompt. The key worked in a previous install of SQL Navigator. WORKAROUND 1: Verify the license key entered is correct. Check for typos and extra spaces. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 6/23/2017
(0 Ratings) 3302 views
When executing procedure, not seeing input parameters (230745)

When executing a procedure, it is not showing the input parameters for the procedure. It brings up the window where they would be entered, but there are no parameters listed. WORKAROUND: 1. Close all sessions. 2. Open ...

Product(s): SQL Navigator for Oracle
Last Updated On: 6/23/2017
(0 Ratings) 1 views
Code Analysis does not detect unreferenced variables, Rule 6405 in PL/SQL. (180093)

When running Code Analysis on a package, "Rule 6405: Avoid defining variables that are not referenced inside the program" is not listed in the Rule Violations when there is an unreferenced variable in the code. WORKAROUND ...

Product(s): SQL Navigator for Oracle
Last Updated On: 6/20/2017
(0 Ratings) 1467 views
Space character does not work doing a Find with Regular Expression option selected (213535)

When doing a Find in the editor, if the Regular Expression option is selected, the space character is not recognized. For example, if 'DROP VIEW' is what is being searched for, it will not find this string in the SQL. WORKAROUND ...

Product(s): SQL Navigator for Oracle
Last Updated On: 6/20/2017
(0 Ratings) 637 views
How to download a commercial software installer? Need installer by FTP or mail. (17322)

How to download a Commercial version installer from the Quest Support Portal? In some situations, it errors out during the download and won't let the download to complete even though a current support maintenance contract exists. Steps to download a commercial product: ...

Product(s): Toad Intelligence Central, Toad for SAP Solutions, Backup Reporter for...
Last Updated On: 6/14/2017
(0 Ratings) 21112 views
Error "Unable to create directory" when checking out any object (after migrating Team Coding objects form 7.2 to 7.3) (230346)

After successfully migrating Team Coding Objects from 7.2 to 7.3, the following error occurs when trying to check out any object: "Unable to create directory". Visual Source Safe project name has a space eg "DEV TEST" WORKAROUND. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 6/12/2017
(0 Ratings) 5 views
Toad installation error: The installer was not able to complete successfully. (189788)

Unable to install product suite. When trying to install Toad, getting the error below. The issue happens on the .EXE file, but can also happen on the .MSI file. ERROR: "The installer was not able to complete successfully. RegisterComplete returned error code [0x80070005]. ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 6/7/2017
(0 Ratings) 5443 views
When checking-out an object, the comment is not automatically reported at the check-in time. (226514)

When checking-out an object, the comment is not automatically reported at the check-in time. It has to be entered again. This issue is caused by a product defect. WORKAROUND Re-enter the comment upon checking-in the object. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 6/5/2017
(0 Ratings) 13 views
"OCI_INVALID_HANDLE" or "Invalid Cursor" errors in Toad for Oracle and SQL Navigator. (17961)

Toad for Oracle and SQL Navigator users receive an "OCI_INVALID_HANDLE" error when doing any of the following actions: - Executing explain plan - Opening SQL Editor window - Opening Procedure Editor window - Opening Schema Browser - Connecting to the database. ...

Product(s): Toad for Oracle, SQL Navigator for Oracle
Last Updated On: 5/25/2017
(1 Ratings) 16778 views
How to create the Support Bundle file in Toad (229559)

How to create the Support Bundle file in Toad In Toad for Oracle: Support Bundle: Can be found in Toad menu| Help | Support bundle >> Then click on the Support Bundle Tab and save this text file file in the Desktop. In SQL ...

Product(s): Toad for Oracle, SQL Navigator for Oracle
Last Updated On: 5/18/2017
(0 Ratings) 122 views
When checking in a package, the system tries to check in both spec and body (225952)

When checking out a package, there are boxes to individually select the spec or the body but when checking in the body, the system also tries to check in the spec and sends a message to inform that the module was not checked out. This issue is caused by a product defect. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 5/15/2017
(0 Ratings) 45 views
Installation, Unable to install product, "Unknown Error: this installation package failed due to an unknown error, returned error code [0xXXXXXXXX]. (229237)

Unable to install product suite. When trying to perform the installation via Bundle installer, getting the Unknown error. The issue happens on there is an unknown error happened during the installation. ERROR: "Unknown Error ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 5/8/2017
(0 Ratings) 220 views
Installation, Unable to install product, "HTTPs Error: This package download process are interrupted, error code [0x80072EFE] or [0x80072EFF] or [0x80070642] or [0x80070EFD] (229235)

Unable to install product suite. When trying to perform the installation via Bundle installer, getting the Https error. The issue happens on the web installer then your internet connection is unreachable. ERROR: "HTTPs Error: This package download processes are interrupted. ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 5/8/2017
(0 Ratings) 232 views
Installer, Unable to install, getting the [8007051B] or [0x80070002] or [0x80070005] error. (229234)

Unable to install product suite. When trying to perform the installation via Bundle installer, getting the [8007051B] or [0x80070002] or [0x80070005] error. The issue happens on the bundle installer does not have the administrative privileges to perform the installation. ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 5/8/2017
(0 Ratings) 238 views
Installation, "Insufficient Disk Space Error: this installation package failed due to insufficient disk space, returned error code [0x80070643] (229236)

Unable to install product suite. When trying to perform the installation via Bundle installer, getting the insufficient disk error. The issue happens on then there is no sufficient disk space to perform the installation. ERROR: "Insufficient ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 5/8/2017
(0 Ratings) 204 views
What is a "license number" and how to find the license number in Toad for Oracle. Invalid license number error. (120553)

How can a Toad for Oracle or Toad family products license number be looked up? What is the difference between a "license number" and a "license key"? A license number is different from a license key. A license number is ...

Product(s): Toad Decision Point, Toad Intelligence Central, Toad for SAP Solutions...
Last Updated On: 5/4/2017
(5 Ratings) 25467 views
How to purchase or buy Toad? How to acquire a Commercial license key for Toad? (134489)

How to purchase or buy Toad, SQL Optimizer, or SQL Navigator products? How to acquire a Commercial license key? How to get a price quote? To purchase a Commercial license key for the aforementioned products and/or ...

Product(s): Toad for SAP Solutions, SQL Optimizer for SQL Server, SQL Optimizer for...
Last Updated On: 5/3/2017
(1 Ratings) 9349 views
Using SVN and TortoiseSVN with SQL Navigator. (30310)

User wants to use SVN and TortoiseSVN as version control with SQL Navigator. Please review the attached video tutorial in the following order. To play unzip the files first. The first movie "Using SVN with SQL Navigator" demonstrates ...

Product(s): SQL Navigator for Oracle
Last Updated On: 4/14/2017
(0 Ratings) 3073 views
Getting ORA-12154 error connecting to database after installing Toad on Windows 64-bit OS with Oracle Client 10g 32-bit. (12495)

Any of the following errors can occur when attempting to connect to an Oracle database when installed on a Windows 64-bit OS: "ORA-12154: TNS: could not resolve the connect identifier specified.". "ORA-06413: Connection not opened". "Can't initialize OCI. Error -1". ...

Product(s): Toad Data Point, Toad for Oracle, SQL Navigator for Oracle
Last Updated On: 4/12/2017
(3 Ratings) 27031 views
Change user settings location - terminals server (227695)

Is there documentation for changing the default user settings for SQL Navigator. I have it installed on a terminal server and I need to point the user settings files to another location. This is done on the registry so we have no way of changing the default configuration.

Product(s): SQL Navigator for Oracle
Last Updated On: 3/27/2017
(0 Ratings) 73 views
Launching Toad. "No valid Oracle Clients found" error message when opening or starting Toad. (71545)

When starting the Toad application or trying to connect to a database, Toad for Oracle returns the following error: "No valid Oracle Client found. Please note that Toad only supports 32-bit Oracle Client installations.". OR. "No valid Oracle clients found. ...

Product(s): Toad for Oracle, SQL Navigator for Oracle
Last Updated On: 3/27/2017
(5 Ratings) 116408 views
Does SQL Navigator 7.3 support Toad for Oracle team coding? (227552)

Does SQL Navigator 7.3 support Toad for Oracle team coding? When trying to configure SQL Navigator 7.3 with team coding tables for Toad for Oracle 12.10, SQL Navigator does not recognize the provider and removes data ...

Product(s): Toad for Oracle, SQL Navigator for Oracle
Last Updated On: 3/23/2017
(0 Ratings) 218 views
How to reset or restore SQL Navigator to the factory default settings and options? (17115)

How to reset or restore the SQL Navigator Preferences to the default options or settings? RESOLUTION 1: Go to View menu | Preferences | click on the "Reset" button | and then click Yes on the Confirmation pop-up box. RESOLUTION 2: ...

Product(s): SQL Navigator for Oracle
Last Updated On: 3/17/2017
(0 Ratings) 6393 views
After the Use of Profile Manager Manual Updates in Windows Registry are necessary (226885)

After the Installation of SQL-Navigator 7.3 it works fine with the Oracle Home. But after the Import of user Settings with Profile Manager it is necessary to change the Windows Registry: [HKEY_USERS\S-1-5-21-66538259-1857230727 ...

Product(s): SQL Navigator for Oracle
Last Updated On: 3/7/2017
(0 Ratings) 145 views
How to request for a general walk-through or product demonstration for Toad? (19547)

How to request for a walk-through or product demo for Toad? Please contact your account manager or account sales representative to request a general walk-through or product demo for any of our Quest products. If you do ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2 ZOS, Toad Data...
Last Updated On: 3/3/2017
(0 Ratings) 6502 views