hello On Sep 8, 5:11 pm, John Lavoie <[EMAIL PROTECTED]> wrote: > Hi all, > > I'm using SQLAlchemy in Pylons. I'm also using Elixir, which was set > up based on Jonathan's post here:http://cleverdevil.org/computing/68/ > > I need to call a stored procedure. I don't care about return values > yet, I just want to run something in the database. > > So far I've just been struggling to execute any raw SQL at all, let > alone my PL/SQL procedure. > > model.Session.execute("select * from dual")
You should try model.session.execute() (with small s character) because you deal with a session object, not with a Session class. > > Results in this traceback: > Traceback (most recent call last): > File "<console>", line 1, in <module> > File "c:\python25\lib\site-packages\sqlalchemy-0.5.0beta3-py2.5.egg > \sqlalchemy\orm\scoping.py", line 106, in do > return getattr(self.registry(), name)(*args, **kwargs) > File "c:\python25\lib\site-packages\sqlalchemy-0.5.0beta3-py2.5.egg > \sqlalchemy\orm\session.py", line 742, in execute > engine = self.get_bind(mapper, clause=clause, _state=_state) > File "c:\python25\lib\site-packages\sqlalchemy-0.5.0beta3-py2.5.egg > \sqlalchemy\orm\session.py", line 907, in get_bind > ', '.join(context))) > UnboundExecutionError: Could not locate a bind configured on SQL > expression or this Session > > I am using Pylons 0.9.7-rc1, SQLAlchemy 0.5.0beta3, Elixir 0.6.1, and > cx_oracle 4.3.1 > > Can anyone suggest what might be configured wrong? > > Thanks, > John Lavoie --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
