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")

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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to