代码如下：

            try
            {
                //1.1 执行存储过程
                List<OracleParameter> list = new List<OracleParameter>();
                list.Add(new OracleParameter() { ParameterName = "VAR_OP_XXXX_", Direction = ParameterDirection.Input, Value = dept_code, OracleDbType = OracleDbType.Varchar2 });
                list.Add(new OracleParameter() { ParameterName = "VAR_OP_XXXX_", Direction = ParameterDirection.Input, Value = user_code, OracleDbType = OracleDbType.Varchar2 });
                list.Add(new OracleParameter() { ParameterName = "RETURNData_", Direction = ParameterDirection.Output, OracleDbType = OracleDbType.Varchar2,Size=50 });

                OracleHelper.ExecuteNonQuery("USP_WAITING_XXXX", list.ToArray());

                object t = list.Where(x => x.ParameterName == "RETURNData_").FirstOrDefault().Value;
                string queryValue = (((OracleString)t).Value).ToString();  }
            catch (Exception ex)
            {
                LogHelper.Error("SetTaskWaitingByUserDAL执行异常" + ex.ToString());
                return -1;
            }