Category
Product Version
Topic
Subtopic
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.
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 'Where' tab and choose All Schemas like %<br>- Click Search<br><br>The error 'Name length exceeds 30 characters' 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
When View | Preferences is accessed an error 'Not Connected' is shown (4374988)
This is newly implemented in Navigator 8.0.
Unable to update record within grid interface (F2) when Oracle tables has double quotes (4374755)
It's not possible to update a record within the data grid (F2) when an Oracle table has double quotes. ... If using a table with double quotes fields in a query, and updating a record within the grid, the data is not updated.<br><br>The message 'There are pending changes....Do you want to save changes' appears.
After using Find and Replace, text is appended to highlighted selection, rather than replacing it (4373723)
If you have used the Find and Replace menu in the Editor of SQL Navigator, and a word is still highlighted to replace, and you press Esc to close the Find and Replace windows, the text is still highlighted black in the Editor, like the Find and Replace window is still open in the background.
Existing packages code show an extra line in SQL Navigator 8.0 (4373760)
Opening existing package codes in SQL Navigator 8.0 shows extra lines. ... Because of a last-minute defect SQLNAV-2453, the SQL Navigator 8.0 was retired from the website for regression testing. ... If a user downloaded SQL Navigator before 10/24/2023, it's required to download the new SQL Navigator build.
Very slow loading time for PL/SQL packages. (4373091)
With a PL/SQL package of approximately 16000 lines, it takes nearly 20 seconds to load for SQL Navigator 7.6.
What's New in SQL Navigator 8.0? (4373518)
Support of the most recent SQL Editor formatting and parsing syntax capabilities Resolved issues: ... SQL Navigator encounters slow loading times when attempting to open large objects containing more than 10,000 lines from a database.
How does Toad and SQL Navigator access the tnsnames.ora file and info? How do you change/specify (4316742)
How does Toad and SQL Navigator access the tnsnames.ora file and info? ... How do you change/specify the TNSnames.ora file location? ... In the TNSnames Editor in Toad, it automatically picks up the tnsnames.ora file, but I want to redirect to a different file.
Getting errors when connecting with an Oracle Instant Client (4310962)
The following errors may occur when using Oracle Instant Client. ... 2. The are no database connections to choose from the drop down list. ... 3. ORA-12705 Cannot access NLS data files or invalid environment specified.
Can't login to Toad. What is the Toad password? Where do I get my login credentials? What is my user name and password? (4226333)
Cannot or unable to login. ... Where do I get my login credentials? ... What is my username and password? ... The account is locked so it needs to be unlocked and the password reset. ... There is a prompt that the password has expired, and to reset, the old password is needed, but what is the old password?
How do I verify the magnitude of my licensing keys? (4232458)
How do I verify the magnitude of my licensing keys? ... Please contact license@quest.com and provide any license key/site message information that you have and a representative from the licensing group will contact you shortly.
SQL Navigator license key search (4265012)
The NavKeyScan.exe utility can scan a network and find SQL Navigator installs on every machine. ... Here how it works, it will search for qsauthorize12.key: ... The person who runs the utility must have Admin right to all machines which needs to be scanned, ideally it will run by customers' MIS Admin people.
Using SVN and TortoiseSVN with SQL Navigator. (4270224)
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 SQL Navigator using SVN for the version control system (checking out and checking in a procedure).
Extract DDLs from packages or Compile are missing in the schema browser (4259899)
In the Schema Browser, the compile objects and extract ddl options are missing for packages. ... These options are normally available on the pop up menu upon right click on the package name. ... The icons for these options are also disabled in the toolbar .
SQL Optimizer Compare Scenarios not showing all the alternative SQL statements (4305551)
User runs SQL Optimizer on a query and it returns many alternative SQL statements listed in the SQL Details window. ... However after clicking on Optimize or Execute, the user will be taken into the Compare Scenarios window.
View Differences. The 'Switch Sides', 'Copy to Right' (and Left), 'Delete Left Text' (and Right), and 'Undo' icons are grayed out or unavailable. (4308243)
They are not working.
Allowing users to view database objects from other users without granting the Select_Catalog_Role (4214674)
When attempting to grant access to other users objects without granting the Select_Catalog_Role or Select_Any_Table privilege. ... 1. Create a role called QUEST_NAV_VIEWS ... 2. Login as sys and grant the following view to QUEST_NAV_VIEWS grant SELECT on VIEW SYS.DBA_ALL_TABLES to QUEST_NAV_VIEWS grant SELECT on VIEW SYS.DBA_ERRORS to QUEST_NAV_VIEWS grant SELECT on VIEW SYS.DBA_OBJECTS to QUEST_NAV_VIEWS grant SELECT on VIEW SYS.DBA_OBJECT_TABLES to QUEST_NAV_VIEWS grant SELECT on VIEW SYS.DBA_SOURCE to QUEST_NAV_VIEWS
Dbms_output window text lines are truncated (4241716)
Dbms_output window text lines are truncated at some rather random looking line length. ... It's not truncated at a certain number of characters as the last character is actually sliced in half. ... It's not sliced at the width of the window either.
How to reset or restore SQL Navigator to the factory default settings and options? (4287291)
How to reset or restore the SQL Navigator Preferences to the default options or settings? ... Go to View menu | Preferences | click on the "Reset" button | and then click Yes on the Confirmation pop-up box.
Issues downloading SQL Navigator software or documents from SupportLink. (4297169)
User having issues downloading SQL Navigator software or documents from SupportLink. ... Pop-up blockers, anti-virus programs, or other network security settings not allowing user to download files.
Unable to see the SQL Navigator window. It does not show or is hidden. (4235011)
When starting SQL Navigator, the window comes up and then everything disappears. ... SQL Navigator appears in the Windows Task Bar, but it does not do anything. ... Uninstalling and re installing the product does not resolve this issue.
What versions of SQL Navigator support Oracle 10gR1 and 10gR2? (4348728)
Note: Anything prior to version 5.0 does not support 10g. ... SQL Navigator version 5.0 supports 10g Release 1, but not Release 2 ... SQL Navigator versions 5.1 & 5.5 support both 10g Release 1 and Release 2
ERROR: "Can't initalize OCI. Error -1" using Oracle 10.2 Instant Client. (4310316)
Error received when using a 10g instant client to connect to a database with SQL Navigator. ... All other products connects without issue: ... "Can't initialize OCI. ... Error -1" ... Switch the Oracle binary file to the newer Instant Client Light Edition:
Error: "Program may have become unstable" when executing SQL Script. (4320132)
"Program may have become unstable" ... Some registry entries haven't been updated after upgrading SQL Navigator from an older version. ... NOTE: Please backup your registry settings before making any modifications.
New Product Association
- 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