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.

Reply via email to