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.
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.
Unable to download installer for latest version. ... When trying to download, the following message is returned.<br><br>"Our records show that your maintenance is expired. ... Please contact Support Renewals to renew your support" Support Maintenance contract has expired and is not longer valid.
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.
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.
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:
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.)
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?
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.
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.
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.
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.
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."
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.
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.
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.
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.
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.
Which version of SQL Navigator is supported on Windows 10? ... Versions 7.3 and above support installation on Windows 10
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.
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.
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 "IN_PARAMETER_ENG" when expecting one of the following:<br>10:20:32 := . ( @ % ;<br>10:20:32 The symbol "(" was substituted for "IN_PARAMETER_ENG" 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
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.
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.
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.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center