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
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What is the dense rank?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What is a bo repository?
How to create Index to the table in the universe designer and how it improves the Query performence
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
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!!!
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Explain when to use local filter and when to use global filter?
What is the difference between user and versatile user?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What are the join problems comes appart from loop,chasm & fan Traps
What is the functional & architectural differences between business objects and web intelligence reports?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
What is Indexing? how did u implement indexing?