call_stored_routine.rb

def forecast
  x = params[:revplan_id].to_i
  @revplan = Revplan.find(x)
  sql = ActiveRecord::Base.connection();
  sql.execute "SET autocommit=0";
  sql.begin_db_transaction
  execution_string="call sp_generate_forecast(#{Time.now.month}, #{Time.now.year}, _
           #{x}, #{month_days(Time.now.month)})"
  result = sql.execute(execution_string)
  sql.commit_db_transaction
end