高手GG这边看过来：c#.net可以调用oracle里面创建的包吗？

Question

当然可以了!直接在SQL语句中写就是了!例如:
SELECT package.funcname(parameter1,parameter,...) from dual;

Answer 1

给你一个调用包的例子看看:public int Exec_UpdateOrder(string v_user_login_name,string v_item,string v_qty,string v_need_by_date,string v_flag,string proc_name)  <---这里的proc_name是过程名
{
int i;
cmdOra.Parameters.Clear();
cmdOra.CommandText=proc_name;
cmdOra.CommandType=CommandType.StoredProcedure;
cmdOra.Connection=new clsPublic().ConnectDB();cmdOra.Parameters.Add("p_user_login_name",OleDbType.VarChar);
cmdOra.Parameters.Add("p_item",OleDbType.VarChar);
cmdOra.Parameters.Add("p_qty",OleDbType.VarChar);
cmdOra.Parameters.Add("p_need_by_date",OleDbType.VarChar);
cmdOra.Parameters.Add("p_flag",OleDbType.VarChar);
cmdOra.Parameters.Add("p_out",OleDbType.Integer);cmdOra.Parameters["p_user_login_name"].Value=v_user_login_name;
cmdOra.Parameters["p_item"].Value=v_item;
cmdOra.Parameters["p_qty"].Value=v_qty;
cmdOra.Parameters["p_need_by_date"].Value=v_need_by_date;
cmdOra.Parameters["p_flag"].Value=v_flag;cmdOra.Parameters["p_user_login_name"].Direction=ParameterDirection.Input;
cmdOra.Parameters["p_item"].Direction=ParameterDirection.Input;
cmdOra.Parameters["p_qty"].Direction=ParameterDirection.Input;
cmdOra.Parameters["p_need_by_date"].Direction=ParameterDirection.Input;
cmdOra.Parameters["p_flag"].Direction=ParameterDirection.Input;
cmdOra.Parameters["p_out"].Direction=ParameterDirection.ReturnValue;try
{
cmdOra.ExecuteNonQuery();
i=(int)cmdOra.Parameters["p_out"].Value;
}
catch
{
i=-88;
}
finally
{
if (cmdOra.Connection.State==ConnectionState.Open)
{
cmdOra.Connection.Close();
cmdOra.Connection.Dispose();
cmdOra.Parameters.Clear();
cmdOra.Dispose();
}
}
return i;
}int i;
i=new clsPublic().Exec_UpdateOrder(clsPublic.UserName,this.txtItem.Text.Trim(),this.txtQty.Text.Trim(),this.txtNeedDate.Text.Trim(),"A","cux_franchiser.update_fran_po_interface");      <----这里是包.过程名