SQL Navigator Forum - SQL Navigator - Toad World

SQL Navigator Forum

Danny Torres
Follow / 1 Nov 2016 at 1:28pm / SQL Navigator

We are now on Twitter!!! Contact a Technical Support expert today...

Expand content
Do you have a quick support question and short of time? Contact us Via Twitter @ QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

Do you have a quick support question and short of time? Contact us Via Twitter  @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

447 0 / Create an account to join the discussion.
Martin
Follow / 19 Jun 2017 at 8:46am / SQL Navigator
Latest post by on 19 Jun 2017 at 9:49am

Fwd: SQL Navigator Weekly Digest - 21 May 2017

Expand content
Hey guys! Maybe you can help me with the issue below? Or forward it to someone who can help? Martins ---------- Forwarded message ---------- From: Martins < miersuzzemes@gmail.com > Date: 12 June...
Hey guys!

Maybe you can help me with the issue below? Or forward it to someone who can help?

Martins

---------- Forwarded message ----------
From: Martins <miersuzzemes@gmail.com>
Date: 12 June 2017 at 10:24
Subject: Fwd: SQL Navigator Weekly Digest - 21 May 2017
To: admin@toadworld.com


Hey, can you help me on this issue? I'm still getting those digest emails and cannot unsubscribe from them.

---------- Forwarded message ----------
From: Martins <miersuzzemes@gmail.com>
Date: 22 May 2017 at 13:26
Subject: Fwd: SQL Navigator Weekly Digest - 21 May 2017
To: admin@toadworld.com


Hi.

I've tried to unsubscribe from the e-mail digests for MONTHS.
Every time I go back to the page https://www.toadworld.com/user/settings tab "Email digests" the settings are back to "Subscribed".
How can I unsubscribe?

Martins.

---------- Forwarded message ----------
From: <info@toadworld.com>
Date: 21 May 2017 at 19:23
Subject: SQL Navigator Weekly Digest - 21 May 2017
To: Martin <miersuzzemes@gmail.com>


 
 
Forums
Weekly Digest
May 21
2017
SQL Navigator at Toad World
 
 
 
 
New in
Forums
 
SQL Navigator - Beta Forum
  •  
Mon, May 15 Formatting issue with the aliases. (0)
 
martin_goblet
 
Don't want to receive notifications? Adjust your email settings.



47 2 / Create an account to join the discussion.
martin_goblet
Follow / 7 Jun 2017 at 1:09pm / SQL Navigator
Latest post by on 19 Jun 2017 at 8:01am

SQL Nav 7.3 32 bit forgets the saved name

Expand content
Hi I'm working on a large SQL statement and I save this one regularly. Each time he asks me to give a name, even if the file has already a name. Regards Martin

Hi

I'm working on a large SQL statement and I save this one regularly.  Each time he asks me to give a name, even if the file has already a name.

Regards

Martin

82 2 / Create an account to join the discussion.
ashmelev
Follow / 13 Aug 2010 at 5:38pm / SQL Navigator
Latest post by on 18 Jun 2017 at 3:41pm

SQL Navigator 6.3 crashes when trying to open a package body

Expand content
Logged as read-only user on our production DB, trying to view the package body code in the production schema. SQL Navigator crashes: Problem signature: Problem Event Name: APPCRASH Application Name: sqlnavigator...

Logged as read-only user on our production DB, trying to view the package body code in the production schema. SQL Navigator crashes:

Problem signature:
  Problem Event Name:    APPCRASH
  Application Name:    sqlnavigator.exe
  Application Version:    6.3.0.1833
  Application Timestamp:    2a425e19
  Fault Module Name:    KERNELBASE.dll
  Fault Module Version:    6.1.7600.16385
  Fault Module Timestamp:    4a5bdbdf
  Exception Code:    ebad5417
  Exception Offset:    0000b727
  OS Version:    6.1.7600.2.0.0.256.48
  Locale ID:    1033
  Additional Information 1:    146a
  Additional Information 2:    146a122927a62bddf791d5e498aa2152
  Additional Information 3:    a6be
  Additional Information 4:    a6be457bab23b7b708b047680d6f97e4

3929 4 / Create an account to join the discussion.
martin_goblet
Follow / 7 Jun 2017 at 7:22am / SQL Navigator
Latest post by on 7 Jun 2017 at 8:40am

Sql Nav 7.3 32 bit, Win 7 64 bit : crash when I close a session

Expand content
Hi Yesterday I got a crash when I closed one of my sessions and today again : I've actually 2 sessions opened at the same time (development / test) Trace dated from 08:01 AM : ======...

Hi

Yesterday I got a crash when I closed one of my sessions and today again :

I've actually 2 sessions opened at the same time (development / test)

Trace dated from 08:01 AM :

===========================================================
### Product Version = 7.3.0.4294 | 20170607 08:01:18:227
### Build Number = 4294 | 20170607 08:01:18:232
### Original Filename = sqlnavigator.exe | 20170607 08:01:18:234
### Bits: 32-bit | 20170607 08:01:18:236
### ** System Locale Information ** | 20170607 08:01:18:238
### Language = French | 20170607 08:01:18:241
### Country = Belgium | 20170607 08:01:18:243
### Default Language Id = 080c | 20170607 08:01:18:245
### Default Country Id = 32 | 20170607 08:01:18:248
### Decimal Separator = . | 20170607 08:01:18:250
### Thousand Separator = | 20170607 08:01:18:253
### Digit Grouping = 3;0 | 20170607 08:01:18:255
### Number of Digits = 2 | 20170607 08:01:18:258
### Short Date Format = d/MM/yyyy (7/06/2017) | 20170607 08:01:18:260
### Long Date Format = dddd d MMMM yyyy (mercredi 7 juin 2017) | 20170607 08:01:18:262
### Short Time Format = hh:mm (08:01) | 20170607 08:01:18:265
### Long Time Format = hh:mm:ss (08:01:18) | 20170607 08:01:18:267
### ** Application Overwritten Locale Info ** | 20170607 08:01:18:270
### Short Date Format = DD/MM/yyyy (07/06/2017) | 20170607 08:01:18:272
### Long Time Format = hh:mm:ss (08:01:18) | 20170607 08:01:18:275
### Windows Version: Windows 7 | 20170607 08:01:18:277
### Windows Theme: Windows | 20170607 08:01:18:280
### UI Style in Preferences: XP | 20170607 08:01:18:283
### TSessionListItem.Create: @196165168 | 20170607 08:01:24:329
>++ CheckMigrationStatus | 20170607 08:01:28:684
### Status in: msUnknown | 20170607 08:01:28:693
### Schema: | 20170607 08:01:28:732
### Table: | 20170607 08:01:28:742
### Options: 0 | 20170607 08:01:28:751
### Version: | 20170607 08:01:28:760
### out_res: 0 | 20170607 08:01:28:769
### Status out: msNotInstalled | 20170607 08:01:28:777
<-- CheckMigrationStatus | 20170607 08:01:28:782

Trace dated from 08:12 :

===========================================================
### Product Version = 7.3.0.4294 | 20170607 08:00:50:170
### Build Number = 4294 | 20170607 08:00:50:193
### Original Filename = sqlnavigator.exe | 20170607 08:00:50:195
### Bits: 32-bit | 20170607 08:00:50:197
### ** System Locale Information ** | 20170607 08:00:50:199
### Language = French | 20170607 08:00:50:202
### Country = Belgium | 20170607 08:00:50:204
### Default Language Id = 080c | 20170607 08:00:50:206
### Default Country Id = 32 | 20170607 08:00:50:208
### Decimal Separator = . | 20170607 08:00:50:211
### Thousand Separator = | 20170607 08:00:50:213
### Digit Grouping = 3;0 | 20170607 08:00:50:215
### Number of Digits = 2 | 20170607 08:00:50:217
### Short Date Format = d/MM/yyyy (7/06/2017) | 20170607 08:00:50:220
### Long Date Format = dddd d MMMM yyyy (mercredi 7 juin 2017) | 20170607 08:00:50:222
### Short Time Format = hh:mm (08:00) | 20170607 08:00:50:224
### Long Time Format = hh:mm:ss (08:00:50) | 20170607 08:00:50:227
### ** Application Overwritten Locale Info ** | 20170607 08:00:50:229
### Short Date Format = DD/MM/yyyy (07/06/2017) | 20170607 08:00:50:232
### Long Time Format = hh:mm:ss (08:00:50) | 20170607 08:00:50:234
### Windows Version: Windows 7 | 20170607 08:00:50:237
### Windows Theme: Windows | 20170607 08:00:50:239
### UI Style in Preferences: XP | 20170607 08:00:50:242
### TSessionListItem.Create: @195247664 | 20170607 08:00:53:613
>++ CheckMigrationStatus | 20170607 08:00:57:164
### Status in: msUnknown | 20170607 08:00:57:173
### Schema: | 20170607 08:00:57:239
### Table: | 20170607 08:00:57:248
### Options: 0 | 20170607 08:00:57:256
### Version: | 20170607 08:00:57:265
### out_res: 0 | 20170607 08:00:57:277
### Status out: msNotInstalled | 20170607 08:00:57:282
<-- CheckMigrationStatus | 20170607 08:00:57:288
### TSessionListItem.Create: @248363840 | 20170607 08:11:42:891
>++ CheckMigrationStatus | 20170607 08:11:43:088
### Status in: msUnknown | 20170607 08:11:43:093
### Schema: | 20170607 08:11:43:101
### Table: | 20170607 08:11:43:106
### Options: 0 | 20170607 08:11:43:111
### Version: | 20170607 08:11:43:116
### out_res: 0 | 20170607 08:11:43:119
### Status out: msNotInstalled | 20170607 08:11:43:122
<-- CheckMigrationStatus | 20170607 08:11:43:125
### TSessionListItem.Destroy: @248363840 | 20170607 08:12:32:979

EL file error :

Exception:
------------------------------------------------------------------------------------------------------------------
2.1 Date : Wed, 7 Jun 2017 08:12:33 +0200
2.2 Address : 00690048
2.3 Module Name : sqlnavigator.exe - (SQL Navigator)
2.4 Module Version: 7.3.0.4294
2.5 Type : EAccessViolation
2.6 Message : Access violation at address 00690048 in module 'sqlnavigator.exe'. Write of address D6A3EBFB
2.7 ID : 27F90000
2.8 Count : 0
2.9 Status : New
2.10 Note :
2.11 Sent : 0

if you need the complete file I can send it.

Regards

Martin

78 1 / Create an account to join the discussion.
srajaram
Follow / 9 May 2017 at 9:51pm / SQL Navigator
Latest post by on 10 May 2017 at 3:33pm

SQL Navigator 7.2.0 Oracle 11g 32 bit- cannot find oracle client

Expand content
Hello, I have installed Oracle client 11g (not instant) with administrator option in Windows 10. The oracle installation was successful, however when I tried launching SQL Navigator, it threw me an error...

Hello,

I have installed Oracle client 11g (not instant) with administrator option in Windows 10. The oracle installation was successful, however when I tried launching SQL Navigator, it threw me an error that it could not find Oracle client.

Please see the attached screenshots.

Please advise.

Thanks.

248 9 / Create an account to join the discussion.
mourad.bilog
Follow / 4 May 2017 at 12:44pm / SQL Navigator
Latest post by on 9 May 2017 at 10:30am

Display results stored procedure resturns SYS_REFCURSOR

Expand content
Hello everybody, I'm using Toad 12.10 and Oracle 11 64 bits. I've a package of stored procedure and when I execute a procedure that returns a sys_refcursor nothing is displayed as shown below...

Hello everybody,

I'm using Toad 12.10 and Oracle 11 64 bits. I've a package of stored procedure and when I execute a procedure that returns a sys_refcursor nothing is displayed as shown below 

Note that I've shoosen to display results in a grid as indicated below 

Can anyone tell me were I'm wrong and how to resolve this problem.

Regards.

164 1 / Create an account to join the discussion.
martin_goblet
Follow / 9 May 2017 at 7:19am / SQL Navigator
Latest post by on 9 May 2017 at 10:19am

Table alias by default

Expand content
Hi In preferences, there is a parameter for the table alias : I would like to have the real table name as alias, not "a" or another letter. I tried to remove the "a", but it always...

Hi

In preferences, there is a parameter for the table alias :

I would like to have the real table name as alias, not "a" or another letter.  I tried to remove the "a", but it always comes back.  Is this possible ?

Regards

Martin

114 1 / Create an account to join the discussion.
martin_goblet
Follow / 27 Feb 2017 at 10:20am / SQL Navigator
Latest post by on 7 Apr 2017 at 12:26pm

Block_changes

Expand content
Hi I'm running a big SQL statement with absolutely no updates. Why does the session manager show bloc_changes / consistent_changes on this statement : Regards Martin

Hi

I'm running a big SQL statement with absolutely no updates.  Why does the session manager show bloc_changes / consistent_changes on this statement :

Regards

Martin

411 2 / Create an account to join the discussion.
egirdhar
Follow / 25 Jan 2017 at 1:46pm / SQL Navigator
Latest post by on 6 Apr 2017 at 7:32am

Unable to see GIT project panel while adding VCS project to team project...

Expand content
Hi, I am new to sql navigator and trying to connect it to GitHub. I can configure the GIT in VCS when there is no active connection to database. (screenshot -1) When I try to add the team project...

Hi, 

I am new to sql navigator and trying to connect it to GitHub.  

  1. I can configure the GIT in VCS when there is no active connection to database. (screenshot -1)
  2. When I try to add the team project, it says, it requires active connection. (screenshot -2)
  3. When I try to login as Sys (only this user can install team coding ) and try to add VCS Project to new team project, It shows VSS window login panel (should show git panel). Not sure how to get git login panel  over here. (screenshot -3)

  as per https://bradwulf.wordpress.c

om/2016/0 6/06/sql-nav igator-team-coding-with-git/ , it should provide panel to select git project.   Please revert with help if I am missing anything. 

380 1 / Create an account to join the discussion.
therpress
Follow / 22 Feb 2017 at 5:53pm / SQL Navigator
Latest post by on 6 Apr 2017 at 7:25am

Just Started using SQL Navigator 7.1 Data Modeler/Relations Model...

Expand content
I have just started using SQL Navigator 7.1. I am used using SQL developer 4.0. In SQL developer 4 I am able to click VIEW>Data Modeler>CLICK BROWSER for Browser pane,>within the pane expand designs>right...

I have just started using SQL Navigator 7.1.     I am used using  SQL developer 4.0. In SQL developer 4 I am able to click VIEW>Data Modeler>CLICK BROWSER for Browser pane,>within the pane expand designs>right click relational models>new relational models once a pane is open for the relation model I can drag and drop specific tables to create a relational model. .   Can someone please direct me on how to do this in SQL Navigator 7.1.0

Thank you

335 1 / Create an account to join the discussion.
rclark
Follow / 17 Mar 2017 at 6:13pm / SQL Navigator
Latest post by on 17 Mar 2017 at 6:19pm

Compare SQL Navigator 5.5 to current version

Expand content
Hi, Can someone give an overview of the difference between 5.5 and the current version and the benefit of upgrading? Also, what advantages does it offer over SQL Developer? Thanks

Hi,

Can someone give an overview of the difference between 5.5 and the current version and the benefit of upgrading? 

Also, what advantages does it offer  over SQL Developer?


Thanks

Unanswered 258 1 / Create an account to join the discussion.
martin_goblet
Follow / 27 Feb 2017 at 7:52am / SQL Navigator
Latest post by on 27 Feb 2017 at 9:00am

Execution in a tab blocs access to the other tabs

Expand content
Hi I often execute scripts, and during the execution time I work an other one. With the last versions it's nearly impossible. SQL Nav only opens the other tabs when the execution is finished. Example...

Hi

I often execute scripts, and during the execution time I work an other one.  With the last versions it's nearly impossible.  SQL Nav only opens the other tabs when the execution is finished.

Example : I ran the forth tab and wanted to work on the first one : that's what I get.  The first tab will open when the execution of the fourth tab is finished (in this case in 2 hours !)

Regards

Martin

400 4 / Create an account to join the discussion.
licensing-mgmt
Follow / 8 Feb 2017 at 2:53pm / SQL Navigator
Latest post by on 21 Feb 2017 at 1:01pm

SQL Nav panel display problems when using multiple monitors

Expand content
SQL Navigator 7.3.0.4294 Windows 10 Enterprise 64-bit Version 1511 Lenovo T450s I have multiple displays,two external monitors and the laptop display, and have encountered a variety of window/panel...

SQL Navigator 7.3.0.4294

Windows 10 Enterprise 64-bit Version 1511 

Lenovo T450s

I have multiple displays,two external monitors and the laptop display, and have encountered a variety of window/panel display problems. The problems occur when shutdown in hibernate mode and reopen on a different multiple monitor environment (same number of displays) Most frequently, SQL Nav windows end up located outside the edges of the physical displays and have to be manually moved into the physical display space. Less frequently, the layering and position of modal dialogs is behind the window from which the dialog was initiated from and, again, have to be manually relocated from behind the main window.

TIA

461 3 / Create an account to join the discussion.
OracleDBA
Follow / 18 Feb 2017 at 6:38pm / SQL Navigator
Latest post by on 20 Feb 2017 at 9:33am

how do i write rules in sql navigator codexpert?

Expand content
I have code expert on my sql nav. How do I write rules so I can use code expert to help me with my pl / sql code reviews?

I have code expert on my sql nav. How do I write rules so I can use code expert to help me with my pl / sql code reviews? 

340 1 / Create an account to join the discussion.
nam.kim
Follow / 9 Feb 2017 at 12:48am / SQL Navigator
Latest post by on 20 Feb 2017 at 9:24am

SQL Navigator 7.3 x86 (32-bit) : issues

Expand content
We are using Windows 10, Oracle 12c 32x Client, and SQL Nav 7.3 32x. One of Oracle DBA cannot query which added a new column on table, he have to restart SQL/Nav, then work. Is there any suggestion...

We are using Windows 10, Oracle 12c 32x Client, and SQL Nav 7.3 32x.

One of Oracle DBA cannot query which added a new column on table, he have to restart SQL/Nav, then work.

Is there any suggestion?

(FYI.. my machine is working fine.)

Unanswered 460 1 / Create an account to join the discussion.
martin_goblet
Follow / 10 Feb 2017 at 7:36am / SQL Navigator
Latest post by on 17 Feb 2017 at 7:45am

Refresh in a compare crashes

Expand content
Hi When I do a refresh (F5 or play button) in a Compare, SQL Nav >= 7.3 v 32 bit crashes : Regards Martin

Hi

When I do a refresh (F5 or play button) in a Compare, SQL Nav >= 7.3 v 32 bit crashes :

Regards

Martin

358 1 / Create an account to join the discussion.
martin_goblet
Follow / 8 Sep 2016 at 9:43am / SQL Navigator
Latest post by on 17 Feb 2017 at 6:54am

Statement still executes, even after a STOP !

Expand content
Hi When I run a SELECT with a related database (@...), I'm not able to stop this one. It still runs to the end. Regards Martin

Hi

When I run a SELECT with a related database (@...), I'm not able to stop this one.  It still runs to the end.

Regards

Martin

1005 6 / Create an account to join the discussion.
martin_goblet
Follow / 6 Jun 2016 at 10:57am / SQL Navigator
Latest post by on 23 Jan 2017 at 7:16am

New constraint

Expand content
Hi Right clic on Constraints tab + New : I expected to create a new contraint, but I get the "New table" screen. Same with the other tabs index and triggers, ... Could it be possible to...

Hi

Right clic on Constraints tab + New : I expected to create a new contraint, but I get the "New table" screen.  Same with the other tabs index and triggers, ...

Could it be possible to associate the right clic with the tab, like it does in the middle of the window :

Regards

Martin

774 4 / Create an account to join the discussion.
DHaessel
Follow / 19 Jan 2017 at 5:27pm / SQL Navigator
Latest post by on 22 Jan 2017 at 1:12am

How do you delete the initial database load

Expand content
I would like to clean out the default databases it is loading in SQL Navigator 6.7. I tried regedit and tried to find the directory it was loaded to but couldn't find it. I just want to kill off...

I would like to clean out the default databases it is loading in SQL Navigator 6.7.

I tried regedit and tried to find the directory it was loaded to but couldn't find it.  I just want to kill off the list of databases loaded at startup so it is kind of clean (for instance kill the local settings so it is like a clean install for instance).

470 2 / Create an account to join the discussion.