Always check against the **Latest SNAPSHOT of JSQLParser** and the [Syntax Diagram](https://jsqlparser.github.io/JSqlParser/syntax_snapshot.html) ### 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)
Activity
manticore-projects commentedon Jan 16, 2025
Greetings.
xmlparse(content sn.CODE||',')is not supported.[-]NOT SUPPORT Oracle xmlagg function [/-][+]Oracle `xmlparse(content ...)` not supported[/+]