Hello, I am migrating a web2py app. to Oracle. It works fine on postgresql and sqlite, but my firm demands Oracle. There is a large field in my db ( > 4000 chars) so can not be a string. Oracle creates this a clob. Often (but not always) I get the dreaded error: 'LOB variable no longer valid after subsequent fetch'.
I have dug around and uncommented a 'FIX' in gluon/sql.py: elif fieldtype == 'text': if dbname == 'oracle': return ":CLOB('%s')" % obj.replace("'","?") ### FIX THIS I also tried : return ":CLOB('%s')" % obj.replace('\'','\'\'') both let to even more errors. Is there a fix for this ? (Python 2.6.5 on Linux, web2py Version 1.76.5) Thanks, John C.