Pls say any one...
how will u create a report using oracle stored procedure?
could u pls send me the step.....
Answer Posted / deepak
hi chandu,
this is a sample one
create or replace procedure proc_name(proc_cur in out
sys_refcursor)
as
begin
open proc_cur for select * from tab;
end;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How were the reports scheduled and how to resolve unexecuted documents?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Explain about a time when you discovered a more efficient way to do a work task?
How to open a universe with out using the Designer ??
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
How to execute the plsql procedure from the report by clicking with mouse?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What is a bo repository?
What is difference between custom hierarchy and report based hierarchy?
Which versions are used in the bo dashboard work?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Is there any other repository domains rather than universe, security, document?
What are all difference between business objects 6.5 and xi r2?
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain is there any default username & pwd for bo designer & supervisor?