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

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 1039
When a check-out is canceled, the changes are not rolled back in the database. (226912)

When checking out either the body or spec of a package, modifying, saving the code and cancelling the check-out in TeamCoding, the changes are not rolled back into the database. When checking-out the package a second ...

Product(s): SQL Navigator for Oracle
Last Updated On: 8/16/2017
(0 Ratings)
Getting an Access Violation(AV) error after dropping a package and trying to copy the name from the details pane. (215063)

Getting an Access Violation(AV) error after dropping a package and trying to copy the name from the details pane. Steps to reproduce: 1. Show details pane in db navigator 2. Create an package + body "aa" 3. Close the package ...

Product(s): SQL Navigator for Oracle
Last Updated On: 8/16/2017
(0 Ratings) 640 views
Error on duplicate record (215318)

Getting error "Could not convert variant of type (OleStr) into type (Double)" when trying to duplicate a row in the Data Grid WORKAROUND. 1.Select the row 2.R-click and select Export Data 3.Select "Table inserts" as format and ...

Product(s): SQL Navigator for Oracle
Last Updated On: 8/16/2017
(0 Ratings) 627 views
Common Oracle connection problems (7712)

How to troubleshoot connection errors when logging into a supported Oracle database Common Oracle connection errors: * ORA-12154: TNS: could not resolve service name * ORA-12505 TNS: listener could not resolve SID given in connect descriptor * Error: 1.0 [Load ...

Product(s): Toad Data Point, Toad for Oracle, SQL Navigator for Oracle
Last Updated On: 8/10/2017
(0 Ratings) 31288 views
Error "Session Manager: GetSession Index out of bounds [0/0]" when closing DB Navigator window (211823)

This issue occurs when closing the DB Navigator, when the "Close when last session window closes" option in preferences is ticked. Steps to reproduce: In Preferences | General | Session, ensure "Close when last session window closes" is ticked. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 8/9/2017
(0 Ratings) 837 views
Unable to expand the 'Package Bodies' branch in the DB Navigator / Explorer pane. Can't open packages. (206425)

When logged into user APPS on an Oracle Financials database, it can take a long time (up to 2 minutes) to expand the list of Package Bodies. WORKAROUND. none. STATUS. Fixed in version 7.4. The latest release can be downloaded here.

Product(s): SQL Navigator for Oracle
Last Updated On: 8/9/2017
(0 Ratings) 883 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: 8/8/2017
(5 Ratings) 119271 views
Access violation error when trying to select huge number of rows (231362)

When SQL Navigator managing the select of great data volume falls into Access violation error. Go to View | Preferences; Go to General | Session tab; Set the Read Buffer Size to lower number than is already there (eg half of current value). ...

Product(s): SQL Navigator for Oracle
Last Updated On: 7/19/2017
(0 Ratings) 5 views
How and where to download a trial version of Quest Products? (21229)

How and where to download a trial version of Quest Products? Go to Quest. The main product page for each product has the option to "Download Free Trial". Or go to the Trials page, look up the product, and download. 1. Go ...

Product(s): Toad for SAP Solutions, SQL Optimizer for SQL Server, Toad Data Point...
Last Updated On: 7/7/2017
(1 Ratings) 13668 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/28/2017
(1 Ratings) 6220 views
Access Violation error when a big number of rows selected (230681)

Access Violation error occurs when a big number of rows selected. 32-bit version of the application used Install the 64-bit version of SQL Navigator. Steps: Download 64-bit version of SQL Navigator. The latest version can be downloaded here. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 6/26/2017
(0 Ratings) 5 views
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) 3303 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) 2 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) 23105 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
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) 17029 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) 407 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) 439 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) 441 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) 401 views