Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

email bursting query issue with xml clob data

Received Response
32
Views
1
Comments
Rank 1 - Community Starter
edited Jan 7, 2024 3:34PM in Oracle Analytics Publisher

Summary

email bursting query issue with xml clob data

Content

I am getting below error while using the xml clob data in email bursting query, can we use the xml clob data in email bursting query?

Job processor caused exception

[INSTANCE_ID=EBD1DWRABv01T.bedas.local.1453387453537] [INSTANCE_JOB_ID=1585]::::ERROR_GETTING_REPORT_DATA::[INSTANCE_ID=EBD1DWRABv01T.bedas.local.1453387453537] INSTANCE_JOB_ID=[1585] oracle.xdo.XDOException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error

ORA-06512: at "SYS.XMLTYPE", line 272

ORA-06512: at line 1

oracle.xdo.XDOException: oracle.xdo.XDOException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error

ORA-06512: at "SYS.XML

Answers

  • Rank 1 - Community Starter

    I am also looking for same solution. please let me know, If you get the Answer.


    Thanks

    Kasi

Welcome!

It looks like you're new here. Sign in or register to get started.