Chat now with support
Chat with Support

NOTICE! We are upgrading our support telephone services, implementing Genesys, starting the week of May 19, 2025

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 51-75 of 2557
How does Toad and SQL Navigator access the tnsnames.ora file and info? How do you change/specify (4226273)

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.

Product(s): Toad for Oracle, SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 6500 views
Knowledge Article
Unhandled Exception at startup - I/O error 123 when creating template with special character in t (4323793)

Then many "Access Violation at address 77F69ECD in module 'ntdll.dll'. ... Write of address 00455710." errors are received. ... This happens when creating a template with a special character in the name.

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 569 views
Knowledge Article
Get message saying maintenance is expired when downloading. (4241746)

Unable to download installer for latest version. ... When trying to download, the following message is returned.<br><br>&quot;Our records show that your maintenance is expired. ... Please contact Support Renewals to renew your support&quot; Support Maintenance contract has expired and is not longer valid.

Product(s): Toad Data Point, Toad for Oracle, SQL Navigator for Oracle, Toad Data...
Last Updated On: 5/7/2023
NA rating | 2138 views
Knowledge Article
Error when launching or connecting: "Unhandled Exception error : OCI.dll can not be found." (4291001)

OR ... "Cannot load OCI DLL: oci.dll" ... 1) SQL Navigator requires that an Oracle client be installed and working properly before connecting to a database. ... 2) SQL Navigator does not support 64-bit clients.

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 954 views
Knowledge Article
How to download SQL Navigator from SupportLink. (4251123)

3. If you have a SupportLink account, then log in. ... If you do not have one, click "Register" and go through the registration process. ... Make sure you have your Site ID information. ... If you get and error saying your maintenance contract is expired you will need to contact sales to renew your account.

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 257 views
Knowledge Article
How to download a commercial software installer? Need installer by FTP or mail. (4290597)

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 Data Point, Toad Edge, Toad Intelligence Central, Toad for Oracle...
Last Updated On: 5/7/2023
NA rating | 10931 views
Knowledge Article
Dual Monitor not supported in SQL NAV (4339529)

Dual monitor works fine in a dual monitor environment, but when launching SQL NAV in a single monitor shows in taskbar but not visible from screen. ... 1. Launch SQL NAV ... 2. Press (ALT+SPACE) + R (This restores the window if it is maximized; if not, nothing will happen.)

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 180 views
Knowledge Article
How to get or obtain an older version of SQL Navigator or Toad for Oracle? (4310332)

Technical Support website only has the past few versions of SQL Navigator and Toad for Oracle available for download. ... How can a download for an older version of a product be obtained? ... How and where to find older versions?

Product(s): Toad for Oracle, SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 2011 views
Knowledge Article
Position of results window does not save when closing SQL Navigator (4239194)

If the results window (center) in the SQL Editor is adjusted and then SQL Navigator is closed the size adjustment made to the results window does not save. ... This opens up the SQL Editor with a blank full screen.

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 271 views
Knowledge Article
Server output is not displaying dbms_output messages (4305676)

When the server output is turned ON, the dbms_output messages are not displayed in the output window or in the spool. ... none ... STATUS: ... Waiting for fix in a future release of SQL Navigator for Oracle.

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 160 views
Knowledge Article
Error: "15:31:23 Cannot open clipboard" when using Ctl+C. (4317378)

The text is copied into the clipboard. ... After receiving the error once, every time a user tries to copy something Navigator returns the same error message. ... 1. Open SQL Navigator. ... 2. Right-click to the Main Menu and select Customize.

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 122 views
Knowledge Article
What objects are install during installation of "Server-Side Installation", how do I install them (4337320)

The Server Side Install refers to creating certain objects on your database, which are required for particular features of SQL Navigator to be available. ... You do not need to do the Server Side Install if you do not need the option provided by it.

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 213 views
Knowledge Article
Error: "Code Assistant Code Catalog file could not be found and cannot be created. Please check t (4291387)

Error when launching SQL Navigator, after upgrading to version 5.1: "Code Assistant Code Catalog file could not be found and cannot be created. ... The following errors may also appear: "Code Assistant SQL Catalog not found." "Unhandled exception at start up - file not found."

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 394 views
Knowledge Article
Error when Connecting to Database: "ORA-03106: FATAL TWO-task communication protocol error" (4297436)

Error when trying to connect to database: ... 1. Oracle Client configuration not recognized by SQL Navigator. ... 2. Multiple clients installed and SQL Navigator is using wrong one. ... 3. Client version needs to be updated.

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
4 rating | 4223 views
Knowledge Article
Does SQL Navigator support Unicode databases? (4290644)

Does SQL Navigator support UTF8 or Unicode or multi-byte character databases? ... SQL Navigator 5 will connect to a UTF8 database and display data that is made up of single-byte characters; however, if the data contains multi-byte characters, SQL Navigator will not be able to display them correctly.

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
5 rating | 822 views
Knowledge Article
Output Window is not visible or does not show. I lost the Output Window. How can I get it back? (4297582)

How do I get it or bring it back? ... This usually occurs when the window is inadvertently dragged out of the normal viewing area. ... ****WARNING: Using Registry Editor incorrectly can cause serious problems that can damage the operating system and the software installed.

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 2118 views
Knowledge Article
Setting two conditional break points (4334607)

Setting two conditional break points on a fetched cursor will not stop at a break point. ... Example: ... BEGIN ... OPEN c_students; LOOP ... FETCH c_students INTO v_studentid, v_FirstName, v_LastName; --break point here.

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 259 views
Knowledge Article
Different behaviour when working with SQL Navigator compared to TOAD For Oracle (4278518)

When Team Coding schema was created in SQL Navigator and then changed in Toad for Oracle it become unusable in SQL Navigator. ... Use one tool or another, but not both together.

Product(s): Toad for Oracle, SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 2192 views
Knowledge Article
SQL Navigator support for Windows 10. (4237160)

Which version of SQL Navigator is supported on Windows 10? ... Versions 7.3 and above support installation on Windows 10

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 1160 views
Knowledge Article
Keep getting the message NO CONNECTION after reconnecting to the database (4334063)

While working with SQLNav and users get disconnect from network accidentally ( i.e cable network was unplugged, the session was killed ) they can't reconnect to SQL Nav again without completely close out SQL Navigator application and reopen a new one.

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 418 views
Knowledge Article
No database drop-down list for log on. (4255417)

When clicking at SQL Navigator Logon Screen, I cannot see the database drop-down list; however, I can still get connected to database if the connection information is typed in manually. ... NOTE: If you have multiple homes, then make sure to add the TNS_ADMIN to the correct home being used.

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 168 views
Knowledge Article
ORA-06502: PL/SQL: numeric or value error: character string buffer too small when adding Hebrew parameter in debugger (4238602)

When trying to add a Hebrew parameter when debugging a procedure, the following error appears when pressing F7:<br><br>10:20:32 ORA-06550: line 6, column 6:<br>10:20:32 PLS-00103: Encountered the symbol &quot;IN_PARAMETER_ENG&quot; when expecting one of the following:<br>10:20:32 := . ( @ % ;<br>10:20:32 The symbol &quot;(&quot; was substituted for &quot;IN_PARAMETER_ENG&quot; to continue.<br> <br>13:52:59 ORA-06502: PL/SQL: numeric or value error: character string buffer too small<br>13:52:59 ORA-06512: at line Issue occurs if Oracle 10.1 client is in use Please install at least a 10.2 Oracle client, and this will resolve the issue. SQLNAV-1927

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 3805 views
Knowledge Article
Editor, Executing a query returns OCI_INVALID_HANDLE message. (4275301)

The same issue is not apparent with version 7.1. ... WORKAROUND: ... Downgrade to SQL Navigator for Oracle version 7.1. ... The 7.1 version can be downloaded here. ... The OCI_INVALID_HANDLE error has been fixed in v7.3 beta.

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 1223 views
Knowledge Article
SQL Navigator cannot checkout from Team Foundation Server 2015 (4278559)

When trying to check out from the TFS, the following error appears: ... Value '272' is not a valid for ImageSize.Width' shoud be between 1 and 256. ... 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: 5/7/2023
NA rating | 1613 views
Knowledge Article
Save/Export to clipboard as Insert statement returns wrong table in script (4270236)

Pasting the result returns the incorrect schema. ... Uncheck the option to "Use from clause". ... and/or ... The option allows changing the insert table to a new name in that one does not have to turn around and do a global change after pasting the values, if inserting into a different table.

Product(s): SQL Navigator for Oracle
Last Updated On: 5/7/2023
NA rating | 798 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