C# 调用存储过程

Posted on 2014-03-06 11:40  哥德巴赫猜  阅读(168)  评论(0)    收藏  举报

 //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;
            //}

博客园  ©  2004-2025
浙公网安备 33010602011771号 浙ICP备2021040463号-3