Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.....

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


Please Help Members By Posting Answers For Below Questions

Explain when to use local filter and when to use global filter?

1332


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1088


how to create reports on screech?

2538


how to create metric universe ?

2329


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 ?

2040


What is package in BO

3188


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1370


Explain about a tricky situation for which you found a very simple solution?

986


Did you face any problems while creating reports? Name? Solutions?

3681


What is the difference in creating filters in designer and business objects?

1011


what is the difference b/w the refresh and buffered data?

2320


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.

3453


How to restrict password to a user while sending a document in .pdf format

2329


can anybody tell me about complicated object you have created

3210


Explain is there any default username & pwd for bo designer & supervisor?

990