ODP.NET

Hi All,
I am currently using the Microsoft Enterprise Library for the Oracle Database Connection and for the DataSet.
I am not so familiar to the .NET frameWork. But still i am learning some of it.

I want to use the REF CURSOR and want to use it from the ASP.NET using Microsoft Enterprise Library.


I have created a package like:

CREATE OR REPLACE PACKAGE PKG_OTN_REF_CURSOR AS
FUNCTION FN_GET_MEMBER_INFO return PKG_REF_CURSOR.REF_CURSOR;
PROCEDURE PR_GET_MEMBER_INFO(p_rc OUT PKG_REF_CURSOR.REF_CURSOR);
END PKG_OTN_REF_CURSOR;

CREATE OR REPLACE PACKAGE BODY PKG_OTN_REF_CURSOR AS
FUNCTION FN_GET_MEMBER_INFO RETURN PKG_REF_CURSOR.REF_CURSOR IS
l_cursor PKG_REF_CURSOR.REF_CURSOR;
BEGIN
OPEN l_cursor FOR
SELECT member_cd,
full_name
FROM MEMBER
WHERE UPPER(FULL_NAME) LIKE '%TEST%';
RETURN l_cursor;
END;

PROCEDURE PR_GET_MEMBER_INFO(p_rc OUT PKG_REF_CURSOR.REF_CURSOR) IS
BEGIN
OPEN p_rc FOR
SELECT member_cd,
full_name
FROM MEMBER
WHERE UPPER(FULL_NAME) LIKE '%RATNA%';
END;
END PKG_OTN_REF_CURSOR;

And i want to use this REF CURSOR result from ASP.NET.
So, can anyone help me on how to use this REF CURSOR.

Thanks

Edited by: pcoder on Mar 25, 2009 4:38 AM