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
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
What's new in SQL Navigator 7.4?
How to find the license number
Contact Us
Technical Support
View All Contacts

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 1042
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: 10/18/2017
(1 Ratings) 7717 views
Is there a way to encrypt the license key, so end users cannot view the key? (233242)

Is there a way to encrypt the license key from being seen in the Help | Licensing window or in the file where the license key is stored? There is not a way to encrypt the key in the Tools | Product Authorization window or in the file where the key is stored. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 9/28/2017
(0 Ratings) 2 views
Error in tool View difference when open big package or comparing schemas (212344)

SQL Navigator crashes when running "view difference" with play button (reload and re-compare) for long packages or DB schemas with the “Line out of bounds” error. WORKAROUND. Confirm the error "Line out of bounds" several times. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 9/27/2017
(0 Ratings) 877 views
Error "Editor for this type of object is not implemented for this Release" when editing a 'Directory' object type. (232688)

In the Object Explorer | SYS schema | Directories. On trying to edit any listed directory, the following errors are displayed: "Editor for this type of object is not implemented for this Release". "Access violation at address 0000000002EF22D2 in module 'sqlnavigator.exe'. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 9/6/2017
(0 Ratings) 12 views
SQL Navigator 7.3 64-bit with TFS 2015 error: SCC provider initialization failed: SCC Error: The 32 bit version of Toad requires a Microsoft Team Foundation Server MSSCCI Provider 32 bit DLL. (221972)

Using SQL Navigator 7.3 64-bit with TFS 2015. Both 64-bit MSSCCI Provider and 32-bit MSSCCI Provider are installed on the machine. ERROR: SCC provider initialization failed: SCC Error: The 32 bit version of Toad requires ...

Product(s): SQL Navigator for Oracle
Last Updated On: 8/28/2017
(0 Ratings) 578 views
What's new in SQL Navigator 7.4? (232397)

This article contains some new features released SQL Navigator 7.4? New Features. SQL Navigator 7.4 is a maintenance release with no new functionality.

Product(s): SQL Navigator for Oracle
Last Updated On: 8/25/2017
(0 Ratings) 7 views
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
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
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
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
(6 Ratings) 122304 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) 15059 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
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
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
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) 24494 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) 17668 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) 604 views