SQL Navigator Forum

chdodso
Follow / 19 Oct 2017 at 2:40pm / SQL Navigator

Extract DDL Missing ;

Expand content
We've just upgraded to SQL Navigator 7.3 (7.3.0.4294) I extract the DDL for a view to include the grants. When I try to run the script I get ORA-00933: SQL command not properly ended. Troubleshooting...

We've just upgraded to SQL Navigator 7.3 (7.3.0.4294)

I extract the DDL for a view to include the grants.  When I try to run the script I get ORA-00933: SQL command not properly ended.

Troubleshooting show that I either have to take all the grant clauses out of the script or put an ";" at the end of the view creation portion manually.

0 0 / Create an account to join the discussion.
ashmelev
Follow / 18 Oct 2017 at 6:18pm / SQL Navigator

Unable create a view using Oracle 12c features

Expand content
Here'a sample query I've created that uses WITH clause with a function and some sub-query (my real query is much more complex, but has similar structure). --CREATE VIEW TMP_ABC AS WITH FUNCTION...

Here'a sample query I've created that uses WITH clause with a function and some sub-query (my real query is much more complex, but has similar structure).

--CREATE VIEW TMP_ABC AS

WITH
FUNCTION abc (p_val NUMBER) RETURN VARCHAR2 IS
vret VARCHAR2 (100);
BEGIN
SELECT LPAD (' ', p_val, 'z') INTO vret FROM DUAL;

RETURN vret;
END;
gen AS (SELECT ROWNUM rn FROM DUAL CONNECT BY LEVEL < 10)
SELECT gen.rn, abc (rn) abc
FROM gen;

With the first line commented out, the query runs fine from SQL Navigator 7.4, formatter is able to format it, but if I uncomment the first line and attempt to create a view based on this query I get an error message.

line 1: ORA-06553: PLS-103: Encountered the symbol "end-of-file" when expecting one of the following:

:= ; not null default character

or

line 12: ORA-00900: invalid SQL statement

Using SQL Nav 7.4 64-bit, Oracle 12c client 64 bit and 12c database.

Tried Oracle SQL Developer and the view creation script works just fine.

20 0 / Create an account to join the discussion.
saman
Follow / 10 Nov 2012 at 1:31am / SQL Navigator
Latest post by on 3 Oct 2017 at 6:14am

i need a key authorization for sqlnavigator 6.7

Expand content
I downloaded a trial version of sqlnavigator 6.7 , they sent me a mail with license key but it was expired. Please can anybody help me??? Thanks Saman

I downloaded a trial version of sqlnavigator 6.7 , they sent me a mail with license key but it was expired. Please can anybody help me???
Thanks
Saman

8085 7 / Create an account to join the discussion.
Reise
Follow / 28 Sep 2017 at 2:57pm / SQL Navigator
Latest post by on 2 Oct 2017 at 10:52am

Formmater options to not stack parameters in internal functions?

Expand content
Is there an option on formmatter options to prevent the parameters of internal functions to go the the next line and get stacked? I'm using SQL Navigator 7.3.0.4294 This is what I get: This...

Is there an option on formmatter options to prevent the parameters of internal functions to go the the next line and get stacked?

I'm using SQL Navigator 7.3.0.4294

This is what I get:

This is what I wanted:

SELECT NVL (SUBSTR (RTRIM (a3.VALUE), 1, 25), 'n/a')

90 2 / Create an account to join the discussion.
martin_goblet
Follow / 22 Sep 2017 at 9:32am / SQL Navigator
Latest post by on 30 Sep 2017 at 10:25am

Crash when inserting a new record in a table

Expand content
Hi Version :V 7.3.0.4294 32bit, win 7 pro 64 bit. When I select * from a table and want to add a record with the (+) signe, SQL Nav crashes Regards Martin

Hi

Version  :V 7.3.0.4294 32bit, win 7 pro 64 bit.

When I select * from a table and want to add a record with the (+) signe, SQL Nav crashes

Regards

Martin

124 3 / Create an account to join the discussion.
andreml
Follow / 31 Aug 2017 at 6:14pm / SQL Navigator
Latest post by on 19 Sep 2017 at 7:04am

Problem with latest SQL Navi GA (64bit) regarding VARCHAR2(32767)...

Expand content
Hi, today I noticed the there is an issue in data grid: a) when a col ist defines as VARCHAR2(32767) means gt 4000 b) when you query External Table with CLOB colums, the CLOB output in data grid...

Hi,

today I noticed the there is an issue in data grid:

a) when a col ist defines as VARCHAR2(32767)  means gt 4000

b) when you query External Table with CLOB colums, the CLOB output in data grid returns soem quirk 

Can some verify this please?

Thank you and best Regards

Andre

330 4 / Create an account to join the discussion.
Nate.Gaffaney
Follow / 14 Sep 2017 at 12:19pm / SQL Navigator

Re: 答复: [SQL Navigator - Discussion Forum] Problem with latest SQL...

Expand content
Hi Michael, I assume what he is referring to as the strange e-mails is the “badge” system where by asking a question he earned an achievement. New achievements earned do result in an automated e...
Hi Michael,
 
I assume what he is referring to as the strange e-mails is the “badge” system where by asking a question he earned an achievement.  New achievements earned do result in an automated e-mail being sent with congratulations for the new achievement earned.  Sometimes they have whimsical names or text associated with them.  He can see which achievements he’s earned by visiting his profile: http://www.toadworld.com/members/andreml 
 
This isn’t new and has been around for a while.
 
Regards,
 

-          Nate

 
From: "Michael Luo (mluo)" <Michael.Luo@quest.com>
Date: Thursday, September 14, 2017 at 1:38 AM
To: "sqlnav@toadworld.com" <sqlnav@toadworld.com>, "QDL.ToadWorldAdmins" <QDL.ToadWorldAdmins@quest.com>
Cc: "Vincent Liu (vliu)" <Vincent.Liu@quest.com>
Subject:
答复: [SQL Navigator - Discussion Forum] Problem with latest SQL Navi GA (64bit) regarding VARCHAR2(32767) and External Table with CLOB colums
 
Hi admin,
 
Customer complain that community send him some strange mails in the background.
 
Is there any changes for community of ToadWorld?
 
Regards,
Michael
 
发件人: andreml [mailto:bounce-andreml@toadworld.com]
发送时间: Saturday, September 09, 2017 9:52 PM
收件人: sqlnav@toadworld.com
主题: RE: [SQL Navigator - Discussion Forum] Problem with latest SQL Navi GA (64bit) regarding VARCHAR2(32767) and External Table with CLOB colums
 
Reply by andreml

Hi,
Well, even when I got some strange mails (telling me how great my question is and what a cool guy I am.) - no useful answer at all.
So, friends - what’s the matter here.

I do hope, this is forum with more than a "artificial intelligence"-mailing system in the background.
Regards
Andre

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from SQL Navigator Forum notifications altogether.
SQL Navigator - Discussion Forum

Flag this post as spam/abuse.

92 0 / Create an account to join the discussion.
martin_goblet
Follow / 3 Aug 2017 at 3:15pm / SQL Navigator
Latest post by on 6 Sep 2017 at 6:10am

Control + clic on a package procedure doesn't go to the right...

Expand content
Hi I'm in V7.3 32bit, Win 7 64 bit pro. When I do a control click on a package procedure like this one : it just opens the package body and does not go to the procedure like before. Regards...

Hi

I'm in V7.3 32bit, Win 7 64 bit pro.  When I do a control click on a package procedure like this one :

it just opens the package body and does not go to the procedure like before.

Regards

Martin

166 1 / Create an account to join the discussion.
martin_goblet
Follow / 7 Jun 2017 at 1:09pm / SQL Navigator
Latest post by on 21 Aug 2017 at 2:43pm

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

391 3 / Create an account to join the discussion.
martin_goblet
Follow / 7 Jun 2017 at 7:22am / SQL Navigator
Latest post by on 18 Aug 2017 at 11:01am

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

390 2 / Create an account to join the discussion.
CsongorRacz
Follow / 15 Aug 2017 at 2:15pm / SQL Navigator
Latest post by on 16 Aug 2017 at 3:08pm

Outlook 2010 VB script

Expand content
I know it's possible to script the export in Outlook 2007, but what about Outlook 2010? Can someone point me in the right direction or does anyone have a vb script to do this in Outlook 2010?

I know it's possible to script the export in Outlook 2007, but what about Outlook 2010?  Can someone point me in the right direction or does anyone have a vb script to do this in Outlook 2010?

194 3 / Create an account to join the discussion.
martin_goblet
Follow / 3 Aug 2017 at 11:35am / SQL Navigator

Insert of a new record crashes

Expand content
Hi With version 7.3 32bit, win 7 64 bit pro, it often happens that when you click on the (+) to add a record the application crashes. Regards Martin

Hi

With version 7.3 32bit, win 7 64 bit pro, it often happens that when you click on the (+) to add a record the application crashes.

Regards

Martin

144 0 / Create an account to join the discussion.
robbi73
Follow / 12 Jul 2017 at 9:19pm / SQL Navigator
Latest post by on 1 Aug 2017 at 1:45pm

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

418 4 / Create an account to join the discussion.
martin_goblet
Follow / 1 Aug 2017 at 11:01am / SQL Navigator

Invalid data entered

Expand content
Hi When a user deletes a date field he just opened, he gets a 'invalid data entered' error. To be able to delete the date fields, he must not "open" the field, just press delete....

Hi

When a user deletes a date field he just opened, he gets a 'invalid data entered' error.

To be able to delete the date fields, he must not "open" the field, just press delete.  it would be nice to be able to delete in both ways.

Regards

Martin

135 0 / Create an account to join the discussion.
martin_goblet
Follow / 27 Jul 2017 at 10:38am / SQL Navigator
Latest post by on 31 Jul 2017 at 7:15am

Error when adding a new field in the View editor

Expand content
Hi I'm in V7.3 32 bit, Win 7 64 bit. When I try to add a field in a view with the view editor, I get, on the first commit, an error (ORA-00907: missing right parenthesis, for example), and when I...

Hi

I'm in V7.3 32 bit, Win 7 64 bit.  When I try to add a field in a view with the view editor, I get, on the first commit, an error (ORA-00907: missing right parenthesis, for example), and when I commit a second time it works.

Regards

Martin

266 2 / Create an account to join the discussion.
srajaram
Follow / 9 May 2017 at 9:51pm / SQL Navigator
Latest post by on 29 Jun 2017 at 1:37pm

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.

1067 10 / Create an account to join the discussion.
martin_goblet
Follow / 8 Sep 2016 at 9:43am / SQL Navigator
Latest post by on 26 Jun 2017 at 2:36pm

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

1395 7 / 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.



314 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

4225 4 / 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.

402 1 / Create an account to join the discussion.