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
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Explain how many universes can be created in a project?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
U r project in which stage in implementation?
Explain what is the difference between business requirement document and use case document.
Can Bo generates the Report from the cubical data Explain?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Can we create universe with no cache??
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Explain what are the steps to be taken to schedule the report?
How to restrict password to a user while sending a document in .pdf format
how to create reports on screech?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...