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 ...

Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?

2 Answers   HCL,

---

Can any one say me wat does"maintanence of universe" means wit?

2 Answers   Business Intelligence Analytics, NAL, TCS,

---

what are the all possible reasons of getting partial result on a webi report?

3 Answers   L&T,

---

What is thin client And thick client..?

2 Answers  

---

What is the difference between user and versatile user?

0 Answers  

---

Can any one gve me the complete information abt Certfication of Business Objects ?

2 Answers  

---

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

2 Answers   Accenture, Rolta, TCS,

---

What is user docs and how to use this option in bo?

1 Answers   Bank of Baroda,

---

Can we do the slice and dice in webintellegence?

5 Answers   IBM,

---

what is difference between folders and category ?

4 Answers   Tech Mahindra,

---

. In production reports, some dimensions are missing. how do you load these dimensions in production

2 Answers   TCS,

---

5.what is LOV? where it is store?

3 Answers   TCS,

---