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 are the complex reports you have created. Tell me with example?

7 Answers   Insurance, TCS,

---

what are the documentations u r created?

2 Answers   Wipro,

---

can i use stored procedure in webi?

4 Answers   CTS, Wipro,

---

We can have two separate installations of BOE XI 3.1 on a single server?

2 Answers  

---

GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?

1 Answers  

---

What is global filters and local filters

3 Answers   IBM,

---

if we shortcut join between two tables what will be the output?that it will give all columns or same columns?

2 Answers  

---

How will you test a BO report

3 Answers   Infosys,

---

how did u give developed universe to ur client?

1 Answers  

---

What are the major problems will occur while migrating to the one version to another version?

2 Answers   CTS,

---

HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?

1 Answers  

---

How you get the requirement from client?

3 Answers   TCS,

---