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

 

 

Note:

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.

 

 

 

Matej

Outcomes