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 1050
Access Violation when trying to read XMLTYPE column. (242315)

Tables with XMLTYPE columns returns an error message similar to this when SQL Navigator tries to read from them: "[1]:(Error): Access violation at address 000007FED4C71C7A in module 'OraOCIEI12.dll'. Read of address 0000000000000010". WORKAROUND: NONE. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 2/23/2018
(0 Ratings)
Who to contact to renew Support Maintenance Contract? (58244)

Who to contact to renew a Support Maintenance Contract? To renew your support maintenance contract, please contact the Customer Support Renewals department. One can Renew Support maintenance contract here.

Product(s): Code Tester for Oracle, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 2/8/2018
(0 Ratings) 5556 views
SQL Navigator asks to enter the license key every time a user logs onto Terminal Server (240236)

If SQL Navigator is installed in a terminal server environment, where the user profiles are removed when the user logs off, SQL Navigator prompts for a license key, every time the user logs back onto the Terminal Server and opens SQL Navigator. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 2/7/2018
(0 Ratings) 1 views
Sometimes a module is set to read only even if it is checked out (239874)

In TeamCoding, a module is set to read only even if it is checked out. This is a sporadic issue. The cause of this issue is unknown. WORKAROUND Close the Edit window and open it again in order to be able to type.

Product(s): SQL Navigator for Oracle
Last Updated On: 2/6/2018
(0 Ratings) 1 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: 2/5/2018
(1 Ratings) 10282 views
"Check for Updates" returns incorrect information (239044)

When clicking on Help | Check for Updates, SQL Navigator provides an incorrect update version (7.0.1) instead of the latest version available. The download link button also points to an incorrect download page. Older versions ...

Product(s): SQL Navigator for Oracle
Last Updated On: 1/30/2018
(0 Ratings) 4 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: 1/15/2018
(0 Ratings) 1102 views
When checking-out and checking-in a package, both spec and body are selected by Toad (237034)

In Team Coding when checking-out a package, there are check boxes to individually select the spec and body of the package. When only checking-in the body, Toad also tries to check-in the spec and sends a message to inform that the module was not checked out. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 1/8/2018
(0 Ratings) 2 views
Where can tutorials be found for SQL Tuning? (19603)

Where can tutorials be found for SQL Tuning? How can queries be optimized in Toad ? There are new improvements regarding SQL Tuning in Toad for Oracle. The best option is taking the training course for Toad for Oracle - Performance- Management. ...

Product(s): QCO SQL Tuning, Toad Xpert Tuning, SQLNav Xpert Tuning, Toad for Oracle...
Last Updated On: 12/22/2017
(0 Ratings) 6811 views
Can't login to Toad. What is the Toad password? (80949)

Cannot or unable to login. What is the Toad 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? ...

Product(s): Toad Edge, Toad for SAP Solutions, Toad Data Point, Toad Data Modeler...
Last Updated On: 12/15/2017
(2 Ratings) 13712 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: 12/7/2017
(0 Ratings) 1757 views
SQL Optimizer does not recognize the SQL Navigator Development Suite license key (234865)

SQL Navigator is installed on a machine and has a Development Suite license key entered in it. On the same machine is SQL Optimizer for Oracle. The Development Suite key should give access to SQL Optimizer, but SQL Optimizer is not recognizing the license key. ...

Product(s): SQL Optimizer for Oracle, SQL Navigator for Oracle
Last Updated On: 11/28/2017
(0 Ratings) 17 views
'ORA-28009: connection as SYS should be as SYSDBA or SYSOPER' when reconnecting a SYSDBA session (234478)

In v7.4, When you connect as the SYS user (as SYSDBA) and then go to Session | Reconnect, SQL Navigator doesn't reconnect, with the error: 'Error occurred: [28009] (ORA-28009: connection as SYS should be as SYSDBA or SYSOPER)' This only happens for the SYS user ...

Product(s): SQL Navigator for Oracle
Last Updated On: 11/13/2017
(0 Ratings) 34 views
The auto-complete functionality doesn't work properly when referencing a wrapped package spec in the Editor (234480)

In v7.4, the auto-complete functionality doesn't work properly when referencing a wrapped package spec in the Editor. After typing the '.' the auto-complete box pops up for a brief second and disappears. In v6.x, it works fine on the same wrapped package spec. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 11/13/2017
(0 Ratings) 40 views
Prompt for check in all on exit setting does not work (234341)

Under Team coding options, setting "Prompt for check-in all on exit" does not work. When this option is selected, SQL Navigator does not prompt anything when closing it, even though there are objects checked out. This happens ...

Product(s): SQL Navigator for Oracle
Last Updated On: 11/7/2017
(0 Ratings) 39 views
Encoding Problem when having more than 3 connections opened (234307)

Problems when copying and paste code between sessions with different encodings. This only happens sometimes(this depends on how many connections to different db's are active) . The error is like this: 09:18:47 Start Script Execution ... ...

Product(s): SQL Navigator for Oracle
Last Updated On: 11/6/2017
(0 Ratings) 39 views
Toad Data Modeler installation error: "This installation package could not be opened..." (82339)

When trying to install, the error message below is shown: "This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package.". RESOLUTION 1: Please check ...

Product(s): Toad Data Modeler, SQL Navigator for Oracle
Last Updated On: 10/30/2017
(0 Ratings) 133 views
Silent installation of SQL Navigator 7.4 fails with error status 1603 (233806)

Using the .msi installer for SQL Navigator 7.4, the installation fails with error status 1603. The installer is launched using command line and contains the - v argument which generates an error log. Within the error log the following appears: Error 1606. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 10/30/2017
(0 Ratings) 68 views
Team Coding: Opening Team Coding Summary Info taks a long time. (234000)

Opening Team Coding Summary Info takes a long time (12 minutes) to open. WORKAROUND: None. SOLUTION: Waiting for a fix in a future release of SQL Navigator.

Product(s): SQL Navigator for Oracle
Last Updated On: 10/30/2017
(0 Ratings) 55 views
Compiling objects from Find Objects crashes SQL Navigator (234065)

When finding, for example, invalid objects with "Find Objects" and then select several objects (more than 15) and right clicking -> Compile, SQL Navigator crashes. WORKAROUND. None. SOLUTION. Waiting for a fix in a future version of SQL Navigator.

Product(s): SQL Navigator for Oracle
Last Updated On: 10/30/2017
(0 Ratings) 74 views
All objects get the timestamp of the last operation. (234028)

All objects get the timestamp of the last operation. During the check out all objects got the same timestamp. WORKAROUND. None. SOLUTION. Waiting for a fix in a future version of SQL Navigator.

Product(s): SQL Navigator for Oracle
Last Updated On: 10/30/2017
(0 Ratings) 49 views
Team Coding not working when some environments does not have Team Coding installed (234073)

SQL Navigator locks object with the same name in different sessions in a different database. WORKAROUND. None. SOLUTION. Waiting for a fix in a future version of SQL Navigator.

Product(s): SQL Navigator for Oracle
Last Updated On: 10/30/2017
(0 Ratings) 52 views
IntelliSense does not work for nested queries. (233995)

IntelliSense works correctly for simple queries, but does not work for nested queries. WORKAROUND: None. SOLUTION: Waiting for a fix in a future release of SQL Navigator.

Product(s): SQL Navigator for Oracle
Last Updated On: 10/30/2017
(0 Ratings) 55 views
The execution of many lines as insert statement is very slow. (234069)

The execution of many lines (10000 lines for example) as insert statement is very slow, even if the "Echo SQL" is disabled. WORKAROUND. None. SOLUTION. Waiting for a fix in a future version of SQL Navigator for Oracle.

Product(s): SQL Navigator for Oracle
Last Updated On: 10/30/2017
(0 Ratings) 56 views
Team Coding Manager refresh takes long time. (234027)

Opening that function goes OK, but refreshing (F5) takes long time. WORKAROUND. None. SOLUTION. Waiting for a fix in a future release of SQL Navigator.

Product(s): SQL Navigator for Oracle
Last Updated On: 10/30/2017
(0 Ratings) 57 views