Skip to content

Oracle xmlparse(content ...) not supported #2146

Open
@krislint

Description

@krislint

Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram

Failing SQL Feature:

  • Brief description of the failing SQL feature
  • xmlagg can't be parsed

SQL Example:

  • Simplified Query Example, focusing on the failing feature
         select xmlagg(xmlparse(content  sn.CODE||',')order by sn.CODE).getclobval() as SN
         from GV_SYS_CODEINFO sn
    

Software Information:

  • JSqlParser version 5.1
  • Database Oracle 11g

Exception in thread "main" net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "("
at line 1, column 14.

Was expecting one of:

<EOF>
<ST_SEMICOLON>

at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:352)

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions