Skip to content

Improve handling of LOBs in result view (Oracle) #8

Description

@andialbrecht

When a query results contains LOBs and the number of results exceeds the visible area (so that the result view has scrollbars) an error is logged on console:

Traceback (most recent call last):
  File "/home/andi/devel/runsqlrun/rsr/worksheet/results.py", line 331, in do_get_value
    data = str(value)
cx_Oracle.ProgrammingError: LOB variable no longer valid after subsequent fetch

LOBs shouldn't be accessed directly when displayed in result list. Instead a simplified text version should be used.

In addition: resizing a column containing LOBs is verrry slow.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions