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

Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?

2 Answers   Accenture,

---

wat is difference b/w break and section?

4 Answers  

---

what is the difference b/w star and snowflack schema in dataware house?

8 Answers  

---

Explain what sort of existing documents should business analysts refer to when starting on a new project?

0 Answers  

---

in BO module, you forgot all password even all user in business object, designer, supervisor, gen.supervisor everythicg, how to you recover your datas?

1 Answers   iFlex,

---

suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?

2 Answers   IBM,

---

Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

0 Answers  

---

what is diff between webi,deski,infoview

2 Answers  

---

how to prepare the documentation in business objects and where to get the requirement?

0 Answers   IBM, TCS,

---

how u link universes of same functional domain ?

2 Answers   Business Intelligence Analytics, IBM,

---

1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?

2 Answers  

---

What is the Computation error? how to solv it?

1 Answers  

---