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
-~----------~----~----~----~------~----~------~--~---
