Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://github.com/pmd/pmd/issues/3687 below:

[plsql] Parsing exception EXECUTE IMMEDIATE l_sql BULK COLLECT INTO statement · Issue #3687 · pmd/pmd · GitHub

Affects PMD Version:

This error was testing in the following versions:

• 6.41.0
• 6.40.0
• 6.39.0

Description:

Trying to analyze pl/sql code that has EXECUTE IMMEDIATE l_sql BULK COLLECT INTO statement, PMD raises an exception error that indicates "Error while parsing".

Exception Stacktrace:

net.sourceforge.pmd.PMDException: Error while parsing C:\testfolder\example_procedure.prc
	at net.sourceforge.pmd.SourceCodeProcessor.processSourceCodeWithoutCache(SourceCodeProcessor.java:124)
	at net.sourceforge.pmd.SourceCodeProcessor.processSourceCode(SourceCodeProcessor.java:100)
	at net.sourceforge.pmd.SourceCodeProcessor.processSourceCode(SourceCodeProcessor.java:62)
	at net.sourceforge.pmd.processor.PmdRunnable.call(PmdRunnable.java:85)
	at net.sourceforge.pmd.processor.PmdRunnable.call(PmdRunnable.java:29)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: net.sourceforge.pmd.lang.plsql.ast.ParseException: Encountered " "BULK" "BULK "" at line 26, column 36.
Was expecting one of:
    ";" ...
    "||" ...
    "INTO" ...
    "RETURN" ...
    "RETURNING" ...
    "USING" ...
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.generateParseException(PLSQLParser.java)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.jj_consume_token(PLSQLParser.java)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.EmbeddedSqlStatement(PLSQLParser.java:36684)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.UnlabelledStatement(PLSQLParser.java:23959)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.Statement(PLSQLParser.java:24754)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.ProgramUnit(PLSQLParser.java:6835)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.Global(PLSQLParser.java:879)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.Input(PLSQLParser.java:153)
	at net.sourceforge.pmd.lang.plsql.PLSQLParser.parse(PLSQLParser.java:61)
	at net.sourceforge.pmd.lang.AbstractParser.doParse(AbstractParser.java:44)
	at net.sourceforge.pmd.SourceCodeProcessor.parse(SourceCodeProcessor.java:136)
	at net.sourceforge.pmd.SourceCodeProcessor.processSource(SourceCodeProcessor.java:200)
	at net.sourceforge.pmd.SourceCodeProcessor.processSourceCodeWithoutCache(SourceCodeProcessor.java:118)
	... 10 more

Code Sample demonstrating the issue:

CREATE OR REPLACE PROCEDURE EXAMPLE_PROCEDURE IS
   --
   TYPE r_data IS RECORD(
      data_key         NUMBER(10),
      data_description VARCHAR2(100));
   --
   TYPE t_data IS TABLE OF r_data INDEX BY BINARY_INTEGER;
   --
   l_data t_data;
   l_sql  VARCHAR2(500);
   --
BEGIN
   --
   l_sql := 'SELECT 1, ' || CHR(39) || 'First key' || CHR(39) || 
             ' FROM DUAL '||
            'UNION ALL '||
            'SELECT 2, ' || CHR(39) || 'Second key ' || CHR(39) || 
             ' FROM DUAL';
   --
   EXECUTE IMMEDIATE l_sql BULK COLLECT
      INTO l_data;
   --
   FOR x IN l_data.first .. l_data.last LOOP
      DBMS_OUTPUT.Put_Line(l_data(x).data_key);
      DBMS_OUTPUT.Put_Line(l_data(x).data_description);
   END LOOP;
   --
END EXAMPLE_PROCEDURE;

Steps to reproduce:

1. Put the code above ("Code Sample demonstrating the issue" section) in example_procedure.prc
2. Execute PMD analyzer from CLI.
3. See the error showed in the "Exception Stacktrace" section.

Running PMD through: [CLI]

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4