I've been using an Oracle database and reflection (i.e., autoload=True). I recently added a BLOB column to the database. I never did any modification to the Python application code yet. The application was made using Turbogears and it just serves two forms, one for inserting records and one for updating . I am still able to update records, but when I do an insert I get the error below. I tried the latest oracle.py (r2303) and get the same thing (I couldn't do an svn checkout of everything because of our companies firewall).
Page handler: <bound method Root.insertrequest of <srt.controllers.Root object at 0x0180EDB0>> Traceback (most recent call last): File "c:\python24\lib\site-packages\CherryPy-2.2.1-py2.4.egg\cherrypy \_cphttptools.py", line 105, in _run self.main() File "c:\python24\lib\site-packages\CherryPy-2.2.1-py2.4.egg\cherrypy \_cphttptools.py", line 254, in main body = page_handler(*virtual_path, **self.params) File "<string>", line 3, in insertrequest 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\database.py", line 347, in sa_rwt retval = dispatch_exception(e,args,kw) File "c:\python24\lib\site-packages\turbogears-1.0.1-py2.4.egg \turbogears\database.py", line 345, in sa_rwt transaction.commit() File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\orm\session.py", line 54, in commit self.session.flush() File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\orm\session.py", line 220, in flush self.uow.flush(self, objects) File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\orm\unitofwork.py", line 194, in flush flush_context.execute() File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\orm\unitofwork.py", line 333, in execute head.execute(self) File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\orm\unitofwork.py", line 470, in execute UOWExecutor().execute(trans, self) File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\orm\unitofwork.py", line 793, in execute self.execute_save_steps(trans, task) File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\orm\unitofwork.py", line 815, in execute_save_steps self.execute_childtasks(trans, task, False) File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\orm\unitofwork.py", line 841, in execute_childtasks self.execute(trans, child, isdelete) File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\orm\unitofwork.py", line 793, in execute self.execute_save_steps(trans, task) File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\orm\unitofwork.py", line 810, in execute_save_steps self.save_objects(trans, task) File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\orm\unitofwork.py", line 798, in save_objects task._save_objects(trans) File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\orm\unitofwork.py", line 461, in _save_objects self.mapper.save_obj(self.polymorphic_tosave_objects, trans) File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\orm\mapper.py", line 998, in save_obj c = connection.execute(statement, params) File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\engine\base.py", line 258, in execute return Connection.executors[type(object).__mro__[-2]](self, object, *multiparams, **params) File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\engine\base.py", line 282, in execute_clauseelement return self.execute_compiled(elem.compile(engine=self.__engine, parameters=param), *multiparams, **params) File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\engine\base.py", line 297, in execute_compiled context.pre_exec(self.__engine, proxy, compiled, parameters) File "C:\Python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\databases\oracle.py", line 152, in pre_exec super(OracleExecutionContext, self).pre_exec(engine, proxy, compiled, parameters) File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\engine\default.py", line 128, in pre_exec self._process_defaults(engine, proxy, compiled, parameters) File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\engine\default.py", line 204, in _process_defaults elif not param.has_key(c.key) or param[c.key] is None: File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\sql.py", line 321, in __getitem__ v = self.binds[key].typeprocess(v, self.dialect) File "c:\python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\sql.py", line 836, in typeprocess return self.type.dialect_impl(dialect).convert_bind_param(value, dialect) File "C:\Python24\lib\site-packages\sqlalchemy-0.3.4-py2.4.egg \sqlalchemy\databases\oracle.py", line 67, in convert_bind_param return ''.join(["%.2X" % ord(c) for c in value]) TypeError: iteration over non-sequence --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---