Help S.O.S: How to return resultset from procedure and use it on c#
Date: Mon, 14 Jan 2008 02:27:16 -0800 (PST)
Message-ID: <647405e4-04eb-4f75-ab41-1e4bf9b5cfc2@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();
Received on Mon Jan 14 2008 - 04:27:16 CST