Interested to Buy Any Domain ? << Click Here >> for more details...
Pls say any one...
how will u create a report using oracle stored procedure?
could u pls send me the step.....
- 4 Answers
- 12155 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
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
How many universes can be created in a project?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Explain about a time when you discovered a more efficient way to do a work task?
What is the difference between condition & filter?
What are all difference between business objects 6.5 and xi r2?
How to execute the plsql procedure from the report by clicking with mouse?
how get the grand total in master-detail report?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Explain what are the measure objects?
Is there any other repository domains rather than universe, security, document?
any difficulitis have you phase while creating bo reports and how did u solve it
What is the difference in creating filters in designer and business objects?
What is report template in b.o?
What task is 98% of the required work of a business analyst?
