[Mono-list] Oralce+Mono

DazZz ajlekceu_p at yahoo.com
Tue Feb 13 01:49:50 EST 2007


 Mono 1.2.3
OS: Ubuntu 6.0
Oracle client 10.2.0  

string connString = "User ID=user;Password=password;Data Source=bux";
  OracleConnection conn = new OracleConnection(connString);
  OracleCommand cm = conn.CreateCommand();
 
  cm.CommandText = "CATEGORY_PKG.sellist";
  cm.CommandType = System.Data.CommandType.StoredProcedure;
  cm.Parameters.Add("c", OracleType.Cursor).Direction =
ParameterDirection.Output;
  OracleDataAdapter da = new OracleDataAdapter(cm);
  DataSet ds = new DataSet();
  da.TableMappings.Add("Table", "CATEGORY");
  try
  {
      da.Fill(ds);
  }
  catch (Exception e)
  {
      MessageBox.Show("Error:" + e.Message, "Error",
       MessageBoxButtons.OK, MessageBoxIcon.Error);
      return false;
  }
 
///------------------
work catch, e.Message is null. In Visual Stuido 2005 that does work

 why not woking da.fill ??
-- 
View this message in context: http://www.nabble.com/Oralce%2BMono-tf3218906.html#a8939350
Sent from the Mono - General mailing list archive at Nabble.com.



More information about the Mono-list mailing list