Long lines rule and multi line text

Rule “FORMAT - Avoid long lines” (plsql:LineLength) reports an issue when multi line string is used.

sqlText := 'SELECT name, surname
   FROM party_schema.party_table
   WHERE valid=''Y''
     AND department_id = ' || to_char(department_id, '999990');

Sonar Qube version: 5.6.3


We fixed this issue as part of SonarPLSQL 2.9: SONARPLSQL-538
I suppose that you’re using an old version of SonarPLSQL: you specified the version for SonarQube but not for SonarPLSQL.


Hi Pierre-Yves,

thanks, we have SonarPLSQL 2.8 so problem will be solved after upgrade.