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

From: <>
Date: Mon, 14 Jan 2008 12:30:32 GMT
Message-ID: <IBIij.8795$W73.4273@trnddc04>

"A Real Dead One" <> wrote in message
> 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
> 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();

I haven't used c#, but have you gone to I believe they have a whole slew of examples there on this.
Jim Received on Mon Jan 14 2008 - 06:30:32 CST

Original text of this message