Pls say any one...
how will u create a report using oracle stored procedure?
could u pls send me the step.....
- 4 Answers
- 11052 Views
- TCS, I also Faced
- E-Mail Answers
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
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What is Indexing? how did u implement indexing?
How we drill up week to month?
How to schedule the report in b.o?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What is the difference between slice and dice and cross tab report?
Explain what is the difference between slice and dice and cross tab report?
How to execute the plsql procedure from the report by clicking with mouse?
Explain 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?
Difference between zabo and webi?
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 the difference between condition & filter?
