ClearSQL Help Center

How can we help?

Enter your questions, some keywords, or phrases to search for on the website.
Frequently Asked Questions
Below you will find answers to the most popular questions about ClearSQL.
Do I need Oracle Client to connect ClearSQL to a database?
Yes. Install a relevant version of Oracle Client before connecting to an Oracle database.
How to apply a license key?
If you are a subscriber or have a full license of the tool, there are several ways to apply the license key:

Apply the key automatically
Download the license key from the email we sent you upon the license registration and save it to the application home folder. The license key will be applied automatically at the first application launch.

Log into your Conquest account
  1. In the welcome window, click Locate License or Have an existing subscription, depending on the license you hold.
  2. Enter your customer ID or registration email and password to log into your account. The license key will be applied automatically.

Locate the key on the disk
On the login page, click Locate Key on Disk and then select the license key from the file system.

Paste the key from the Clipboard
Go to your Conquest account, copy the relevant key, and then click Paste from Clipboard on the login page of the application.
What types of files does ClearSQL support?
ClearSQL works with PL/SQL scripts, Oracle Forms & Libs versions from 6 to 11, and Oracle database objects versions from 9i to 19c.
How to move ClearSQL to another PC with all its configurations and files?
To re-install your ClearSQL to another PC

  1. Download and install the latest version of ClearSQL on the new PC.
  2. Copy the license key to the application home folder.
  3. Copy the %AppData%\ClearSQL folder.
  4. Save Preferences and Code Analyzer Options to files and load them to the new ClearSQL.
  5. Back up your ClearSQL projects and then restore them in the new ClearSQL.
For details, refer to the Re-installing ClearSQL to a new PC article.
Can I install ClearSQL on Mac?
We don't provide Mac-native versions of our tools, but you've got plenty of options, which are successfully applied by many of our mac-based users.

  1. All the tools are tested in a virtual environment. You can install it with an Oracle Client to VMWare, VirtualBox, Parallels. Even Documenter, which is resource-critical runs with a minor overhead (±1%).
  2. Some users report successful launches with Wine, though we haven't tested it on our grounds.
  3. Bootcamp could also be the choice, should you prefer non-virtualized environments.
Can I run ClearSQL jobs via Jenkins?
Yes, you can, but mind the following:

— Jenkins Windows service must be started under a user account, not under a system account.
— Check the available memory heap for non-interactive applications:
  1. Open the registry value HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\SubSystems\Windows.
  2. Change last three digits of the SharedSection value to 1536.
By default, SharedSection = 1024,12288,512. The last three digits differ depending on Windows version. ClearSQL requires at least 1536.

For more information, refer to Microsoft support.

After running a job, you can check the log file %APPDATA%\ClearSQL\CS.log for errors.
Popular articles
Read the articles our customers most often refer to. You can also use the side bar for the complete documentation guide.
Your first analysis
Get started with ClearSQL and run your first code analysis.

Learn more ⟩
Connect to Oracle Database
Download Oracle Client and Microsoft Redistributable Package.

Learn more ⟩
Custom code review rules
Find out how to set up your own rules for code analysis.

Learn more ⟩
Contact Support
Haven't found what you were looking for? Choose the best way to reach our support team.
Online Support Desk
Send your requests right from ClearSQL. Works best for technical issues and bug reports.
Contact our support team directly via this email. We are always happy to help!
Online Chat
Start an online conversation to get instant replies from our support angent.