u need to create a stored procedure using in/out parameter of a ref cursor

Pls say any one...
how will u create a report using oracle stored procedure?
could u pls send me the step.....

Question Posted / deepak

4 Answers
11805 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

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