Can I see the model that creates the problem and the action that
causes the error?
On May 25, 5:59 am, JC11 <john.c...@gmail.com> wrote:
> 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.
