[MPMD-154] Support PLSQL language

• Type: Wish
• Status: Closed
• Priority: Minor
• Resolution: Won't Fix
• Component/s: CPD, PMD
• Assignee: Unassigned
• Reporter: Stuart Turton
• Created: 09/Jul/12 16:12
• Updated: 16/Sep/16 08:26
• Resolved: 07/Jan/15 12:10

Description

DB2, Oracle, EnterpriseDB and TimesTen databases support PLSQL.

Attached is the PLSQL (plus some SQL*Plus) Tokenizer extracted from the PLDoc project.

"
StuMacBook:pmd-plsql$ ./cpd_example.sh PLDoc(CPD) version: ${project.version}
LanguageFactory info - attempting to load language "plsql"
Searching for "net.sourceforge.pmd.cpd.PlsqlLanguage" using net.sourceforge.pmd.cpd.LanguageFactory
.............. "net.sourceforge.pmd.cpd.PlsqlLanguage" using ClassLoader=sun.misc.Launcher$AppClassLoader@558fe7c3
.............. "net.sourceforge.pmd.cpd.PlsqlLanguage" using sun.misc.Launcher.AppClassLoader
LanguageFactory warn - failed to load language "Plsql"
LanguageFactory info - attempting to load language "PLSQL"
Searching for "net.sourceforge.pmd.cpd.PLSQLLanguage" using net.sourceforge.pmd.cpd.LanguageFactory
.............. "net.sourceforge.pmd.cpd.PLSQLLanguage" using ClassLoader=sun.misc.Launcher$AppClassLoader@558fe7c3
.............. "net.sourceforge.pmd.cpd.PLSQLLanguage" using sun.misc.Launcher.AppClassLoader
Object(s) like ANONYMOUS.%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).
PLSQLTokenizer: ignoreComments==true
PLSQLTokenizer: ignoreIdentifiers==true
PLSQLTokenizer: ignoreLiterals==true
Object(s) like APEX_PUBLIC_USER.%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).
Object(s) like APPQOSSYS.%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).
Object(s) like BI.%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).
Object(s) like CACHEADM.%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).
Object(s) like DIP.%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).
Object(s) like HR_TRIG.%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).
Object(s) like MDDATA.%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).
Object(s) like MGMT_VIEW.%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).
Object(s) like ORDDATA.%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).
Object(s) like OWBSYS.%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).
Object(s) like OWBSYS_AUDIT.%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).
Object(s) like system.SH%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).
Object(s) like SI_INFORMTN_SCHEMA.%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).
Object(s) like SPATIAL_CSW_ADMIN_USR.%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).
Object(s) like SPATIAL_WFS_ADMIN_USR.%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).
Object(s) like TIMESTEN.%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).
Object(s) like XS.%%%% do not exist or system does not have enough permissions (SELECT_CATALOG_ROLE role).

StuMacBook:pmd-plsql sturton$

"

Issue Links

• is related to: MPMD-221 Support all languages that PMD supports