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;
}
