Pls say any one...
how will u create a report using oracle stored procedure?
could u pls send me the step.....
Answer Posted / reshma
Deepak,
ur answer has helped me a lot.Thanx a tonne. Guys, pls
follow his steps for Creating report using SP:
1-Select Data---New Data Provider--Stored Procedure
2-Select or define the db connection
3-Choose the stored procedure
4-Specify stored procedure as the data source
5-Define parameters
Use REF CURSOR with IN/OUT parameter.
Ref cursor is a cursor variable that points to any cursor,
mainly used for returning the CURSOR OUTPUT.
Eg:
CREATE OR REPLACE PROCEDURE BO_proc(proc_cur IN OUT
sys_refcursor)
AS
BEGIN
OPEN proc_cur FOR SELECT * FROM EMP;
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
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
What is a fantrap in business objects?
explain in detail about type 3?
Explain about alerts in bos, under what situation we need to use alerts?
How can you first report in Business Objects by using broadcast agent?
Explain how many universes can be created in a project?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
What is a bo repository?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What are the steps to do to use alerts in bo?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
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!!!
What Is The Difference Between Oltp And Olap?