OracleConnection oraConnect = new OracleConnection(connectionString);

            if (oraConnect.State != ConnectionState.Open)
            {
                try
                {
                    oraConnect.Open();
                }
                catch (OracleException ex)
                {
                    throw new Exception("Ошибка подключения к БД\n" + ex.Message);
                }
            }


            DataSet dataSet = new DataSet();
            OracleParameter param;
            OracleCommand sqlCommand = oraConnect.CreateCommand();
            sqlCommand.CommandType = CommandType.StoredProcedure;
            sqlCommand.CommandText = sSPName;            

            sqlCommand.Parameters.Clear();          

            param = new OracleParameter("p_xttk_id", OracleDbType.Int32);
            param.Direction = ParameterDirection.Input;
            param.Value = 4;
            sqlCommand.Parameters.Add(param);

            param = new OracleParameter("p_recordset", OracleDbType.RefCursor);
            param.Direction = ParameterDirection.Output;
            sqlCommand.Parameters.Add(param);

            param = new OracleParameter("v_retcode", OracleDbType.Int32);
            param.Direction = ParameterDirection.ReturnValue;
            sqlCommand.Parameters.Add(param);

            sqlCommand.Prepare();

            OracleDataAdapter sqlAdapter = new OracleDataAdapter(sqlCommand);
            
            //дергаем
            try
            {
                sqlAdapter.Fill(dataSet);
            }
            catch (OracleException Ex)
            {
                throw new Exception(Ex.Message);
            }
            finally
            {
                oraConnect.Close();
            }

            oraConnect.Dispose();
            return dataSet;