AnsweredAssumed Answered

Materialized query error

Question asked by matej256 on Apr 22, 2015
Latest reply on May 27, 2015 by matej256

Hi all,


Could you plase explain me how can we write "materialize" statement in XBL file in different way?


This satatement (part of a SQL code in xbl file) doesn't work:


WITH TASKMS AS (SELECT /*+ materialize */ T1.PRID ....


we also've tried this


WITH TASKMS AS (SELECT /*+ materialize */ T1.PRID,


but wihtou success.


Could you plase help me asap if possible? Many thanks




Errors from logs:

com.niku.xql2.XQLInvalidFileException: Error parsing xbl: /home/clarity/niku/clarity/META-INF/timeadmin/xbl/timesheets/timesheetData.xbl


org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.