Thanks, but when I try that I get:
>>> s = sqlalchemy.sql.text("DECLARE RetVal VARCHAR2(200); p1 VARCHAR2(200);
>>> p2 NUMBER; BEGIN p1 := '1'; P2 := 2; RetVal := myfunc ( p1, p2 ); END;
>>> ")
>>> print conn.execute(s).fetchall()
Traceback (most recent call last):
File "<interactive input>", line 1, in <module>
File "C:\Python25\lib\site-packages\sqlalchemy-0.5.6-py2.5.egg
\sqlalchemy\engine\base.py", line 1642, in fetchall
self.connection._handle_dbapi_exception(e, None, None,
self.cursor, self.context)
File "C:\Python25\lib\site-packages\sqlalchemy-0.5.6-py2.5.egg
\sqlalchemy\engine\base.py", line 931, in _handle_dbapi_exception
raise exc.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
InterfaceError: (InterfaceError) not open None None
My obtuseness makes it hard to see the connection between executing
the statement and retrieving the results.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
