/ 详情

不支持open cusor for with...语法

Backlog
Opened this issue  
2021-05-14 10:54

ORACLE数据库中,需要使用游标,大致写法如下

 open p_cursor for
      with password_before as(
                           .....

解析该过程时,会报错(猜测是不是没读到for关键字?)

om.alibaba.druid.sql.parser.ParserException: TODO pos 8253, line 144, column 8, token WITH

	at com.alibaba.druid.sql.parser.SQLStatementParser.parseOpen(SQLStatementParser.java:4833)
	at com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser.parseStatementList(OracleStatementParser.java:629)
	at com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser.parseBlock(OracleStatementParser.java:1841)
	at com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser.parseCreateProcedure(OracleStatementParser.java:2719)

输入图片说明
测试版本(1.1.23和1.2.6)

Comments (0)

ZHANGYULONG created任务
ZHANGYULONG set related repository to wenshao/druid
展开全部操作日志

Sign in to comment

状态
Assignees
Milestones
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
Branches
Planed to start   -   Planed to end
-
Top level
Priority
参与者(1)