Answer / deepak

hi chandu,
this is a sample one

create or replace procedure proc_name(proc_cur in out
sys_refcursor)
as
begin
open proc_cur for select * from tab;
end;

Answer / reshma

Deepak,
ur answer has helped me a lot.Thanx a tonne. Guys, pls
follow his steps for Creating report using SP:

1-Select Data---New Data Provider--Stored Procedure
2-Select or define the db connection
3-Choose the stored procedure
4-Specify stored procedure as the data source
5-Define parameters


Use REF CURSOR with IN/OUT parameter.
Ref cursor is a cursor variable that points to any cursor,
mainly used for returning the CURSOR OUTPUT.
Eg:

CREATE OR REPLACE PROCEDURE BO_proc(proc_cur IN OUT
sys_refcursor)
AS
BEGIN
OPEN proc_cur FOR SELECT * FROM EMP;
END;
/

Answer / 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

Answer / chandru

Hi Deepak,
Thanks for giving this information.

if it possible give me a sample stored procedure coding ...

What is the difference between slice and dice and cross tab report?

0 Answers  

---

12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?

3 Answers  

---

Why do we need metrics and sets?

1 Answers  

---

How to delete the duplicate colums in a sql table ?

3 Answers   IBM,

---

Is it necessary to give joins to the aggrigate tables in the universe?

2 Answers  

---

---

What is security domain in Business Objects?

4 Answers   Polaris,

---

How to get top 5 rows of a selected column?

3 Answers   Patni,

---

What is difference between custom hierarchy and report based hierarchy?

0 Answers  

---

How to take backup of CMS database and Auditing database, please suggest me with a best possible ways.?

1 Answers  

---

what are the disadvantages of alias?

6 Answers   Patni,

---

What are the errors u have faced in creating reports in business objects and explain some?

3 Answers   TCS,

---

What is #refresh,#hash,#Comupation error and How to resolve #refresh,#hash error.

1 Answers   Accenture,

---