Chat now with support
Chat with Support

SQL Navigator for Oracle 7.6 - Release Notes

Release Notes

SQL Navigator® 7.6

Release Notes

December 2019

These release notes provide information about the SQL Navigator® release.

About SQL Navigator 7.6

Thank you for installing SQL Navigator, 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 the 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.

SQL Navigator 7.6 is a minor release, with enhanced features and functionality.

Resolved Issues

Table 1: General resolved issues

Resolved Issue Issue ID
Resolved an error that Team Coding is not enabled for Oracle 18c and 19c databases SQLNAV-2280
Resolved an application error when debugging a package. SQLNAV-2276
Resolved "page not found" error when opening SQL Navigator Community SQLNAV-2274
Resolved Extract DLL error when a column name is longer than 30 characters SQLNAV-2269
Resolved "page not found" error when opening Search Knowledge Xpert SQLNAV-2259
Resolved an application error on connecting to 18c database with a non-dba user SQLNAV-2201
Resolved an error that package entries are missing in DB Explorer and DB Navigator for wrapped package SQLNAV-2249
Resolved an error that Auto Code Completion doesn't work for wrapped packages SQLNAV-2222
Resolved "value malformed" error when debugging a procedure SQLNAV-1239

Known Issues

Table 2: Known Issues

Feature Known Issue Issue ID
F1 Help

Pre-open F1 help is unresponsive when there is a modal dialog opened in   SQL Navigator.

Workaround: Close the modal dialog and then switch to the help window

SQLNAV-260
Help

Opening links in the help content causes SQL Navigator to be unresponsive when Internet Explorer 9 is installed in the system.

Workaround: Upgrade Internet Explorer to a newer version

SQLNAV-1675
Export Data

Export Data containing special characters from data grid to xlsx format   may corrupt the Excel file. This usually happens when binary content is   exported from a BLOB field.

Workaround: Exclude the rows or columns which contain binary data or   special characters when using the Export Data dialog

SQLNAV-1609

Table 3: Third Party Known Issues

Feature Known Issue Issue ID

Help

(Affects the 64-bit version of SQL Navigator only)

If Internet Explorer 9 is installed, clicking a link in the Help file may crash SQL Navigator 64-bit, even if Internet Explorer 9 is not the default browser.

Workaround: Users who have Internet Explorer 9 installed can open Help from outside of SQL Navigator.

N/A

E-Control (Editor component) Odd word-wrapping behavior in some languages. Word wrapping may appear between symbols, with no space required to wrap, and some characters cannot be word-wrapped at all (for example, multi-byte characters in ANSI text). N/A
ODAC ODAC does not support Unicode in XMLTYPE (editing of XMLTYPE data is not supported). Querying of XMLTYPE with binary storage will lead to an error.  

System Requirements

Before installing SQL Navigator 7.6, ensure that your system meets the following minimum hardware and software requirements.

Memory

1 GB RAM required for 32-bit

2 GB RAM required for 64-bit

The memory required may vary based on the following:

  • Applications that are running on your system
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

Hard Disk Space

120 MB required for 32-bit

150 MB required for 64-bit

More disk space is required for SQL Navigator Xpert, less for SQL Navigator Standard and SQL Navigator Professional.

Operating System

Microsoft Windows Server 2012 (64-bit)

Microsoft Windows Server 2008 R2 (64-bit)

Microsoft Windows Server 2008 (32-bit and 64-bit)

Microsoft Windows Server 2003 (32-bit and 64-bit)

Microsoft Windows 10 (32-bit and 64-bit)

Microsoft Windows 8 (32-bit and 64-bit)

Microsoft Windows 7 (32-bit and 64-bit)

Microsoft Windows Vista (32-bit and 64-bit)

Microsoft Windows XP (32-bit and 64-bit)

It is recommended that you have the latest Windows Service Pack and Updates. Windows Server 2012 is not fully tested with this release.

Oracle Client

Oracle Client 19c

Oracle Client 18c

Oracle Client or Instant Client 12c

Oracle Client or Instant Client 11.2

Oracle Client or Instant Client 10.2

Oracle Client 9.2

You must use the 32-bit version of SQL Navigator with the 32-bit Oracle client, and the 64-bit version of SQL Navigator with the 64-bit Oracle client.

Oracle Server

The following Oracle database servers are supported.

Oracle 19c

Oracle 18c

Oracle 12c

Oracle 11g

Oracle 10g

Oracle 9i

Oracle 8.1.7

It is recommended that your client version be of the same release (or later) as your database server. This is an Oracle recommendation to prevent performance issues.

Citrix/Terminal Server Support

Citrix products supported include:

  • Platform Level - MetaFrame XPa 1.0 Server for Windows
  • Feature Release - MetaFrame XP 1.0, Feature Release 1,2 and 3.

For installation notes on installing SQL Navigator in a Citrix environment, refer to Getting Started | Installation.

Supported Version Control Systems

You can use a version control system (VCS) in conjunction with Team Coding to control files and database objects. SQL Navigator provides direct support to specific third-party version control systems and it also provides SCC support to connect to additional version control systems. You must have Team Coding installed to work with a VCS through SQL Navigator.

Important: Quest Software is unable to provide support for source control issues caused by the version control system, including the version control system's support for the Microsoft SCC API. If you have problems connecting to SQL Navigator through SCC, contact the version control system's support.

Direct Supported

Version Control System Version
Concurrent Versions System (CVS)*

CVS 1.11.9 and later

CVSNT 2.08 and later

Git   *

A git client for Windows must be installed.

IBM Rational ClearCase      *

Version 7.1 for Windows.

ClearTool command line is required.

Note: You must set up a working client view, mapped to the Project VOB on the client computer, before using it in SQL Navigator.

Perforce           *

2010.2 (command-line client)

Note: The Perforce client must match your operating system. For example, if you are running Windows 7 64-bit, then you must use the 64-bit Perforce client.

Serena PVCS         *

5.2 and later

Note: PVCS 6.6.1 and 6.8.0 are specifically not supported with Team Coding.

Serena PVCS Version Manager:

  • PVCS is supported with Team Coding for both 32-bit and 64-bit SQL Navigator.
  • It has been tested with Serena PVCS Version Manager 8.5/ 8.4, and replaces existing Merant PVCS interfaces.
  • PVCS Version manager Command Line Interface (CLI) is supported.
  • PVCS Command Line option must be included when installing PVCS

Apache Subversion (SVN)*

1.6.5 and later

Microsoft Team Foundation Server

2005 through 2013

Microsoft Visual SourceSafe

5.0, 6.0, and 2005 (8.0)

*These version control systems connect using a command-line client.

 

SCC Support

In addition to providing direct support to the version control systems, SQL Navigator supports additional version control systems through the Microsoft SCC API. You should be able to connect to any version control system that uses SCC.

To connect to a version control system using SCC, you must install the system's SCC-compliant client. See the system's documentation for instructions on how to install their SCC client.

Note: It is strongly recommended you use the native APIs for SourceSafe and PVCS when using Team Coding (instead of the SCC integration).

Most version control systems that integrate with SQL Navigator through the SCC API ignore the "Force revision" flag and the "Create a new revision for existing objects" option when exporting.

 

Supported Oracle Features

SQL Navigator supports the following Oracle features.

A support of YES indicates the feature is supported fully or partially.

Oracle feature Support
Tables Standard relational tables YES  
Partitioned (range, hash and composite) Tables YES  
Partitioned (list) Tables YES Oracle 9.0.1 and above
Object tables YES  
Queue tables + (including schedules) NO  
Index-organized tables YES  
Temporary tables YES  
External tables YES Oracle 9.0.1 and above
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 Oracle 9.0.1 and above
Views Hierarchies NO Oracle 9.0.1 and above
Views with Constraints NO Oracle 9.0.1 and above
Constraints (definition, clauses and storage) Primary keys YES  
Unique keys YES  
Foreign keys (including external FKs, views FKs) YES Oracle 9.0.1 and above for views FKs
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 Oracle 9.0.1 and above
Descending YES Oracle 8.1.x and above
Reverse key YES  
Partitioned YES  
Global YES  
Local YES  
Non-prefixed YES  
Pre-fixed YES  
Function-based YES Oracle 8.1.x and above
Materialized views   YES  
Index-Organized Materialized Views YES Oracle 9.0.1 and above
Indexes on Materialized Views YES Oracle 9.0.1 and above
XML, LOB, nested table, varray type columns YES Oracle 9.0.1 and above
Materialized view Logs   NO Oracle 8.1.x and above
Snapshots   NO Oracle 8.0.x only
Simple and complex NO  
Registered NO  
Read-only and updateable NO  
Complete, ROWID and primary key fast refreshes NO  
Snapshot logs   NO Oracle 8.0.x only
Record with Object ID or Sequence NO Oracle 9.0.1 and above
Refresh groups   NO Oracle 8.1.x and above
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 Oracle 9.0.1 and above
TIMESTAMP WITH TIME ZONE YES Oracle 9.0.1 and above
TIMESTAMP WITH LOCAL TIME ZONE YES Oracle 9.0.1 and above
INTERVAL YEAR TO MONTH YES Oracle 9.0.1 and above
INTERVAL DAY TO SECOND YES Oracle 9.0.1 and above
Binary data types RAW YES  
LONG RAW YES  
BLOB YES  
BFILE YES  
Binary_Float YES Oracle 10g and above
Binary_Double YES Oracle 10g and above
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 Oracle 9.0.1 and above
XML Types YES Oracle 9.0.1 and above
Spatial Types NO  
Media Types NO Oracle 8.1.x and above
Context Text Types NO  
Operators   NO  
User defined NO Oracle 8.1.x and above
Ancillary NO Oracle 8.1.x and above
Triggers Standard YES  
Instead-of YES  
Database-event YES  
Nested-table view triggers YES Oracle 8.1.x and above
Clusters   YES  
Non-hash YES  
Hash YES  
Row level dependency tracking NO Oracle 9.0.1 and above
Collections   YES  
Nested tables YES  
VARRAYs YES  
Java support JDBC code NO  
  SQLJ code NO  
  JAVA SOURCE YES  
  JAVA CLASS YES  
  JAVA RESOURCE YES  
Database links   YES  
PFILE, SPFILE   NO Oracle 9.0.1 and above
Libraries   YES  
Synonym   YES  
Sequence   YES  
Dimensions   YES Oracle 8.1.x and above
Directories   YES  
Indextypes   YES Oracle 8.1.x and above
Jobs   YES  
Outlines   NO Oracle 8.1.x and above
Policies   NO Oracle 8.1.x and above
Histograms   NO  
Sum Deltas   NO Oracle 8.1.x and above
Object support Types YES  
Attributes YES  
Methods YES  
REF support (columns and attributes) YES  
Inheritance NO  
Substitutability NO  
Polymorphism NO  
User defined statistics   NO Oracle 8.1.x and above
Context Namespaces   NO  
Audit options   NO  
Profiles   YES  
Roles   YES  
Privileges   YES  
Resources Resource plans NO  
Consumer groups NO  
Plan Directives NO  
Allocation method NO  
Alter Resource Cost dynamically NO Oracle 9.0.1 and above
Rulesets   NO Oracle 8.1.x and above
External objects   NO Oracle 8.1.x and above
Tablespaces Standard YES  
Temporary YES  
Read-only YES  
Locally managed YES Oracle 8.1.x and above
Transportable YES  
Undo Tablespace NO Oracle 9.0.1 and above
Partition manipulation   YES  
PL/SQL server pages   NO Oracle 8.1.x and above
Fine grained access control   NO  
Application contexts   NO  
Labels (Trusted Oracle)   NO  
National Language Support   NO  
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating