Example of Oracle using cursors to return result sets (C #)

oracle| samples in vs2005+oracle 92010 + Windows XP SP2 Test pass 1, create a cursor variable, use for the return value
Create or replace package types as
Type CursorType is REF CURSOR;
END;2, creating functions (or stored procedures)
Create or Replace function Testpro return types.cursortype is
LC Types.cursortype;
Begin
Open LC for SELECT * from test;
return LC;
End Testpro;3, write C # program (Note: Apply System.Data.OracleClient first)
            OracleConnection conn = new OracleConnection (" Yourconnectstring ");            OracleCommand cmd = new OracleCommand ("Testpro", conn);            cmd. CommandType = commandtype.storedprocedure;              OracleParameter op = new OracleParameter ("C", OracleType.Cursor);             op. Direction = parameterdirection.returnvalue;              CMD. Parameters.Add (OP);             DataSet ds = new DataSet ();            oracledataadapter da = new OracleDataAdapter (cmd);            &nBsp Da. Fill (ds, "test");             This.dataGridView1.DataSource = ds. tables["Test"]; PS: Using the stored procedure method is similar.