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
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

Hi,

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
else 
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.

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


Current Time: Thu Mar 28 15:53:15 CDT 2024