call an Oracle stored proc with oledb .net Thanks to Emilio who ask the question on microsoft.public.dotnet.framework.adonet newsgroup.

here is a syntaxe I've just test :

this.cmdInsertLib.CommandText = "MyStoredProc";
this.cmdInsertLib.CommandType = System.Data.CommandType.StoredProcedure;
this.cmdInsertLib.Parameters.Add(
  new System.Data.OleDb.OleDbParameter("P1",
  System.Data.OleDb.OleDbType.VarWChar, 100));
this.cmdInsertLib.Parameters.Add(
  new System.Data.OleDb.OleDbParameter("P2", 
  System.Data.OleDb.OleDbType.VarWChar, 100));
cmdInsertLib.Parameters[0].Value = textBox1.Text.ToString();
cmdInsertLib.Parameters[1].Value = textBox2.Text.ToString();
cmdInsertLib.ExecuteNonQuery();

that's all folks

hope this helps

comments are welcome  ¶ 6:23 AM