XMLQuery() function: xquery string max length?
625055Mar 12 2008 — edited Aug 15 2008Is there a maximum length for a xquery passed to the XMLQuery() function?
I have a very complex xquery of about 15000 characters. It works fine in Berkeley XML DB. I'm trying to execute it by the Oracle query:
select xmlquery('...my xquery...' returning content) from dual
Executing this query in Oracle SQL Developer, it returns the error
"SQL Error: ORA-19114: XPST0003 - error during parsing the XQuery expression: "
followed by a part of my xquery with the end truncated.
Executing the query from my application (ASP.NET 2.0), the returned error is:
"Oracle exception message: ORA-03113: end-of-file on communication channel"
Reducing the length of the xquery, removing some returned nodes, the xquery works fine. I've done various tests, alternating the removed nodes: the xquery result depends by the xquery length, not by the returned nodes or the xquery syntax.
I'm sure that the syntax of my xquery is correct. I'm trying it in Berkeley XML DB, at the same time.
If there is a limit to the length of the xquery string, how can I execute my query?
Or I cannot use Oracle DB XML in my application?
Thank you.
Mirko