| Getting ResultSet Using Stored procedure [message #161661] |
Wed, 17 May 2006 01:11 |
Eclipse User |
|
|
|
Originally posted by: Sunitha_mrss1.yahoo.co.in
Hi,
How to get the resultset using stored procedure in birt.Please help me
out in sloving that problem.
I have created a package as below first:
CREATE OR REPLACE PACKAGE Types AS
TYPE cursor_type IS REF CURSOR;
END Types;
/
After that I have created a procedure as follows:
CREATE OR REPLACE PROCEDURE GetEmpRS (p_recordset OUT Types.cursor_type) AS
BEGIN
OPEN p_recordset FOR
SELECT metricid,metricvalue
FROM metric_table;
END GetEmpRS;
/
In BIRT Iam calling as
{call GetEmpRS(?)}
How to declare the cursor in birt.Is it possible?
Please help me out to get the resultset data.
|
|
|
Powered by
FUDForum. Page generated in 0.03142 seconds
Home