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

1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?

3 Answers  

---

Steps to create alias and apply

2 Answers  

---

What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash

7 Answers   TCS,

---

How to create Index to the table in the universe designer and how it improves the Query performence

0 Answers  

---

What is the difference between derived table and views? which one gives better performance?

2 Answers   TCS,

---

when you have three fact table and there is no relationship between them. How you will tackle the issue.

2 Answers   BMC, TCS,

---

what r the main topics to prepare for the crystal reports? could any on help me? i want to preparing for the interviews? and also send any pdf file?

1 Answers   TCS,

---

What is domain? How many are there in a basic setup? What are they?

1 Answers  

---

Explain how we drill up week to month?

0 Answers  

---

how to overcome overflow of data in a report

6 Answers  

---

What services the broadcast agent offers on the server side?

2 Answers   TCS,

---

while migrate bo 5.1 report into boxir2 ,what are the problems faced

2 Answers  

---