Represents Oracle cursor.
The following example demonstrates how to get table data as cursor:
...
string cmdText = "BEGIN OPEN :cur FOR SELECT * FROM dept; END;";
UniCommand cmd = new UniCommand(cmdText, myConnection);
cmd.Parameters.Add("cur", UniDbType.Cursor);
cmd.Parameters["cur"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
UniCursor myCursor = (UniCursor)cmd.Parameters["cur"].Value;
myDataAdapter.Fill(dataSet, "Table", myCursor);
...
...
Dim cmdText As string = "BEGIN OPEN :cur FOR SELECT * FROM dept; END;"
Dim cmd As UniCommand = new UniCommand(cmdText, myConnection)
cmd.Parameters.Add("cur", UniDbType.Cursor)
cmd.Parameters("cur").Direction = ParameterDirection.Output
cmd.ExecuteNonQuery()
Dim myCursor As UniCursor = CType(cmd.Parameters("cur").Value, UniCursor)
myDataAdapter.Fill(dataSet, "Table", myCursor)
...
System.Object
Devart.Data.Universal.UniCursor