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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
