Which python version? I vaguely remember this had been addressed and the problem has gone away.
Massimo On Aug 28, 2:40 pm, DJ <sebastianjaya...@gmail.com> wrote: > Hi, > > I get this error while retrieving CLOB data types from Oracle. This is > also seen with the Web2Py admin interface when it tries to display all > data rows. I am using the cx_oracle python database module. > > From their website,http://cx-oracle.sourceforge.net/html/lob.html > Note: Internally, Oracle uses LOB locators which are allocated based > on the cursor array size. Thus, it is important that the data in the > LOB object be manipulated before another internal fetch takes place. > The safest way to do this is to use the cursor as an iterator. In > particular, do not use the fetchall() method. The exception “LOB > variable no longer valid after subsequent fetch” will be raised if an > attempt to access a LOB variable after a subsequent fetch is detected. > > It appears that Web2py DAL is using the fetchall method to retrieve > the data. Kindly advise if you have any suggestions/ideas to fix this. > > Thanks, > Sebastian --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
