Pls say any one...
how will u create a report using oracle stored procedure?
could u pls send me the step.....
Answer Posted / deepak
u need to create a stored procedure using in/out parameter
of a ref cursor.the parameter of the proc should be in only.
then create a connection to the database using middleware.
suppose u have created a proc on oracle 9i, then make the
connection using oracle client.mention the user
name/password and the data base name in the connection.
then in the report section use the stored procedure as data
provider and select the proc using which you want data ang
generate the report.
deepak
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between datawarehousing and businessintelligence?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
How to generate the report from excel sheet?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
What is package in BO
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
What is a fantrap in business objects?
How to schedule the report in b.o?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
what are the tables used in health care domain project and columns used in report?
Explain is data mart?
What task is 98% of the required work of a business analyst?
8. How much supervision have you typically received in your previous job?