General OBIEE

Get Involved. Join the Conversation.

Topic

    Nirmal Kumar L
    Error occurs in query when we add one line in where...
    Topic posted August 23, 2017 by Nirmal Kumar LBronze Medal: 1,250+ Points, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Core HR, Data Models, OBI Answers, OBIEE Answers, Report Delivery, Report Layouts, Report Output, Reports, Sample Reports, SQL 
    44 Views
    Title:
    Error occurs in query when we add one line in where condition
    Summary:
    Error occurs in query when we add one line in where condition
    Content:

    Hi,

     

    While adding this line in the existing query the below error occurs.

     

    Line used in where statement: XMLTYPE(htd.data_cache).EXTRACT('/TRANSACTION/BUSINESSDATA/AM/TXN/EO/ActionOccurrencesEORow/ActionName/DATA/text()').getStringVal() <> ' '

     

    Error message : java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error ORA-06512: at "SYS.XMLTYPE", line 272 ORA-06512: at line 1

     

    Please help me to solve this. I also attached the full query below.

     

    Thanks and regards,

    Nirmal kumar

    •  
    Document: