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 xcelsius architecture?

4521


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

939


Explain about a task that really tested your analytical abilities?

1188


Explain what are the measure objects?

933


1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

6775


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

996


What is a fantrap in business objects?

1101


Explain what are the steps to be taken to schedule the report?

1042


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

935


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

1301


What is the profile and package?

2247


1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3514


how to create reports on screech?

2487


Explain what are the steps to do to use alerts in bo?

1022


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

3778