Upgrade Database to 11 causes XML/BI Pub Reports to fail
All,
We have upgraded a test environment from 9.2.0.8 to 11. Everything seems to work fine except for some custom reports that use sql to produce XML data, then load that data into a Template. The files are all .sql extensions and use this code from the beginning and end.
select dbms_xmlgen.getxml('
<-- valid sql query here -->
') XML from dual
Any report has output of ORA-24813: cannot send or receive an unsupported LOB error.
Any Suggestions?
Thanks in Advance.
We have upgraded a test environment from 9.2.0.8 to 11. Everything seems to work fine except for some custom reports that use sql to produce XML data, then load that data into a Template. The files are all .sql extensions and use this code from the beginning and end.
select dbms_xmlgen.getxml('
<-- valid sql query here -->
') XML from dual
Any report has output of ORA-24813: cannot send or receive an unsupported LOB error.
Any Suggestions?
Thanks in Advance.
0