title: How to call stored procedure using sqlalchemy
body: <p>How can I call stored procedures of MySQL with sqlAlchemy?</p>
  
  <p>I tried the following code:</p>
  
  <pre><code>import webapp2
  
  from sqlalchemy import *
  from sqlalchemy.ext.automap import automap_base
  from sqlalchemy.orm import create_session
  from sqlalchemy import create_engine
  
  class TestSQL(webapp2.RequestHandler):
  
  def get(self):
      Base = automap_base()
  
      engine = create_engine(('mysql://root@127.0.0.1:3306/testDB?unix_socket=/cloudsql/School=:mysqlserver'))
      # reflect the tables
      Base.prepare(engine, reflect=True)
  
      metadata = MetaData(bind=engine)
      users = Table('Student', metadata, autoload=True)
      student = metadata.tables ["Student"]
  
      session = create_session()
  
      pro = session.execute("p_get_teacher_requests", (1,0))
      self.response.write(pro)
  </code></pre>
  
  <p>Here the error that I got:</p>
  
  <pre><code>UnboundExecutionError: Could not locate a bind configured on SQL expression or this Session
  </code></pre>