C# 调用存储过程

Posted on 2014-03-06 11:40  哥德巴赫猜  阅读(162)  评论(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;
            //}

Copyright © 2024 哥德巴赫猜
Powered by .NET 8.0 on Kubernetes