# \#plsql

**URL:** https://community.sonarsource.com/tag/plsql/9.md

[Latest](https://community.sonarsource.com/latest.md) · [Categories](https://community.sonarsource.com/categories.md) · [Tags](https://community.sonarsource.com/tags.md)

---

## [False positive of rule plsql:S1523](https://community.sonarsource.com/t/false-positive-of-rule-plsql-s1523/183464)

<div class="topic-metadata">

**Author:** [@KjartanThK](https://community.sonarsource.com/u/KjartanThK)\
**Replies:** 6\
**Last updated:** [November 16, 2026, 2:20pm UTC](https://community.sonarsource.com/t/false-positive-of-rule-plsql-s1523/183464 "2026-11-16T14:20:29Z")

</div>

Hi, I ran into what I think is a false positive of rule plsql:S1523 (Dynamically executing code is security-sensitive). The code being flagged looks like this: EXECUTE IMMEDIATE ‘DROP TABLE MyTable’ with no variables. I…

---

## [plsql:S3651 False positive for left JOINs](https://community.sonarsource.com/t/plsql-s3651-false-positive-for-left-joins/108844)

<div class="topic-metadata">

**Author:** [@Peter0](https://community.sonarsource.com/u/Peter0)\
**Replies:** 7\
**Last updated:** [October 26, 2026, 4:29pm UTC](https://community.sonarsource.com/t/plsql-s3651-false-positive-for-left-joins/108844 "2026-10-26T16:29:53Z")

</div>

When a table is LEFT JOINed, the fact that a joined column is NOT NULL is not relevant. When the LEFT JOIN finds no rows, the result is still NULL. SELECT CASE WHEN other\_table.not\_null\_column IS NOT NULL THEN 1 END F…

---

## [Rules Improvements for PL/SQL](https://community.sonarsource.com/t/rules-improvements-for-pl-sql/188077)

<div class="topic-metadata">

**Author:** [@adam.wilson](https://community.sonarsource.com/u/adam.wilson)\
**Replies:** 0\
**Last updated:** [September 9, 2026, 9:33am UTC](https://community.sonarsource.com/t/rules-improvements-for-pl-sql/188077 "2026-09-09T09:33:35Z")

</div>

Hi PL/SQL Developers, We’ve improved our PL/SQL rules and parsing so that we continue to return relevant results to you during analysis. This includes: Fix false positive when “PRAGMA UDF” compiler directive misidenti…

---

## [Cursor signatures in package specs reported as issue (plsql:VariableInPackageSpecificationCheck)](https://community.sonarsource.com/t/cursor-signatures-in-package-specs-reported-as-issue-plsql-variableinpackagespecificationcheck/172506)

<div class="topic-metadata">

**Author:** [@LarsSt](https://community.sonarsource.com/u/LarsSt)\
**Replies:** 2\
**Last updated:** [January 22, 2026, 6:16pm UTC](https://community.sonarsource.com/t/cursor-signatures-in-package-specs-reported-as-issue-plsql-variableinpackagespecificationcheck/172506 "2026-01-22T18:16:50Z")

</div>

Language:PL/SQL Rule: Global public variables should not be defined (plsql:VariableInPackageSpecificationCheck) SonarQube: Enterprise Edition v2025.1.4 The rule flags cursor declarations in a package specification as …

---

## [PL/SQL Create table duplication errors](https://community.sonarsource.com/t/pl-sql-create-table-duplication-errors/153544)

<div class="topic-metadata">

**Author:** [@skinnygingerkid](https://community.sonarsource.com/u/skinnygingerkid)\
**Replies:** 1\
**Last updated:** [December 8, 2025, 3:47pm UTC](https://community.sonarsource.com/t/pl-sql-create-table-duplication-errors/153544 "2025-12-08T15:47:07Z")

</div>

What language is this for? PL/SQL Which rule? Duplication - specifically duplicate blocks across files Why do you believe it’s a false-positive/false-negative? The functionality is different across each file Are you usi…

---

## [Parse error on Oracle sql package with forall statement](https://community.sonarsource.com/t/parse-error-on-oracle-sql-package-with-forall-statement/146365)

<div class="topic-metadata">

**Author:** [@Rob.Wijs](https://community.sonarsource.com/u/Rob.Wijs)\
**Replies:** 4\
**Last updated:** [November 18, 2025, 9:19am UTC](https://community.sonarsource.com/t/parse-error-on-oracle-sql-package-with-forall-statement/146365 "2025-11-18T09:19:48Z")

</div>

Hi, I am using cli version sonar-scanner-7.1.0.4889-windows-x64 and SonarQube Server Cloud v2025.2 (105476) On parsing Oracle PL/SQL code there are some ‘Parse error’ messages on the commandline output: 17:27:24.477 …

---

## [PL/SQL parse errors](https://community.sonarsource.com/t/pl-sql-parse-errors/125261)

<div class="topic-metadata">

**Author:** [@Karl](https://community.sonarsource.com/u/Karl)\
**Replies:** 6\
**Last updated:** [September 12, 2025, 7:37am UTC](https://community.sonarsource.com/t/pl-sql-parse-errors/125261 "2025-09-12T07:37:29Z")

</div>

Hi, SQ version: 10.6 I’ve noticed several parse errors: create or replace package pkg as procedure foo; pragma deprecate (foo); -- parse error end pkg; create or replace type BaseType force is object ( …

---

## [Secrets not detected in PLSQL package](https://community.sonarsource.com/t/secrets-not-detected-in-plsql-package/144628)

<div class="topic-metadata">

**Author:** [@jnewman](https://community.sonarsource.com/u/jnewman)\
**Replies:** 1\
**Last updated:** [July 18, 2025, 2:04pm UTC](https://community.sonarsource.com/t/secrets-not-detected-in-plsql-package/144628 "2025-07-18T14:04:56Z")

</div>

Using Bitbucket Cloud pipeline PLSQL Exploring the SonarQube Cloud Free Trial Have this example statement we use to connect to an LDAP that I’m using to test the secret scanning: l\_bind := dbms\_ldap.simple\_bind\_s( …

---

## [Multiple plugins for the same language](https://community.sonarsource.com/t/multiple-plugins-for-the-same-language/141986)

<div class="topic-metadata">

**Author:** [@G5un](https://community.sonarsource.com/u/G5un)\
**Replies:** 6\
**Last updated:** [July 11, 2025, 1:54pm UTC](https://community.sonarsource.com/t/multiple-plugins-for-the-same-language/141986 "2025-07-11T13:54:13Z")

</div>

Can we deploy custom Plugin for PL/SQL (with \*.sql files) along with Out-of-the-box PL/SQL plugin in Enterprise Edition? We see server complaining on which plugin to use for .sql files in the log messages. Is the “Addin…

---

## [Should SQL Migration Files Managed by Flyway be Included in SonarCloud Analysis?](https://community.sonarsource.com/t/should-sql-migration-files-managed-by-flyway-be-included-in-sonarcloud-analysis/138305)

<div class="topic-metadata">

**Author:** [@Julian\_Campos](https://community.sonarsource.com/u/Julian_Campos)\
**Replies:** 1\
**Last updated:** [April 5, 2025, 9:20am UTC](https://community.sonarsource.com/t/should-sql-migration-files-managed-by-flyway-be-included-in-sonarcloud-analysis/138305 "2025-04-05T09:20:18Z")

</div>

I’m working on a Spring Boot microservice that uses Flyway for managing database migrations. Our SQL migration files contain all the necessary DDL and DML commands for setting up and updating the database schema. My que…

---

## [Support for PL/SQL Developer IDE](https://community.sonarsource.com/t/support-for-pl-sql-developer-ide/135786)

<div class="topic-metadata">

**Author:** [@Rafik\_Beshara](https://community.sonarsource.com/u/Rafik_Beshara)\
**Replies:** 1\
**Last updated:** [March 12, 2025, 9:12am UTC](https://community.sonarsource.com/t/support-for-pl-sql-developer-ide/135786 "2025-03-12T09:12:31Z")

</div>

Hi , Any news about is SonarLint PL/SQL analysis support to PL/SQL Developer IDE? If yes what is the steps ? Thanks, Rafik Beshara

---

## [PL/SQL analysis in IntelliJ](https://community.sonarsource.com/t/pl-sql-analysis-in-intellij/31799)

<div class="topic-metadata">

**Author:** [@Halloway](https://community.sonarsource.com/u/Halloway)\
**Replies:** 7\
**Last updated:** [January 3, 2023, 8:20am UTC](https://community.sonarsource.com/t/pl-sql-analysis-in-intellij/31799 "2023-01-03T08:20:56Z")

</div>

Hi, I am keen to understand whether there are any plans to add support for PL/SQL analysis within SonarLint for IntelliJ. My team are considering moving to IntelliJ as a single IDE for Java / JavaScript / PL/SQL develo…

---

## [PL/SQL scan does not detect error when code contains "is json" instruction](https://community.sonarsource.com/t/pl-sql-scan-does-not-detect-error-when-code-contains-is-json-instruction/135647)

<div class="topic-metadata">

**Author:** [@SebG](https://community.sonarsource.com/u/SebG)\
**Replies:** 4\
**Last updated:** [February 24, 2025, 2:08pm UTC](https://community.sonarsource.com/t/pl-sql-scan-does-not-detect-error-when-code-contains-is-json-instruction/135647 "2025-02-24T14:08:08Z")

</div>

Versions: Developer Edition v2025.1 (102418) \[ACTIVE\] Standard Experience SonarQube deployed: zip Problem was detected in VS code IDE with sonarlint and when project is scaned by SonarQube server. Hello, When the PL/…

---

## [Bundling two different language scanner and sensors in one plugin](https://community.sonarsource.com/t/bundling-two-different-language-scanner-and-sensors-in-one-plugin/132229)

<div class="topic-metadata">

**Author:** [@G5un](https://community.sonarsource.com/u/G5un)\
**Replies:** 2\
**Last updated:** [December 18, 2024, 4:20pm UTC](https://community.sonarsource.com/t/bundling-two-different-language-scanner-and-sensors-in-one-plugin/132229 "2024-12-18T16:20:51Z")

</div>

Can one Plugin setup two language profiles and rule definitions? We are trying to bundle custom SQL sensor and associated quality rules in existing Java Custom Rules plugin which extends out of the box Java Plugin. pub…

---

## [SonarLint as plugin in PL/SQL Developer](https://community.sonarsource.com/t/sonarlint-as-plugin-in-pl-sql-developer/69843)

<div class="topic-metadata">

**Author:** [@SebG](https://community.sonarsource.com/u/SebG)\
**Replies:** 2\
**Last updated:** [August 17, 2022, 8:11am UTC](https://community.sonarsource.com/t/sonarlint-as-plugin-in-pl-sql-developer/69843 "2022-08-17T08:11:51Z")

</div>

Hello, For a former topic I posted here, I read in 2019 on SonarLint 2018 Roadmap page this sentence : “We really want all developers, irrespectively of the language and IDE they code in, to benefit from the full featur…

---

## [False positives in plsql:DeleteOrUpdateWithoutWhereCheck](https://community.sonarsource.com/t/false-positives-in-plsql-deleteorupdatewithoutwherecheck/128264)

<div class="topic-metadata">

**Author:** [@fassen](https://community.sonarsource.com/u/fassen)\
**Replies:** 3\
**Last updated:** [October 25, 2024, 2:03pm UTC](https://community.sonarsource.com/t/false-positives-in-plsql-deleteorupdatewithoutwherecheck/128264 "2024-10-25T14:03:27Z")

</div>

What language is this for? plsql Which rule? plsql:DeleteOrUpdateWithoutWhereCheck Why do you believe it’s a false-positive/false-negative? Declarations for triggers trigger the rule Are you using SonarQube - which …

---

## [Developer edition not picking up SQL injections](https://community.sonarsource.com/t/developer-edition-not-picking-up-sql-injections/124916)

<div class="topic-metadata">

**Author:** [@Tamanna](https://community.sonarsource.com/u/Tamanna)\
**Replies:** 6\
**Last updated:** [September 18, 2024, 6:26am UTC](https://community.sonarsource.com/t/developer-edition-not-picking-up-sql-injections/124916 "2024-09-18T06:26:41Z")

</div>

I’m evaluating Sonarqube developer edition v10.6, using dotnet-sonarscanner. I’m scanning a .net core project on my local machine to which I’ve added a sql injection vulnerability. This is the code I’ve added: public a…

---

## [Custom rules for PL/SQL implemented in Java](https://community.sonarsource.com/t/custom-rules-for-pl-sql-implemented-in-java/124879)

<div class="topic-metadata">

**Author:** [@Karl](https://community.sonarsource.com/u/Karl)\
**Replies:** 1\
**Last updated:** [September 11, 2024, 11:56am UTC](https://community.sonarsource.com/t/custom-rules-for-pl-sql-implemented-in-java/124879 "2024-09-11T11:56:43Z")

</div>

Hi, At the moment it is only possible to implement custom rules for PL/SQL in XPath 1.0. XPath 1.0 is quite limited (e.g. no support for regular expressions), so developing a custom rule can be a pain. Would it perhap…

---

## [plsql:S1854: False negative](https://community.sonarsource.com/t/plsql-false-negative/119269)

<div class="topic-metadata">

**Author:** [@Karl](https://community.sonarsource.com/u/Karl)\
**Replies:** 1\
**Last updated:** [July 23, 2024, 3:54pm UTC](https://community.sonarsource.com/t/plsql-false-negative/119269 "2024-07-23T15:54:42Z")

</div>

Hi, I’ve noticed that for rule plsql:S1854 no issue is shown for the following snippet: create or replace package body Test is procedure testProcedure is firstName varchar2(30); lastName varchar2(…

---

## [plsql:S5141 - False negative](https://community.sonarsource.com/t/plsql-s5141-false-negative/119274)

<div class="topic-metadata">

**Author:** [@Karl](https://community.sonarsource.com/u/Karl)\
**Replies:** 1\
**Last updated:** [July 23, 2024, 2:48pm UTC](https://community.sonarsource.com/t/plsql-s5141-false-negative/119274 "2024-07-23T14:48:12Z")

</div>

Hi, I’ve noticed that for rule plsql:S5141 no issue is shown for the following snippet: procedure testProcedure is cursor testCursor is select column1, column2 from table1, table2, table3 …

---

## [plsql:PositionalAndNamedArgumentMixCheck does not work with functions](https://community.sonarsource.com/t/plsql-positionalandnamedargumentmixcheck-does-not-work-with-functions/119302)

<div class="topic-metadata">

**Author:** [@Karl](https://community.sonarsource.com/u/Karl)\
**Replies:** 1\
**Last updated:** [July 23, 2024, 1:41pm UTC](https://community.sonarsource.com/t/plsql-positionalandnamedargumentmixcheck-does-not-work-with-functions/119302 "2024-07-23T13:41:41Z")

</div>

Hi, I’ve noticed that rule plsql:PositionalAndNamedArgumentMixCheck does not show issues for functions: create or replace package body Test is procedure testProcedure is isEqual boolean; begin …

---

## [plsql:S1172 - No issues in pkb files](https://community.sonarsource.com/t/plsql-s1172-no-issues-in-pkb-files/118912)

<div class="topic-metadata">

**Author:** [@Karl](https://community.sonarsource.com/u/Karl)\
**Replies:** 3\
**Last updated:** [July 23, 2024, 8:57am UTC](https://community.sonarsource.com/t/plsql-s1172-no-issues-in-pkb-files/118912 "2024-07-23T08:57:27Z")

</div>

Hi, I’ve noticed that for rule plsql:S1172 no issues are shown for functions/procedures in pkb files. Snippet: create or replace package body Test is procedure testProcedure(unusedParam in varchar2) is be…

---

## [plsql:FunctionLastStatementReturnCheck: False positive with CASE](https://community.sonarsource.com/t/plsql-false-positive-with-case/116809)

<div class="topic-metadata">

**Author:** [@Peter0](https://community.sonarsource.com/u/Peter0)\
**Replies:** 1\
**Last updated:** [June 7, 2024, 3:29pm UTC](https://community.sonarsource.com/t/plsql-false-positive-with-case/116809 "2024-06-07T15:29:52Z")

</div>

The following code is marked with This function should be refactored so that its last statement is a RETURN one. sonarlint(plsql:FunctionLastStatementReturnCheck) CREATE FUNCTION test\_case RETURN PLS\_INTEGER AS BEGIN…

---

## [Sonarqube MyBatis plugin not work](https://community.sonarsource.com/t/sonarqube-mybatis-plugin-not-work/62970)

<div class="topic-metadata">

**Author:** [@carlodrs](https://community.sonarsource.com/u/carlodrs)\
**Replies:** 2\
**Last updated:** [May 31, 2024, 2:23am UTC](https://community.sonarsource.com/t/sonarqube-mybatis-plugin-not-work/62970 "2024-05-31T02:23:34Z")

</div>

Hi Guys. I installed the MyBatis plugin on Sonarqube. I wrote de mapper.xml file with the wrong content: \<mapper namespace="sql1" number="1"\> \<select id="select1" parameterType="map" resultType="String"\> …

---

## [Exclude sql files using SonarQube's web interface](https://community.sonarsource.com/t/exclude-sql-files-using-sonarqubes-web-interface/114975)

<div class="topic-metadata">

**Author:** [@Fatima\_Tahiri](https://community.sonarsource.com/u/Fatima_Tahiri)\
**Replies:** 1\
**Last updated:** [May 9, 2024, 12:39pm UTC](https://community.sonarsource.com/t/exclude-sql-files-using-sonarqubes-web-interface/114975 "2024-05-09T12:39:48Z")

</div>

Hello, please how to exclude .sql or .SQL files from analysis using SonarQube’s web interface. Thanks

---

## [PLSQL code analysis](https://community.sonarsource.com/t/plsql-code-analysis/113135)

<div class="topic-metadata">

**Author:** [@Fulvio](https://community.sonarsource.com/u/Fulvio)\
**Replies:** 1\
**Last updated:** [April 12, 2024, 7:33am UTC](https://community.sonarsource.com/t/plsql-code-analysis/113135 "2024-04-12T07:33:55Z")

</div>

Hi all, I have a question: I have some .plsql files to analyze (not an entire project). My company asked me to analyze them to see if there are any problems. I know you need the Enterprise edition (i have CE 10.4). But …

---

## [How to do Sonarqube analysis on SQL scripts](https://community.sonarsource.com/t/how-to-do-sonarqube-analysis-on-sql-scripts/22351)

<div class="topic-metadata">

**Author:** [@ujwala](https://community.sonarsource.com/u/ujwala)\
**Replies:** 4\
**Last updated:** [March 11, 2024, 11:34am UTC](https://community.sonarsource.com/t/how-to-do-sonarqube-analysis-on-sql-scripts/22351 "2024-03-11T11:34:36Z")

</div>

Must-share information (formatted with Markdown): which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension) what are you trying to achieve what have you tried so far to achieve this Hi all, …

---

## [Plsql:1739 Differences in Validation?](https://community.sonarsource.com/t/plsql-1739-differences-in-validation/91381)

<div class="topic-metadata">

**Author:** [@Mathias\_Neuner](https://community.sonarsource.com/u/Mathias_Neuner)\
**Replies:** 5\
**Last updated:** [March 11, 2024, 9:55am UTC](https://community.sonarsource.com/t/plsql-1739-differences-in-validation/91381 "2024-03-11T09:55:01Z")

</div>

I have the following case in my PL/SQL code create or replace package body TestPackage as procedure TestProc(P\_TestIn in pls\_integer) is cursor c\_cursor is select \* from dual where TEST like '\_20%'; …

---

## [Error for Code Analysis sql](https://community.sonarsource.com/t/error-for-code-analysis-sql/110188)

<div class="topic-metadata">

**Author:** [@JOAO\_PAULO\_MOREIRA1](https://community.sonarsource.com/u/JOAO_PAULO_MOREIRA1)\
**Replies:** 1\
**Last updated:** [March 1, 2024, 5:34pm UTC](https://community.sonarsource.com/t/error-for-code-analysis-sql/110188 "2024-03-01T17:34:04Z")

</div>

Hi, i am needing a help, The task Run Code Analysis show the error can not be decided as the file matches patterns of both sonar.lang.patterns.plsql : \*\*/\*.sql,\*\*/\*.pks, we want that sonar validad sql project’s My envi…

---

## [Automatic Analysis for PL/SQL and T-SQL](https://community.sonarsource.com/t/automatic-analysis-for-pl-sql-and-t-sql/109507)

<div class="topic-metadata">

**Author:** [@Alexandre\_Gigleux](https://community.sonarsource.com/u/Alexandre_Gigleux)\
**Replies:** 2\
**Last updated:** [February 26, 2024, 7:13am UTC](https://community.sonarsource.com/t/automatic-analysis-for-pl-sql-and-t-sql/109507 "2024-02-26T07:13:37Z")

</div>

Hello, We are happy to announce that SonarCloud can now scan PL/SQL and T-SQL files when using Automatic Analysis. Before, it was possible to scan PL/SQL and T-SQL files only with CI-based analysis. This brings Automa…

[Next page](https://community.sonarsource.com/tag/plsql/9.md?match_all_tags=true&page=1&tags%5B%5D=plsql)
