Pls say any one...
how will u create a report using oracle stored procedure?
could u pls send me the step.....
- 4 Answers
- 12255 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
What are the data types present in bo? What happens if we implement view in the designer and report?
What sort of existing documents should business analysts refer to when starting on a new project?
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!!!
how many reports have u created ? explain a few.
Explain about a tricky situation for which you found a very simple solution?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
How would you format some text using css to be verdana and bold?
explain in detail about type 3?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain about a time when you discovered a more efficient way to do a work task?
What is aggregate table and aggregate fact table ... Any examples of both?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
what is document design in boxi,have u participate in that
What is the difference between business requirement document and use case document.
