PL/SQL analysis is available starting in Developer Edition.
Discover and update the PL/SQL-specific properties in Administration > General Settings > Languages > PL/SQL.
|When a schema object (table, view, index, synonym) is referenced in SQL code without a schema prefix, the analyzer will assume that it belongs to this schema.|
Some rules raise issues only when a data dictionary is provided during analysis. To provide a data dictionary, you must define the following properties in the
sonar-project.properties file or on the scanner command line using the
|URL of the JDBC connection. Required for data dictionary lookup. For example: |
|JDBC user to authenticate the connection.|
|JDBC password provided to authenticate the connection.|
|Path or URL of the Oracle JDBC driver JAR.|
|Java class name of the Oracle Driver. For example: |
Providing this configuration allows SonarPLSQL to query data dictionary views such as
SYS.ALL_TAB_COLUMNS in order to better analyze your SQL.
© 2008-2023, SonarSource S.A, Switzerland. Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution-NonCommercial 3.0 United States License. SONARQUBE is a trademark of SonarSource SA. All other trademarks and copyrights are the property of their respective owners.