Calling Oracle stored procedure from C#?

Question

How does one call a stored procedure in oracle from C#?

Answer 1

Please visit this ODP site set up by oracle for Microsoft OracleClient Developers: http://www.oracle.com/technetwork/topics/dotnet/index-085703.html

Also below is a sample code that can get you started to call a stored procedure from C# to Oracle. PKG_COLLECTION.CSP_COLLECTION_HDR_SELECT is the stored procedure built on Oracle accepting parameters PUNIT, POFFICE, PRECEIPT_NBR and returning the result in T_CURSOR.

using Oracle.DataAccess; using Oracle.DataAccess.Client;  public DataTable GetHeader_BySproc(string unit, string office, string receiptno) {     using (OracleConnection cn = new OracleConnection(DatabaseHelper.GetConnectionString()))     {         OracleDataAdapter da = new OracleDataAdapter();         OracleCommand cmd = new OracleCommand();         cmd.Connection = cn;         cmd.InitialLONGFetchSize = 1000;         cmd.CommandText = DatabaseHelper.GetDBOwner() + "PKG_COLLECTION.CSP_COLLECTION_HDR_SELECT";         cmd.CommandType = CommandType.StoredProcedure;         cmd.Parameters.Add("PUNIT", OracleDbType.Char).Value = unit;         cmd.Parameters.Add("POFFICE", OracleDbType.Char).Value = office;         cmd.Parameters.Add("PRECEIPT_NBR", OracleDbType.Int32).Value = receiptno;         cmd.Parameters.Add("T_CURSOR", OracleDbType.RefCursor).Direction = ParameterDirection.Output;          da.SelectCommand = cmd;         DataTable dt = new DataTable();         da.Fill(dt);         return dt;     } }