SQL Navigator® for Oracle

Version 6.0.0 Release Notes

Release Notes

17 September 2008

Contents

Welcome to SQL Navigator for Oracle 6.0.0

New in this Release

Getting Started

Resolved Issues and Enhancements

Third Party Team Coding Support

Support of the Euro Character

Support of Oracle features

Known Issues

Third Party Provider Known Issues

System Requirements

Global Operations

For More Information

 

Welcome to SQL Navigator for Oracle 6.0.0

Thank you for installing SQL Navigator® 6.0.0, the Professional Oracle Development Environment of choice for thousands of developers and corporations worldwide.

SQL Navigator provides an integrated environment for developing and testing stored programs, schemas, SQL scripts, and more - all from an easy-to-use graphical user interface. The SQL Navigator® family of products is a complete development environment for Oracle server-side development and management. It has been conceived, designed and developed by Oracle developers and DBAs with hands-on experience in the most common problems facing Oracle developers.

 

View latest Release Notes containing late-breaking information and known issues about SQL Navigator®.

 

We trust you will find that SQL Navigator® significantly improves your productivity, so that your projects are completed faster with a higher level of quality than ever before.

 

Back to Top

Getting Started

Contents of the Release Package

The SQL Navigator® for Oracle release package contains the following products:

  1. SQL Navigator® for Oracle 6.0.0
  2. Knowledge Xpert for PL/SQL 10.1.0
  3. Quest SQL Optimizer for Oracle 7.4.0
  4. Quest Toad Data Modeler 3.2.5
  5. SQL Monitor 2.4.3
  6. Product Documentation, including:


A "ready to print" copy of the Users Guide, Users Guide Supplement and Getting Started manuals are provided in Adobe Acrobat format (also available from Start Menu). If you do not have a copy of Adobe Acrobat installed on your system, please visit http://www.adobe.com. Printed manuals are available for purchase from our e-Store at http://www.quest.com (navigate to the SQL Navigator® page).
 

On the installation CD we have also provided several "Tips & Tricks" articles to help you get the most from SQL Navigator®. To view additional Tips as they are added, please regularly visit our SQL Navigator Inside Community.


Installation Instructions

Refer to SQLNavigator_InstallationNotes.htm for installation instructions. 

 

Back to Top

New in This Release

 

New Features in SQL Navigator® 6.0.0

 

 

Updates to SQL Navigator® 5.5 

 

New Features in SQL Navigator® 5.5 

 

Back to Top

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release of SQL Navigator® for Oracle: 

 

Area

Resolved Issue

 Defect ID
General
Knowledge Xpert  is now part of the Standard Edition    
Incorrect Extract DDL, when object type is alteredCR95865/ Case 291012
Extract DDL does not include NOLOGGING keyword.CR53676/ Case 189992
Extract DDL of Java classes - '/' is included as the separator characterCR77381/ Case 247141
Extract DDL creates system generated constraints when it should not. CR94377/ Case 286926, 287262
Extract DDL for table shows SYNONYM incorrectly, if it's created by another user CR98168/ Case 298000
Separator character ';' problem in Extract DDL for packages.CR119442/ Case 330949
Extracting DDL doesn't include system named check constraints CR225675/Case 550196
Extract DDL on Spatial Indexes generates incorrect syntax

- CR120123/ Case 331487

Cannot open Clipboard error message and "Invalid Pointer Operation"
CR209268/ Case 498537, 623219
Release 5.5: Server output is not displaying dbms_output messages.
 
Add preference not to display the SQL Navigator splash screen
- CR 232442/Case 621602, 509979
Check for updates has been added. 
Query Builder Conversion Utility is not retaining the column schemas.- CR228233/Case 572212
Allow to save Workspace on Terminal Server/Citrix- CR110444/ Case 319204, 330144

- CR0091042/ Case 277829

- CR0068456/ Case 225016

View Difference doesn't work when the same objects from different instances are compared.CR212451/ Case 502612
View Difference without OWNERCR214014/ Case 519825
View Differences fails for objects outside the session schema CR213678/ Case 516102
View Differences - can't compare objects from another schema CR209509/ Case 506261, 51500, 530807
Add support for Visual Studio 2005 Team Foundation Server - CR214152/ Case 520605

- CR 221239/ Case 541215

Find and Replace: Find Next (F3) stops workingCR211591/ Case 514151
Error: "Quest Software IE plug in protocol: Unable to locate QCOM serviceCR221377/ Case 539939
Auto hide functionality of dock-able windows not working correctly CR212223/ Case 515402
Floating dock-able window shifts when display. 
ConnectivitySupport connection to 11g DB. 
Add LDAP support for Active Directory 
Code Editor Split windows feature has been added. CR194150/ Case 464090
SQL NAV Stored Program Editor uppercases the module name CR 100284/ Case 474256
Problem when displaying numbers and datesCR199961/ Case 478297
Allow a "Save As" for extracted DDL file to use as default only object name without schema prefix.CR214300/ Case 513067
Running multiple SQL as a script, doesn't place results in separate Tabs for each SQL, despite having preference set on.CR209849/Case 506112
Release 5.5: Server output is not displaying dbms_output messagesCR207094/ Case 493284
Oracle Query: FieldAsInteger: '3601815192' is not a valid integer value CR204053/ Case 491413
Out of Memory when parsing a large subquery factoring WITH...AS SELECT sql statementCR0171670/ Case 411645
Problems when doing a SELECT in SQL Navigator that includes a CLOB columnCR132684/ Case 349733
Parsing and formatting error with special packagesCR119892/ Case 332909
ORA-01455, when querying database from 9i client on XPCR102922/ Case 303524
ORA-03130, when viewing CLOBs in Oracle 9.2.0.4.0 patch (OCI issue)CR0065494/ Case 211195
LONG data type editor truncates Return char when data modified on grid CR0063452/ Case 206784
SQL Nav 4.1.2, Vertical Scrollbar Changes Focus on Data Grid CellCR0096080/ Case 129375, 405016, 537235, 537212
Sqlnav4 trims strings in dynamic sql if slash "\\" is followed by pipe "||"CR124762/ Case 337596
Not passing the parameters when trying to debugCR144732/ Case 359263
Font in the Data grid is same as UI, should be different.CR167791/ Case 415286
Extend functionality of code completion to include object names (i.e. TABLE emp, when half-typed, a list of tables beginning with "em" should be displayed).CR176582/ Case 427682
Indication of the parenthesis disappears as the page is scrolled up.CR178485/ Case 434217
Add support in Code Editor for the SQL*Plus command SPOOL ON/OFF CR219350/ Case 532578
Double click on gutter selects only 106 characters of a line in Stored Programmed editor CR54599/ Case 186121
Pick list in Code Completion displays objects indiscreetly, if char is typed in.CR69780/ Case 229062
Some procedure names in Code Explorer are shown in red, despite being VALIDCR71541/ Case 233410
SQL Navigator - Stored Program Editor Hangs After Compiling Package CR117478/ Case 327718
Rollback from Session menu or/and from Main sqlnav5 Toolbar requires RefreshingCR144494/ Case 366395
Statements with colons fail when executing CR161813/ Case 402935
Allow SQL Optimizer to be launched from within SQL Nav without typing in first the SQL statement CR180786/ Case 438928
Trigger (on Insert) doesn't insert data on NOT NULL column, if action is performed from grid - error message "Field filed name must have a value"CR171749/ Case 422396
Add "Outline" on side of editor displaying code structureCR194827/ Case 467278
Out of memory error when executing queryCR200651/ Case 471289, 609411
DBMS_OUTPUT>>>>: Output windows not working & can't run multiple sql statementsCR215100/ Case 522547
Decimal rounding issue>>>Result Displayed in DecimalCR216218/ Case 518752
Add preference to display on the grid NULL for Null Values- CR86644/ Case 268739

- CR105277/ Case 311260

Error "Invalid time display option" in SQL Editor, while debugging. CR217924/ Case 502963, 589386, 625684
Indenting indents one row too muchCR170445/ST1990/Case 419771
Code Completion drop down list enhancement request.CR59496/ ST1884/ Case 200249, 207705
Syntax Highlight of JOIN KeywordsCR169760/ST1989/ Case 418166
In Stored Program Editor, double click on invalid component doesn't navigate to Body.CR61146/ST1885/ Case 204210, 425064
SQL Navigator hangs after compiling packageCR216587/ CR 519190
Set height of Code Editor window bigger as default CR184279/ST2024/Case 441630
When focus is on date field in "View Single Record" date format changes - user cannot copy & paste the required format.CR149206/ST1937/Case 373773
Issues with the large size of sql history .hst file. In 6.0, no longer use the .hst formatCR149245/ ST1938/Case 366680
Allow to View longer text in Single View of Results pane of SQL Editor CR149622/ST1941/ Case 367664
SQL Navigator freezes during a query when table contains 292 columns CR194153/ST2087/Case 465202
ORA-01481 when using ROUND function within TO_DATE function of select statement, when Updateable is ON.CR193403/ST2082/Case 463201, 606278
Getting error message: Task "SQL Editor Execution" in DoTerminate(): Stream read errorCR158703/ST1955/Case 381638, 571716
SQL Navigator crashes when selecting multiple rows in grid and doing Ctrl+C repeatedly.CR188132/ST2069/Case 445998
The numeric data is not sorted correctly in data grid.CR212456/ Case 504998
Code Explorer reporting the incorrect statusCR175669/ST2000/Case 437324
Extend Code Completion and Dot Lookup functionalities to allow to the Code Explorer reporting the incorrect status on table names in progressive search.

CR182711/ Case 442040

InstallationUsing the Quest Installer which support silent, push and side by side installations. 

Back to Top

Third Party Team Coding Support

SQL Navigator's Team Coding module directly supports the following products:



Team Coding will also operate with certain products providing Microsoft's SCC API. Implementation of this interface varies between products however. The products tested with, and supported by, SQL Navigator® include:

 


Each third party product may require a custom installation to install the SCC interface. Please refer to the topics "Installing Team Coding options" and "Installing third-party version control products" in the Online Help, as well as documentation supplied by the vendor. There may also be a SCC interface installer available on the vendor's website. 


Please note that a Third Party Version Control product is not a requirement for Team Coding - all functionality except for revision history (Version Control Browser) is always available if Team Coding is enabled.


Using User Mapping with Triggers and Views 

If you are using User Mapping (please refer to Online Help for details), Team Coding must modify the DDL in order to create the object in the User's schema. This primarily involves replacing any references to the original schema. For example, consider the DDL for the following Views: 

            create or replace VIEW scott.vemp1 as select * from scott.emp;

            create or replace VIEW scott.vemp2 as select * from emp;
 

The DDL which will be executed during import, Get Latest Revision, etc. will be modified to: 

            create or replace VIEW otheruser.vemp1 as select * from otheruser.emp;

            create or replace VIEW otheruser.vemp2 as select * from emp; 

In both cases, the referenced table must exist in the other user's schema, or the view will be invalid. In the case of triggers, it will not be created by Oracle. If you require that the triggers and views refer to the tables in the original schema, we recommend creating synonyms for them in the other users schema. 

Note: Schema replacement affects all objects maintained by Team Coding, so it is possible that explicit schema references in any stored program may result in invalid objects when using User Mapping


Accessing Triggers from a different user
 
When using Team Coding to manipulate triggers as a user other than the owner of the objects, certain steps must be followed prior to performing check in/out operations. Failure to follow these steps will lead to errors such as "ORA-00942: table or view does not exist". 
  1. The steps to avoid this problem are as follows. They should be performed before creating any revisions in your Version Control provider's repository; however, they can be performed at any time:
  2. When connected as a user with Team Coding Administration privileges, ensure that the Team Coding connection setting "Use Trigger Description for DDL" is enabled.
  3. When connected as any user with access to triggers, use the Find Objects Tool or the Details Panel of the DB Navigator to select all triggers mapped to a Team Coding group
  4. From the Object menu/toolbar or pop-up menu, choose Extract DDL.
  5. In Extract DDL Preferences, ensure that "Prefix with Schema Name" is enabled, and that "Show Trigger Snapshot" is not enabled, then click OK
  6. Execute the generated script.
  7. From the Code Control Groups window, perform an Export of your triggers to your Version Control provider project. Ensure that the "Create a revision only if the object has changed" option is enabled.

Following these steps will ensure that the original schema name is stored in the DESCRIPTION column of the ALL_TRIGGERS view, and that Team Coding will use the original DDL text rather than generating the DDL from the other columns of this view. Subsequent use of Team Coding operations which replace the trigger will perform correctly. Functionality affected includes Get Latest Version,  Check In (with the preference "Update database after Check-In" enabled) Import and Export (with the preference "Update database after Check-In" enabled).

Note: if the trigger owner using the Trigger Editor subsequently modifies a trigger, the DDL generated does not include the schema, which will re-introduce this issue. It is recommended that for this release you do not mix trigger modification between trigger owner and other users if Team Coding controls the trigger.

Finally, the CREATE ANY TRIGGER privilege is required for User mapping or when modifying or importing a Trigger as a different user. The SELECT privilege may also need to be granted to users creating views in different schemas for the table referred to by the view.                                                                                                                                                                  

Back to Top

Support of the Euro Character


SQL Navigator® 6.0.0 provides full support of the Euro character (€). The default fonts permit the Euro character to be displayed or entered in all areas of the SQL Navigator® user interface. Support of the Euro can however be affected by user configuration, such as choosing a font set which does not include the symbol. It is also dependant on operating system, Oracle client and Oracle server configuration.  

These issues are well documented by both Oracle and Microsoft, and Quest Software can provide details upon request. Basic requirements are detailed below:
 

 To test Euro support in the SQL Editor (spool window and results grid), execute the following statement:

            select chr(128) from dual;


Back to Top

Support of Oracle Features


Oracle feature

Support

Tables

·         Standard relational tables

YES

·         Partitioned (range, hash and composite) Tables +

YES

·         Partitioned (list) Tables +++

YES

·         Object tables +

YES

·         Queue tables + (including schedules)

NO

·         Index-organized tables +

YES

·         Temporary tables +

YES

·         External tables +++

YES

Views

·         Standard views

YES

·         Inline views

YES

·         Object views +

YES

·         Join views (including updateable) +

YES

·         Check option on views +

YES

·         Read only option on views +

YES

·         Polymorphic Views +++

NO

·         Views Hierarchies +++

NO

·         Views with Constraints +++

NO

Constraints (definition, clauses and storage)

·         Primary keys

YES

·         Unique keys

YES

·         Foreign keys(including external FKs, views FKs+++)

YES

Procedures

YES

·      Java/C Methods Calls +

YES

·      Invokers Right +

YES

Functions

YES

·      Java/C Methods Calls +

YES

·      Invokers Right +

YES

Packages

YES

·         Header

YES

·         Body

YES

·      Invokers Right +

YES

Indexes

·         Standard

YES

·         Bitmap

YES

·         Bitmap Join Index +++

NO

·         Descending ++

YES

·         Reverse key +

YES

·         Partitioned +

YES

·         Global +

YES

·         Local +

YES

·         Non-prefixed +

YES

·         Pre-fixed +

YES

·         Function-based ++

YES

Materialized views ++

YES

·         Index-Organized Materialized Views +++

YES

·         Indexes on Materialized Views +++

YES

·         XML, LOB, nested table, varray type columns +++

YES

Materialized view Logs ++

NO

Snapshots (Oracle 7.3.4 up to Oracle 8.0.x Only)

NO

·         Simple and complex

NO

·         Registered

NO

·         Read-only and updateable

NO

·         Complete, ROWID and primary key fast refreshes

NO

Snapshot logs (Oracle 7.3.4 up to Oracle 8.0.x only)

NO

·         Record with Object ID or Sequence +++

NO

Refresh groups ++

NO

Datatypes

Built-in Datatypes

YES

Character

YES

CHAR

YES

NCHAR+

YES

VARCHAR2

YES

NVARCHAR2+

YES

LONG

YES

CLOB+

YES

NCLOB+

YES

Number

YES

Date types

DATE

YES

TIMESTAMP +++

YES

TIMESTAMP WITH TIME ZONE +++

YES

TIMESTAMP WITH LOCAL TIME ZONE+++

YES

INTERVAL YEAR TO MONTH +++

YES

INTERVAL DAY TO SECOND+++

YES

Binary data types

RAW

YES

LONG RAW

YES

BLOB

YES

BFILE +

YES

Binary_Float ++++

YES

Binary_Double ++++

YES

Ids

ROWID

YES

UROWID +

YES

 ANSI DB2, SQL/DS datatypes

YES

User defined data types+

Collection Types +

YES

Object Types +

YES

Oracle Supplied types+

"Any" Types +++

NO

XML Types +++

YES

Spatial Types +

NO

Media Types ++

NO

Context Text Types +

NO

Operators

NO

·         User defined ++

NO

·         Ancillary ++

NO

Triggers

·         Standard

YES

·         Instead-of +

YES

·         Database-event +

YES