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

What is the difference between datawarehousing and businessintelligence?

1098


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

1378


How to generate the report from excel sheet?

1179


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3842


What is package in BO

3200


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

1037


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2149


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

2265


What is a fantrap in business objects?

1170


How to schedule the report in b.o?

1030


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

1111


what are the tables used in health care domain project and columns used in report?

4512


Explain is data mart?

1020


What task is 98% of the required work of a business analyst?

1049


8. How much supervision have you typically received in your previous job?

2255