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
Explain when to use local filter and when to use global filter?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
how to create reports on screech?
how to create metric universe ?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
What is package in BO
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Explain about a tricky situation for which you found a very simple solution?
Did you face any problems while creating reports? Name? Solutions?
What is the difference in creating filters in designer and business objects?
what is the difference b/w the refresh and buffered data?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
How to restrict password to a user while sending a document in .pdf format
can anybody tell me about complicated object you have created
Explain is there any default username & pwd for bo designer & supervisor?