try db.commit() after the first fetch.
On 16 Lug, 15:07, DJ <[email protected]> wrote:
> Hi there,
>
> I get these errors when I run a search query (retrieve multiple rows),
> but not when I do a single row retrieval (such as viewing a record).
> Any suggestions or methods to get around this?
>
> -Sebastian
>
> Traceback (most recent call last):
> File "C:\Documents and Settings\sjayaraj\Desktop\web2py_src\web2py
> \gluon\restricted.py", line 98, in restricted
> exec ccode in environment
> File "C:\Documents and Settings\sjayaraj\Desktop\web2py_src\web2py
> \applications\myapp/views/viewer/search.html", line 67, in <module>
> File "C:\Documents and Settings\sjayaraj\Desktop\web2py_src\web2py
> \gluon\globals.py", line 84, in write
> self.body.write(xmlescape(data))
> File "C:\Documents and Settings\sjayaraj\Desktop\web2py_src\web2py
> \gluon\html.py", line 97, in xmlescape
> data = str(data)
> ProgrammingError: LOB variable no longer valid after subsequent fetch
>
> Version: 1.65.5
> CX_Oracle docs for LOB:http://cx-oracle.sourceforge.net/html/lob.html
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" 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
-~----------~----~----~----~------~----~------~--~---
