Help S.O.S: How to return resultset from procedure and use it on c#

From: A Real Dead One <>
Date: Mon, 14 Jan 2008 02:27:16 -0800 (PST)
Message-ID: <>

Hello everybody, i need your help. I got a oracle procedure that gives an parameter cursor. I want to use the resultset on c#. Below my code is written. When i want to call procedure from c#, i'm confused to send parameter. Wichc typed parameter is sent from c# or how to solve this mess.

--This is my types package

create or replace PACKAGE Types AS
  TYPE cursor_type IS REF CURSOR;
END Types;

--my procedure body

create or replace
PROCEDURE RETURN_RESULT_SET(ccc in out TYPES.cursor_type) is

BEGIN     open ccc for 'select * from PERSONEL';

--my c# commands

OleDbCommand DbCommand = new OleDbCommand("RETURN_RESULT_SET", con); DbCommand.CommandType = CommandType.StoredProcedure; ......
OleDbDataReader myReader = DbCommand.ExecuteReader(); Received on Mon Jan 14 2008 - 04:27:16 CST

Original text of this message