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

"A Real Dead One" <ilkayaktas_at_gmail.com> wrote in message news:647405e4-04eb-4f75-ab41-1e4bf9b5cfc2_at_m77g2000hsc.googlegroups.com...
> 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';
>
> END RETURN_RESULT_SET;
>
>
> --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 otn.oracle.com. I believe they have a whole slew of examples there on this.
Jim Received on Mon Jan 14 2008 - 06:30:32 CST