Calling Stored Procedure of Oracle in Asp.Net

Add Reference
System.Data.OracleClient;

After That Add the Following Code.

public void AddEmployee(int EmpId,string EmpName)
{
string strConn = "Data Source=Data Source;User ID=system;Password=pwd;";
OracleConnection con = new OracleConnection();
con.ConnectionString = strConn;
con.Open();
OracleCommand cmd = new OracleCommand();
//CommandText=Procedure Name.
cmd.CommandText = "InsertData";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
//ID is the name of Parameter in SP.
cmd.Parameters.Add("ID", OracleType.Number).Value = EmpId;
//NAME is the name of parameter in SP
cmd.Parameters.Add("NAME", OracleType.VarChar).Value = EmpName;
try
{
cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
throw ex;
}
}


Enjoy....