this is ticket 435: http://www.sqlalchemy.org/trac/ticket/435
Ive added some architectural details to the ticket so that anyone can get the basic idea of whats needed, in case someone wants to contribute to this. On Jan 29, 5:15 pm, "John Lavoie" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm getting the following error when I try to pull the data from my > table. > > The table PROCESS has a bunch of columns, including one BLOB column. > > I am using SQLSoup, as I'm connecting to a database that is already > defined. > > SA is version 0.3.4, database is Oracle. > > Page handler: <bound method Root.process of > <profilemaster.controllers.Root object at 0x0162A750>> > Traceback (most recent call last): > File > "c:\python24\lib\site-packages\CherryPy-2.2.1-py2.4.egg\cherrypy\_cphttptoolspy", > line 105, in _run > self.main() > File > "c:\python24\lib\site-packages\CherryPy-2.2.1-py2.4.egg\cherrypy\_cphttptoolspy", > line 254, in main > body = page_handler(*virtual_path, **self.params) > File "<string>", line 3, in process > File > "c:\python24\lib\site-packages\TurboGears-1.0.1-py2.4.egg\turbogears\controllers.py", > line 334, in expose > output = database.run_with_transaction( > File "<string>", line 5, in run_with_transaction > File > "c:\python24\lib\site-packages\TurboGears-1.0.1-py2.4.egg\turbogears\databasepy", > line 352, in sa_rwt > retval = dispatch_exception(e,args,kw) > File > "c:\python24\lib\site-packages\TurboGears-1.0.1-py2.4.egg\turbogears\databasepy", > line 341, in sa_rwt > retval = func(*args, **kw) > File "<string>", line 5, in _expose > File > "c:\python24\lib\site-packages\TurboGears-1.0.1-py2.4.egg\turbogears\controllers.py", > line 351, in <lambda> > mapping, fragment, args, kw))) > File > "c:\python24\lib\site-packages\TurboGears-1.0.1-py2.4.egg\turbogears\controllers.py", > line 378, in _execute_func > output = errorhandling.try_call(func, *args, **kw) > File > "c:\python24\lib\site-packages\TurboGears-1.0.1-py2.4.egg\turbogears\errorhandling.py", > line 73, in try_call > return func(self, *args, **kw) > File "C:\Documents and > Settings\jlavoie\workspace\ProfileMaster\profilemaster\controllers.py", > line 21, in process > process_list = db.process.select() > File "build\bdist.win32\egg\sqlalchemy\orm\query.py", line 247, > in select > File "build\bdist.win32\egg\sqlalchemy\orm\query.py", line 252, > in select_whereclause > File "build\bdist.win32\egg\sqlalchemy\orm\query.py", line 378, > in _select_statement > File "build\bdist.win32\egg\sqlalchemy\orm\query.py", line 310, > in execute > File "build\bdist.win32\egg\sqlalchemy\orm\query.py", line 329, > in instances > File "build\bdist.win32\egg\sqlalchemy\orm\mapper.py", line > 1227, in _instance > File "build\bdist.win32\egg\sqlalchemy\orm\mapper.py", line > 1262, in populate_instance > File "build\bdist.win32\egg\sqlalchemy\orm\interfaces.py", line > 87, in execute > File "build\bdist.win32\egg\sqlalchemy\orm\strategies.py", line > 39, in process_row > File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line > 753, in __getitem__ > File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line > 647, in _get_col > File "build\bdist.win32\egg\sqlalchemy\databases\oracle.py", > line 72, in convert_result_value > ProgrammingError: LOB variable no longer valid after subsequent fetch > > 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 -~----------~----~----~----~------~----~------~--~---
