用到的几个调用存储过程例子

OmTransactionManager.SetConnectionAndTransaction(myCMD);

myCMD.CommandText ="{call curspkg_join.open_join_cursor1(?, {resultset 0, io_cursor})}";

myCMD.Parameters.Add("ID", OleDbType.Numeric, 4).Value = 0;

OleDbDataReader myReader;

myReader = myCMD.ExecuteReader();

int x;

int i=0;

while (myReader.Read())

{

for (x = 0; x <= myReader.FieldCount - 1; x++)

{

scEntity[i] =new GCEEDAT00SCIRAIEntity ();

scEntity[i].MiseName =myReader.GetValue (x++).ToString ();

scEntity[i].MiseCode =myReader.GetValue (x++).ToString ();

scEntity[i].MinCount =myReader.GetValue (x++).ToString ();

scEntity[i].Success =myReader.GetValue (x++).ToString ();

}

i++;

}

myReader.Close();

public int EXECORASQL(GCEEDAT00CSData argCSData)

{

string constring="Data Source='SE';User ID='mhs';Password='mhs'";

OracleConnection con=new OracleConnection (constring);

con.Open ();

oraexecsql=new OracleCommand ("COUNT_CUSTOM",con);

oraexecsql.CommandType =CommandType.StoredProcedure;

oraexecsql.Parameters .Add("reccount",OracleType.Int16);

oraexecsql.Parameters ["reccount"].Direction =ParameterDirection.Output ;

oraexecsql.ExecuteNonQuery();

int result=Convert.ToInt32 (oraexecsql.Parameters ["reccount"].Value.ToString ());

con.Close ();

return result;

}