Massimo, I am using -
Python 2.5.2 DB Driver: cx_Oracle-5.0.1-10g.win32-py2.5 Oracle 10G Platform: Windows 2003 Server -Sebastian On Aug 29, 4:22 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
