ProgrammingError: LOB variable no longer valid after subsequent fetch

Question

Error when selecting a column ps_retourintervention

This error shows when I'm trying to select the column ps_retourintervention and put it in a pandas dataframe .

This code works when selecting other columns from the same table in the database.

This query works also when I execute it in SQL developer here is it's result.

Answer 1

This is a limitation of versions of cx_Oracle 5 and earlier. The new version (cx_Oracle 6) doesn't have this limitation. You can upgrade using this command:

python -m pip install cx_Oracle --upgrade