| Oracle 1og reports to BI Publisher [message #448953] |
Thu, 25 March 2010 23:52 |
|
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
