I have successfully been able to get .NET to return a cursor from an Oracle stored procedure using tips from this forum. A question has come up from one of our developers ... who closes the cursor after it returns the resultset, Oracle or .NET? Guess I'm not sure. The stored procedure follows...

CREATE OR REPLACE PACKAGE Types AS
   TYPE pCursor IS REF CURSOR;
   TYPE reviewersCursor IS REF CURSOR RETURN reviewers%ROWTYPE;
END Types;


CREATE OR REPLACE PROCEDURE
sp_GetReviewers(myCursor out Types.reviewersCursor) IS


BEGIN
   OPEN myCursor FOR SELECT * FROM reviewers ORDER BY id;
END sp_GetReviewers;

Who does close the sp after it executes? Thanks.