C# 调用存储过程

 //try
            //{
            //    string proName = "uSP_Sample_GetSampleInfo";
            //    OracleParameter[] parameter = {
            //                             new OracleParameter("p_starter",OracleType.VarChar),
            //                             new OracleParameter("p_ShowColumnDescrption",OracleType.Int32),
            //                             new OracleParameter("p_SampleCursor",OracleType.Cursor)
            //                             };
            //    parameter[0].Value = userName;
            //    parameter[1].Value = 0;
            //    parameter[2].Direction = ParameterDirection.Output;
            //    return OracleHelper.QueryByProc(proName, parameter);
            //}
            //catch (Exception ex)
            //{
            //    LogHelper.Error("error in  GetSampInfo" + ex.ToString());
            //    return null;
            //}

原文地址:https://www.cnblogs.com/wenbing/p/3584149.html