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 error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...

1 Answers   TCS,

---

How many built-in objects are created in Business Objects repository?

2 Answers  

---

Explain what is aggregate table and aggregate fact table ... Any examples of both?

0 Answers  

---

i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact tables in a report?

4 Answers   Cap Gemini,

---

5.what is slowly changing dimension ?

2 Answers   IBM,

---

Are you in Developing or Support in BUSINESS OBJECTS. What is the difference? what are the responsibilites in both?

2 Answers   CSC,

---

1. what is import wizard and its purpose ? 2. what is publishing wizard and its purpose ?

4 Answers   KPIT, TCS,

---

difference between web intelligence,crystal reports and desktop intelligents

4 Answers  

---

What are the Input and Output Context Operators.

4 Answers   Bosch, iNautix,

---

Any body help me...what are challenges did u face in Business object project?

1 Answers  

---

Can you please send me the migration related issues .

0 Answers  

---

How to create an popup in the WEBI report if the report is showing partial result?

2 Answers   Banking, IBM,

---