SQL Navigator Forum

Vignesh.chandrasekeran
Follow / 9 Aug 2018 at 10:50am / SQL Navigator

stread read error while describing object

Expand content
Whenever I try to describe an object, the describing page goes blank with the object name on top and then a pop up error message says that there is a 'stream read error'. Please assist.

Whenever I try to describe an object, the describing page goes blank with the object name on top and then a pop up error message says that there is a 'stream read error'. Please assist.

Unanswered 0 0 / Replies are disabled.
veda
Follow / 2 Nov 2009 at 1:29pm / SQL Navigator
Latest post by on 3 Aug 2018 at 12:42pm

Trial version authorisation key!!!!

Expand content
Hi, I had downloaded the trial version of sqlnavigator from the quest site and installed, but it is asking for authorisation key to open sqlnavigator. How to get the trial version authorisation key??
Hi,
     I had downloaded the trial version of sqlnavigator from the quest site and installed, but it is asking for authorisation key to open sqlnavigator. How to get the trial version authorisation key??
35969 31 / Replies are disabled.
maslang
Follow / 11 Jun 2018 at 8:43am / SQL Navigator
Latest post by on 3 Aug 2018 at 9:39am

key to the beta tester SqlNavigator sqlnav_7.5.0.74_Beta_64bit

Expand content
I can not install the latest version. When I launch the application I get this message: The license key is invalid. Reason: The license key has expired. Please contact Quest sales representative to purchase...

I can not install the latest version.
When I launch the application I get this message:
The license key is invalid. Reason: The license key has expired. Please contact Quest sales representative to purchase the product or get a trial extension.

What is the key to the beta tester?
Thank you in advance

Answered 345 3 / Replies are disabled.
amian
Follow / 20 Jun 2018 at 5:07pm / SQL Navigator
Latest post by on 26 Jun 2018 at 5:52pm

SQl Nav 7.4.0.62 standard edition: can't see parameters

Expand content
I have run into a problem where when I go to run a procedure it does not show parameters: Procedures are listed alphabetically, any procedure with name starting from OR, I am unable to see the parameters...

I have run into a problem where when I go to run a procedure it does not show parameters:

Procedures are listed alphabetically, any procedure with name starting from OR, I am unable to see the parameters when I go to run the procedure.

Example:

Take this code:

PROCEDURE dummy2
(year IN number)
IS
-- Purpose: Briefly explain the functionality of the procedure
--
-- MODIFICATION HISTORY
-- Person Date Comments
-- --------- ------ -------------------------------------------

BEGIN
null;
END;

So I hit F9 or the run arrow and it will bring me to the run screen and this will show 1 parameter year where I can type a number

same code but change the name to something after OR:

PROCEDURE organisation 
(year IN number)
IS
-- Purpose: Briefly explain the functionality of the procedure
--
-- MODIFICATION HISTORY
-- Person Date Comments
-- --------- ------ -------------------------------------------

BEGIN
null;
END;

When I go to the run screen, I don't see any parameters

I thought this was because of number of procedures, but it is not.

Example:

Procedure names(I have over 500 procedures): 

dummy2

login

oie_login

organisation 

wave

oie_login shows parameters, but organization and everything after does not.

So I create another procedure oie_organ:

dummy2

login

oie_login

oie_organ

organisation 

wave

It is still organisation where it will start to not show procedures, I can add any number (I added 10),

same code as above, only the procedure name is different:

dummy2

login

oie_login

oie_organ

oq1

oq2

oq3

oq4

oq5

oq6

oq7

oq8

oq9

oq10

organisation 

wave

oq10 shows parameters, organisation and every procedure after doesn't.

We have 2 people on 7.4 and it happens on both.

This does not happen on SQL 6.5 or 7.2, All procedures if they have a parameter will show a parameter.

I tired searching for this issue, but I was not able to find anything, maybe I am wording this incorrectly.

Any help with this would be greatly appreciated,

Thank you.

EDIT: I found this: https://support.quest.com/sql-navigator-for-oracle/kb/230745/when-executing-procedure-not-seeing-input-parameters

But I can't view that article, but my issue is not with all procedures.

Unanswered 435 1 / Replies are disabled.
Diego.Bueno
Follow / 12 Jun 2018 at 6:33pm / SQL Navigator
Latest post by on 15 Jun 2018 at 10:27am

Question about SQL Navigator | Export Packages' DDL

Expand content
How Do I export ALL my Packages in separate files, meaning, if I want to extract the DDL of ALL my procedures / "bulk Packages", can I save header and body in a separate files?

How Do I export ALL my Packages in separate files, meaning, if I want to extract the DDL of ALL my procedures / "bulk Packages", can I save header and body in a separate files?

494 1 / Replies are disabled.
robbi73
Follow / 12 Jul 2017 at 9:19pm / SQL Navigator
Latest post by on 7 Jun 2018 at 6:33am

Cannot update SQL Navigator. I need some help

Expand content
Hello everybody. I have a problem installing SQL Nav 7.3 that my oraganizzation recently purchased both in 32 than 64 bit version. First of all I uninstalled the old version of SQL Navigator then I proceed...

Hello everybody.
I have a problem installing SQL Nav 7.3 that my oraganizzation recently purchased both in 32 than 64 bit version.

First of all I uninstalled the old version of SQL Navigator then I proceed installing the new one.

My pc has installed win 7 64 bit, I have also installed oracle client 11.2.0.1.0 (but if necessary I could install a more recent version)
and I usuallly connect with a oracle 12.1 (12c) db server.
I dont remember well because now I'm not at work, but whether I try to install SQL Nav 7.3 both 32-bit than 64-bit version, at the end of installation,
when I try to connect to the server I get errors such as "missing OCI.dll" or an error that the program can not locate the tnsnamer.ora file.
How should I proceed?
First question: I have to try back installing the 32 bit version or the 64 bit version or it would be the same?
Which version can be considered more stable?
How can I overcome the error messages mentioned above?

Thank in advance.
Roberto

3742 5 / Replies are disabled.
SWITsb
Follow / 30 May 2018 at 3:36pm / SQL Navigator
Latest post by on 5 Jun 2018 at 2:33am

Navigator 7.4 connecting to Oracle 18 db

Expand content
When I try to connect to a Oracle 18 database using SQL Navigator 7.4, The application stops working ! No other explanation is giving

When I try to connect to a Oracle 18 database using SQL Navigator 7.4, The application stops working ! No other explanation is giving

787 3 / Replies are disabled.
kumaran3456
Follow / 1 Jun 2018 at 3:43pm / SQL Navigator
Latest post by on 4 Jun 2018 at 4:48pm

SQL Nav Team Coding Enable Merge is missing

Expand content
New to SQL nav we are trying to enable team cosing in our project and I am not finding Enable Merge option in Show differences window can any please help

New to SQL nav we are trying to enable team cosing in our project and I am not finding Enable Merge option in Show differences window can any please help

747 1 / Replies are disabled.
dcaylor1
Follow / 16 May 2018 at 3:27pm / SQL Navigator
Latest post by on 4 Jun 2018 at 12:25pm

Exporting SQLNAV 7.3.0.4294 to Excel has DATE format issue and shows...

Expand content
(I'm new and tried to locate a post on this before posting, but didn't see any... sorry if this is a duplicate) Exporting SQLNAV 7.3.0.4294 to Excel has bad DATE format Format is "m/d...

(I'm new and tried to locate a post on this before posting, but didn't see any... sorry if this is a duplicate)

Exporting SQLNAV 7.3.0.4294 to Excel has bad DATE format

Format is "m/d/yyyy h:mm:ss \AmPm" but should be "m/d/yyyy h:mm:ss AM/PM" result is a value like "1/17/2018  12:00:00 AM" appears as "1/17/2018  12:00:00 A1P1"

I found mention of this on another forum where a competing product to SQL NAV also had the same problem, but I can't find any mention for SQL NAV.

Thanks

David

Unanswered 802 1 / Replies are disabled.
W.S.
Follow / 7 May 2018 at 11:25am / SQL Navigator
Latest post by on 14 May 2018 at 2:33am

Have problem with Navigator 6.1 with Oracle 12 installation

Expand content
Good day all, I registered on this group only today - 7 May 2018.I never knew this group existed and only found it due to searching for problems I have with SQL Navigator 6.1 and 7.1. I have been using...

Good day all,

I registered on this group only today - 7 May 2018.I never knew this group existed and only found it due to searching for problems I have with SQL Navigator 6.1 and 7.1.

I have been using SQL Navigator since early 2000's since V3, and have the last few years been working on SQL Navigator 6.1. 

This worked fine for me for many years until our company recently installed Oracle 12. I have now issues with 6.1 in that I can not open, view or edit procedures and packages.

I would like to know what causes this, and is there a setting that can fix this ? (For V 6.1). 

When I attempt to open a package, I get this message : example

12:06:15 PACKAGE "PR_AM"."PKG_CALL_CITY_1" recreated
12:06:15 PACKAGE BODY "PR_AM"."PKG_CALL_CITY_1" not found

--------------------------

Then, in my attempts to get past this problem, our company had a V7.1 installation file, quite a few years old. I then installed V7.1. After my install the license was automatically upgraded from 6.3 as valid license, and I could work on V7.1. But I got many problems, and the nr one problem is that Navigator becomes unstable after I do almost nothing and prg crashes.

I then read up on Google and saw there were some similar problems with V7.1 release which were solved on later installations.

I now see V7.4 is available. I now want to install V7.4, but where do I get the installation files ? I do see the installation downloads on Quest website, but they require the client information and detail first, before I am allowed to download the software. I do not have this detail, as I do not know exactly and with what detail my company registered with Quest many years ago.

I just want the download file, preferably for 32 bit and 64, and I am quite sure our license will cover this upgrade. If not the software will tell me, and I can then pursue this further with our company.

------------------------------

I would have no problem carrying on with V6.1, if someone can tell me why I can not open procedures and package.

We do have licensed PL/SQL Developer as well that we use for development, but I am a big SQL Navigator fan.

Thank you for any help.

Unanswered 1194 6 / Replies are disabled.
villyen
Follow / 3 May 2018 at 9:35am / SQL Navigator
Latest post by on 4 May 2018 at 7:49am

SQL Navigator 7.4 XML editor

Expand content
Hi, When ever I try to save to file from the XML editor I get: 10:10:52 Access violation at address 753B5FB6 in module 'KERNELBASE.dll'. Read of address 11F71000 Running Windows 10. Any...

Hi,

When ever I try to save to file from the XML editor I get:

10:10:52 Access violation at address 753B5FB6 in module 'KERNELBASE.dll'. Read of address 11F71000

Running Windows 10.

Any ideas as to what might be causing this? 

Thanks

996 2 / Replies are disabled.
syscureit
Follow / 28 Feb 2018 at 2:47am / SQL Navigator

DATABASE

Expand content
Hey Guys, I edited data value of a grid on a table with commit - but the edited (or changed value) doesn't appear on the actual web host. I mean, I edited a web value on database using SQL navigator...

Hey Guys,

I edited data value of a grid on a table with commit - but the edited (or changed value) doesn't appear on the actual web host.

I mean, I edited a web value on database using SQL navigator - after running the script(commit) the changed value didn't appear on the hosted webpage.

Please need an advice.

Unanswered 1108 0 / Replies are disabled.
DataSplit
Follow / 31 Aug 2015 at 10:59pm / SQL Navigator
Latest post by on 27 Feb 2018 at 1:48am

SQL and MySQL

Expand content
What product would I use if I wanted to connect to both SQL and MySQL databases?

What product would I use if I wanted to connect to both SQL and MySQL databases? 

Unanswered 4377 3 / Replies are disabled.
james.q.zhu
Follow / 7 Feb 2018 at 7:55am / SQL Navigator
Latest post by on 11 Feb 2018 at 5:59am

SQL Navigator 7.4 cann't commit to SVN

Expand content
problem desc: 1、 do 'check out' a package 2、SQL Navigator generate 2 files for this package 3、do 'Check in' 4、you can find SQL Navigator exeute svn 'add' command but not...

problem desc:

1、 do  'check out'  a package

2、SQL Navigator generate 2 files for this package

3、do 'Check in'

4、you can find SQL Navigator exeute svn 'add'  command but not execute 'commit '  command  

so the two package files cann't find in SVN Server. 

anyone know this issue?

Production Version: SQL Navigator 2017 Trial Edition(SQL Navigator 7.4 Trial)

2739 4 / Replies are disabled.
drastogi
Follow / 29 Jan 2018 at 3:26pm / SQL Navigator
Latest post by on 30 Jan 2018 at 5:38pm

SQLNAV 7.4 64-Bit Random crash

Expand content
SQL Navigator 7.4 64-bit on Windows Enterprise 10 64-bit is crashing with the following error: Control 'dpCodeAssistant' has no parent window. Has anyone seen this error or has a suggestion...

SQL Navigator 7.4 64-bit on Windows Enterprise 10 64-bit is crashing with the following error:

Control 'dpCodeAssistant' has no parent window. 

Has anyone seen this error or has a suggestion to resolve? Thanks. 

2649 2 / Replies are disabled.
Vincent Liu
Follow / 17 Aug 2016 at 7:53am / SQL Navigator
Latest post by on 29 Jan 2018 at 12:35pm

SQL Navigator 7.3 is released

Expand content
Dear all, We are very pleased to announce that SQL Navigator version 7.3 has been released. Thank you all for supporting the product and we really appreciate feedbacks and suggestions from you. New...

Dear all,

We are very pleased to announce that SQL Navigator version 7.3 has been released. Thank you all for supporting the product and we really appreciate feedbacks and suggestions from you.

New features in SQL Navigator 7.3:

  • Connection Category Color - Optionally assign a connection to a category color in the Oracle Logon Dialog. Possible categories could be: development, test or production. You could create your own categories and assign colors as appropriate. The color is displayed in the following places in SQL Navigator: the connection entry in the Session toolbar, the border of windows belonging to the connection, task bar icons of windows belonging to the connection and tab icons of the Code Editor window.

  • New Online Search Dialog - When you double click on an error message which contains an Oracle error code, you can now select the online search engine to use to receive detailed Oracle error information from. Options include Google, Online Knowledge Base (maintained by Dell Support), Online Knowledge Xpert (maintained as Toad World Wiki) and Toad World Search.

  • Team Coding - The settings and backend repository are now compatible with Toad for Oracle 12.7. Git is now a supported Version Control System. There are new interfaces to administer Team Coding and manage Team Coding Objects.

  • Windows 10 - Support for Windows 10

     

The complete list of resolved issues and enhancements (for 7.3 release):
http://www.toadworld.com/products/sql-navigator/w/wiki/10945.sql-navigator-resolved-issues-and-enhancements.aspx

Product documentation:
https://support.quest.com/sql-navigator-for-oracle/release-notes-guides 

Download the newest release (upgrade for existing users):
https://support.quest.com/sql-navigator-for-oracle/download-new-releases 

Download trial of the latest release (free trial for new users):
https://www.quest.com/registert/54629/ 

Regards,

SQL Navigator Team

7036 2 / Replies are disabled.
krmckee
Follow / 24 Jan 2018 at 1:47pm / SQL Navigator
Latest post by on 29 Jan 2018 at 6:17am

How to start using SQL Navigator and SVN/Subversion

Expand content
Hi - I recently downloaded a trial of SQL Navigator 7.4 and am trying to integrate it with my SVN server. Here's what I've done so far I connected to one of my databases, then I went to the Team...

Hi - I recently downloaded a trial of SQL Navigator 7.4 and am trying to integrate it with my SVN server.  Here's what I've done so far

I connected to one of my databases, then I went to the Team Coding menu and selected Team Coding Manager

I went to the VCS tab, right clicked and chose Configure

I specified the following options for SVN

(Servername blanked for security reasons, but my server name is in the settings)

I then went back to the Team Coding menu and chose Provider Logon

where it prompted me for my username/password, and then it shows

so I believe I'm connecting to my SVN server fine.

Now what I want to be able to do is take all of my database elements (table DDL, functions, stored procedures, etc) and check them all into SVN so that I can start doing version control.  This is where I get stuck, as there doesn't seem to be any way to do this?  Are my expectations wrong, or am I just missing something?  Any help would be greatly appreciated.

Thanks

2825 1 / Replies are disabled.
virajdodanwala
Follow / 25 Jan 2018 at 12:53pm / SQL Navigator

SQL Navigator 7.4 - Team Coding - Error when try to compare changes...

Expand content
Dears, I am new to this GIT version controlling system and i am trying to use SQL Navigator 7.4 with GIT version controlling system to maintain DB changes. Initial configuration i have done and changes...

Dears, 

I am new to this GIT version controlling system and i am trying to use SQL Navigator 7.4 with GIT version controlling system to maintain DB changes.

Initial configuration i have done and changes are properly pushing to Bitbucket also. But when i try to compare the change of the Database object ( ex: Table change) with the VCS through SQL navigator

( Menu path is Team Coding -> Team Coding Manager . Then expand the DB object and right click on the Table -> Compare Content)

When i select to compare . its giving below error message.

If anyone can help/ Guide to fix this, it would be great.

Unanswered 1577 0 / Replies are disabled.
Fsilva
Follow / 7 Sep 2009 at 2:19pm / SQL Navigator
Latest post by on 22 Dec 2017 at 4:07pm

Bookmarks and formatter

Expand content
Hi Is there any way to keep the bookmarks between formating (it cleans the bookmarks even if the line didn't changed)? thanks Filipe

Hi

Is there any way to keep the bookmarks between formating (it cleans the bookmarks even if the line didn't changed)?

thanks

Filipe

7416 4 / Replies are disabled.
martin_goblet
Follow / 2 Nov 2017 at 8:07am / SQL Navigator
Latest post by on 24 Nov 2017 at 8:32am

Error is not more shown (7.3 32 bit, Win 7 64 pro)

Expand content
Hi I just tried to delete a table an forgot that there is a delete cascade on it. instead of getting the error, I got this : Regards Martin

Hi

I just tried to delete a table an forgot that there is a delete cascade on it.  instead of getting the error, I got this :

Regards

Martin

2981 2 / Replies are disabled.