Home » Fusion Middleware & Colab Suite » Business Intelligence » Oracle 1og reports to BI Publisher
Oracle 1og reports to BI Publisher [message #448953] Thu, 25 March 2010 23:52
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member


I am new to BI Publisher and we are converting some reports which are developed Reports Developer 10g to Oracle BI Publisher.I have a following requirement.

Oracle Report is using Refcursor Query which is written in a Database Package, I believe that we cannot have Refcursor Datatype in BI Publisher.

The Refcursor is getting loaded like following,

select count(*) into l_cnt from XYZ;
if l_Cnt > 0 then 
open refcursor1 for 
select a from XYZ1
open refcursor1 for 
select d from XYZ2
end if;

How can I use the above logic in BI Publisher, If I select SQL Query then I need to convert the above logic into one query.

Please suggest.

Ashoka BL
Previous Topic: Blank Charts in BI EE
Next Topic: Calling Oracle Functions in Data Template
Goto Forum:

Current Time: Fri Dec 04 21:21:29 CST 2020