Chat now with support
Chat with Support

SQL Navigator for Oracle - Knowledge Base

Filter Your Results

Category

Product Version

Topic

Subtopic

Filter Search Results

Search Knowledge Base by keyword

(Choose different product)



DateRelevanceViews Displaying 1-25 of 2998
Checking for Existing Toad Product License Keys Without User Interaction (4378098)

Administrators or automated systems may need to verify the presence and validity of Toad product licenses without requiring user intervention. ... Manually checking each user's license information can be time-consuming and inefficient, especially in large deployments.

Product(s): Toad Data Point, Toad for Oracle, SQL Navigator for Oracle, Toad Data...
Last Updated On: 1/9/2025
NA rating | 1507 views
Knowledge Article
How to receive email notifications, security alerts and important information about my product? (4329947)

I would like to receive email Notifications, Support Status &amp; Security Alerts <p>Go to the following <a href="https://support.quest.com/manageprofile" target="_blank">link</a><br>Then select &quot;My Subscriptions&quot; tab</p>

Product(s): Toad for Oracle, SQL Navigator for Oracle, Spotlight on SQL Server...
Last Updated On: 11/4/2024
NA rating | 2684 views
Knowledge Article
Small box opens alongside SQL Navigator when used in Remote Desktop, or when application is open for days/weeks (4377149)

Sometimes a small SQL Navigator window which looks like a small box with no details within it, opens in the middle of the screen when SQL Navigator is open. ... Even if you hide all the applications in Windows, it remains.

Product(s): SQL Navigator for Oracle
Last Updated On: 10/1/2024
NA rating | 434 views
Knowledge Article
Does SQL Navigator support Windows 11? (4376979)

Does SQL Navigator support Windows 11? Yes, SQL Navigator for Oracle supports Windows 11 from version 8.0.<br>The latest version of SQL Navigator can be downloaded <a href="https://support.quest.com/sql-navigator-for-oracle/download-new-releases" target="_blank">here</a>

Product(s): SQL Navigator for Oracle
Last Updated On: 9/12/2024
NA rating | 535 views
Knowledge Article
What's New in SQL Navigator for Oracle v7.3? (4242514)

This article discusses some of the new features in SQL Navigator for Oracle 7.3. ... Possible categories could be: development, test or production. ... You could create your own categories and assign colors as appropriate.

Product(s): SQL Navigator for Oracle
Last Updated On: 8/7/2024
NA rating | 1214 views
Knowledge Article
Double clicking code in code editor does not change lines/characters count (4329535)

Double clicking code in code editor does not change lines/characters count. ... None ... STATUS ... Issue fixed in version 7.5. ... The latest version of SQL Navigator for Oracle can be downloaded here .

Product(s): SQL Navigator for Oracle
Last Updated On: 8/6/2024
NA rating | 765 views
Knowledge Article
Editor double space issue (4376600)

When openning a package, all line breaks (CR|LF) are doubled. WORKAROUND<br><br>None<br><br>STATUS<br><br>Issue fixed in version 8.0. The latest version of SQL Navigator can be downloaded <a href="https://support.quest.com/sql-navigator-for-oracle/download-new-releases" target="_blank">here</a> .<br> https://forums.toadworld.com/t/sql-navigator-8-0-64-bit-odd-error/58324

Product(s): SQL Navigator for Oracle
Last Updated On: 8/6/2024
NA rating | 277 views
Knowledge Article
How to create the Support Bundle file in Toad (4323349)

How to create the Support Bundle file for the following programs: ... 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.

Product(s): Toad Data Point, Toad for Oracle, SQL Navigator for Oracle
Last Updated On: 8/1/2024
NA rating | 3010 views
Knowledge Article
When a SQL editor window is split with 2 panes, behavior of each pane is not independent. (4376524)

Steps to reproduce the issue: ... Select Split/Compare | Horizontal Split Write something on the editor ... Select the lower pane and press Control + F to search for something ... The result is always in the upper pane instead than on the lower pane WORKAROUND

Product(s): SQL Navigator for Oracle
Last Updated On: 7/30/2024
NA rating | 632 views
Knowledge Article
Help | Check for Updates doesn't work (4298921)

Check for updates doesn't work. ... It returns the error below: ... Unable to access SQL Navigator Check for Updates file. ... Make sure that the file C:\Users\username\AppData\Roaming\Quest Software\SQL Navigator 7.6.0 Beta\CFU\Nav_CFU.ini is valid.

Product(s): SQL Navigator for Oracle
Last Updated On: 8/6/2024
NA rating | 1093 views
Knowledge Article
Generated test procedure wrong when using a parameter of type RECORD based on a table (%ROWTYPE) (4335086)

Create a test procedure with SQL Navigator 7.1 or 7.2. ... Procedure has a parameter of type RECORD based on a table (%Rowtype). ... Result: The procedure is not called with the entered values. ... Steps to reproduce the issue:

Product(s): SQL Navigator for Oracle
Last Updated On: 8/6/2024
NA rating | 761 views
Knowledge Article
where are the entry points(proc/func) of a wrapped package in latest version? (4284387)

It is not possible to see the entry points(proc/func) of a wrapped package. ... This was possible on versions 6.x. ... 7.5: ... 6.7: ... This happens in 7.4 and later for 12C and later databases ... WORKAROUND

Product(s): SQL Navigator for Oracle
Last Updated On: 8/6/2024
NA rating | 1123 views
Knowledge Article
Extracted metadata for pl/sql fails to compile in SQL Navigator 7.6 (4344790)

Extracted metadata via Get Metadata for pl/sql fails to compile when the word EDITIONABLE is in the ddl definition. ... per oracle documentation EDITIONABLE is the default. ... in order to get metadata extracted without EDITIONABLE the version needs to be pre 12.

Product(s): SQL Navigator for Oracle
Last Updated On: 7/2/2024
NA rating | 354 views
Knowledge Article
Is it possible to return results for multiple SQL statements in the same tab/window? (4239071)

<p>When executing statements in the editor, is it possible to return results for multiple SQL statements in the same tab/window?</p> ... It is not possible to have the results for two different statements open in the same tab.

Product(s): SQL Navigator for Oracle
Last Updated On: 6/18/2024
NA rating | 848 views
Knowledge Article
Is it possible to change the default keyboard shortcuts in SQL Navigator? (4376102)

Is it possible to change the default keyboard shortcuts in SQL Navigator? ... This is not currently possible.

Product(s): SQL Navigator for Oracle
Last Updated On: 6/19/2024
NA rating | 659 views
Knowledge Article
Attempting to install MSI Quest Installer on a PC and getting the error message Failed to configure per-machine MSI package (4362428)

Attempting to install MSI Quest Installer on a PC and getting the error message Failed to configure per-machine MSI package Possible Windows configuration issue. ... <p>Check the Windows Event Viewer and see if you have the following error.

Product(s): Toad Data Point Subscription, Toad Data Point, Toad for Oracle, Toad for...
Last Updated On: 6/17/2024
NA rating | 1031 views
Knowledge Article
SQL Navigator 7.6 generates different stubs for Oracle 12c and 19c (4269175)

When using SQL Navigator to generate stubs (click on preview button) when trying to run a function from a package, it generates different output (different code) when it is generated from Oracle 12c than what is generated from 19c.

Product(s): SQL Navigator for Oracle
Last Updated On: 6/18/2024
NA rating | 1227 views
Knowledge Article
ORA-6550 error when executing a Function with a Proxy user (4376040)

When executing a Function in the database, whilst connected with a Proxy user, if there is a table in the database with the same name as the Oracle schema name, the error 'ORA-6550' appears. ... If this table doesn't exist, there is no error.

Product(s): SQL Navigator for Oracle
Last Updated On: 6/13/2024
NA rating | 551 views
Knowledge Article
How to backup, transfer, restore the SQL Navigator user settings profile? What if 'Cancel' was hit? (4273082)

How to backup, transfer, restore the SQL Navigator user settings profile i.e. from one SQL Navigator to another or from one PC to another or from an old computer to a new computer? ... How to import settings when the 'Cancel' button is accidentally clicked during the initial startup of a SQL Navigator installation?

Product(s): SQL Navigator for Oracle
Last Updated On: 5/23/2024
NA rating | 1565 views
Knowledge Article
Package specification in SQL Navigator still shows as checked out with Subversion (SVN) (4375635)

When checking out a package body, a lock is also placed on corresponding package specification although only the body was requested. ... Within SQL Navigator repository only the body is checked out.

Product(s): SQL Navigator for Oracle
Last Updated On: 5/14/2024
NA rating | 676 views
Knowledge Article
Unable to remove time info from a date field in the editor. (4375558)

Unable to remove time info from a date field in the editor. ... Select a table record with a date containing a time information. ... <br>2. ... Edit the date and change just the time to 00:00:00, after commit the date and time is not altered.

Product(s): SQL Navigator for Oracle
Last Updated On: 5/14/2024
NA rating | 723 views
Knowledge Article
Running a user_scheduler_jobs query freezes SQL Navigator for minutes (4375436)

When running the following query, SQL Navigator v8.0 freezes for several minutes. ... The query returns ok, but the application appears to hang once it is returned<br><br>SELECT *<br>FROM user_scheduler_jobs a<br>ORDER BY a.job_action; Please uninstall and reinstall SQL Navigator to resolve the issue of hanging after running a query.

Product(s): SQL Navigator for Oracle
Last Updated On: 4/18/2024
NA rating | 714 views
Knowledge Article
Order by statement is not retained when you choose another editor tab, and go back to the original one (4375174)

Order by statement is not retained when you choose another editor tab, and go back to the first one.<br><br>Steps to replicate:<br>1. ... In a new Editor tab (tab1) Run a select statement with order by asc on a column with a date<br>2.

Product(s): SQL Navigator for Oracle
Last Updated On: 3/21/2024
NA rating | 528 views
Knowledge Article
SQL Navigator for Oracle Team Coding refresh issue in GUI (4375110)

When a user manually edits the Team Coding tables using a script, the objects are checked out or checked in. ... The Team Coding in the GUI indicates that the object is Read-Only, and therefore, you cannot edit the object in the editor.<br><br>The object can only be edited when you open a new connection to the database.

Product(s): SQL Navigator for Oracle
Last Updated On: 3/26/2024
4 rating | 861 views
Knowledge Article
Error 'Name length exceeds 30 characters' when searching code with a long name (4374952)

In SQL Navigator 8.0, when you have a long procedure name such as:<br><br>CREATE OR REPLACE<br>procedure thisisaprocedurewithaverylongnameandwillgiveanerror as<br>begin<br>--test<br>null;<br>end;<br>/<br><br>Then:<br><br>- Go to Search | Code Search | What tab and type part of the procedure name<br>- Go to the &#39;Where&#39; tab and choose All Schemas like %<br>- Click Search<br><br>The error &#39;Name length exceeds 30 characters&#39; appears.<br><br>This issue only happens when All Schemas is selected. It is fine when you run this on the User schema WORKAROUND:<br>None.<br><br>STATUS:<br>Waiting for fix in a future release of SQL Navigator for Oracle SQLNAV-2459

Product(s): SQL Navigator for Oracle
Last Updated On: 2/27/2024
NA rating | 606 views
Knowledge Article
Search All Products
Recommended Content
Updating results
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Technical Support
View All