(shardingsphere) branch master updated: Fix Oracle PLSQL block statements not extracted (#34668)

[duanzhengqiang]

This is an automated email from the ASF dual-hosted git repository.

duanzhengqiang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git


The following commit(s) were added to refs/heads/master by this push:
     new 78c7e6336e9 Fix Oracle PLSQL block statements not extracted (#34668)
78c7e6336e9 is described below

commit 78c7e6336e9ca4c4a7a4cae08214985875679872
Author: ZhangCheng <chengzh...@apache.org>
AuthorDate: Fri Feb 14 12:38:54 2025 +0800

    Fix Oracle PLSQL block statements not extracted (#34668)
---
 .../oracle/visitor/statement/type/OracleDDLStatementVisitor.java       | 3 +++
 1 file changed, 3 insertions(+)

diff --git 
a/parser/sql/dialect/oracle/src/main/java/org/apache/shardingsphere/sql/parser/oracle/visitor/statement/type/OracleDDLStatementVisitor.java
 
b/parser/sql/dialect/oracle/src/main/java/org/apache/shardingsphere/sql/parser/oracle/visitor/statement/type/OracleDDLStatementVisitor.java
index cc0258fbdcb..d5fe2db93d9 100644
--- 
a/parser/sql/dialect/oracle/src/main/java/org/apache/shardingsphere/sql/parser/oracle/visitor/statement/type/OracleDDLStatementVisitor.java
+++ 
b/parser/sql/dialect/oracle/src/main/java/org/apache/shardingsphere/sql/parser/oracle/visitor/statement/type/OracleDDLStatementVisitor.java
@@ -1654,6 +1654,9 @@ public final class OracleDDLStatementVisitor extends 
OracleStatementVisitor impl
     
     @Override
     public ASTNode visitPlsqlBlock(final PlsqlBlockContext ctx) {
+        if (null != ctx.body() && null != ctx.body().statement()) {
+            ctx.body().statement().forEach(this::visit);
+        }
         return new OraclePLSQLBlockStatement();
     }