JSqlParser icon indicating copy to clipboard operation
JSqlParser copied to clipboard

Oracle `xmlparse(content ...)` not supported

Open krislint opened this issue 10 months ago • 1 comments

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)

krislint avatar Jan 16 '25 06:01 krislint