Skip to content

Latest commit

 

History

History
59 lines (33 loc) · 3.56 KB

FAQ.md

File metadata and controls

59 lines (33 loc) · 3.56 KB
Raw

Frequently Asked Questions

I cannot install any extension on macOS

Maybe you’ve run into a SQL Developer bug on macOS. See this blog post for problem details and solution.

I cannot install any extension on Windows

Have you installed SQL Developer in C:\Program Files or C:\Program Files(x86)? In this case the files are read-only for a standard Windows user.

To solve the problem start SQL Developer as Administrator or install SQL Developer in an user folder. While the former requires local administrator rights, the latter is always feasible.

I cannot install any extension on Linux

The installation directory of SQL Developer is by default write-protected. As a result the installation process of any extension will fail.

To clean up the failed installation, close SQL Developer and then remove the system cache folder with the following command in a terminal window (the * is a placeholder for the SQL Developer version):

sudo rm -r $HOME/.sqldeveloper/system*/system_cache

To install an extension:

  1. close SQL Developer
  2. open a terminal and run sudo sqldeveloper
  3. install the extension(s) in SQL Developer
  4. close SQL Developer
  5. restart SQL Developer as normal user

I’ve got errors in the extensions log after installation. What’s wrong?

You are probably using an outdated version of SQL Developer. In this case you see after a restart an error message in the Extensions-Log similar to the following:

Extensions Log

SQL Developer 1.x, 2.x and 3.x are based on the Extension Software Development Kit (ESDK) version 1. SQL Developer 4.x requires the use of ESDK version 2. Unfortunately these versions are not compatible. So we decided to support the newest SQL Developer version only.

Please update to SQL Developer 4.x or later since this is a prerequisite for this extension.

What are the limitations?

See parser limitations and validator limitations.

What has changed in the latest version?

See the release information for each version.

What is the difference between "db* CODECOP" and "db* CODECOP for SQL Developer"?

db* CODECOP is a standalone command line utility. It processes SQL*Plus scripts within a directory tree and produces an HTML report and an Excel workbook. It reports metrics on file and PL/SQL unit level as well as violations of the Trivadis PL/SQL & SQL Coding Guidelines Version 4.2.

db* CODECOP for SQL Developer is a cost-free extension to Oracle’s SQL Developer. It processes the content of an editor window and produces a HTML report which is similar to the one of db* CODECOP but reduced and adapted to the scope of a single editor window. Additionally the violations of the Trivadis PL/SQL & SQL Coding Guidelines Version 4.2 are presented in a dedicated tab pane linked to the editor window to support quick navigation to the corresponding code.

What are the licensing terms?

db* CODECOP for SQL Developer is licensed under the Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. You may obtain a copy of the License at https://creativecommons.org/licenses/by-nc-nd/3.0/.

CC-BY_NC-ND