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
- 11994 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 is the profile and package?
Explain the difference between union and group?
Difference between b.o 5.1 and 6.1b?
What is the difference between slice and dice and cross tab report?
how get the grand total in master-detail report?
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
How to execute the plsql procedure from the report by clicking with mouse?
What Is Snow Flake Schema?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Did you face any problems while creating reports? Name? Solutions?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain about alerts in bos, under what situation we need to use alerts?
What is difference between webi and infoview?
what is document design in boxi,have u participate in that
