Bug report #21677

Issue loading Oracle layers

Added by dany Lefeuvre 9 months ago. Updated 9 months ago.

Category:Data Provider/Oracle
Affected QGIS version:3.4.6 Regression?:Yes
Operating System:Windows 7 Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:29493


QGIS can add oracle layer.
In first time layer has visible, in second time (zoom - for example) the layer is invisible. Attributs tables has no rows. and Ihave an Oracle message error :

2019-03-26T14:09:19 WARNING La recherche du champ Oracle SRID 2154 a échoué.
SQL : SELECT coalesce(auth_name,'EPSG'),auth_srid,wktext FROM mdsys.cs_srs WHERE srid=:a
Erreur : ORA-03127: pas de nouvelle opération autorisée avant la fin de l'opération non bloquante active
Impossible d'exécuter cette déclaration

Before I have no problem. The problem was the same on QGIS LTR and QGIS testing. (3.4.6,3.6.1)


#1 Updated by Giovanni Manghi 9 months ago

Before I have no problem.

means in an older qgis release?

#2 Updated by Giovanni Manghi 9 months ago

  • Status changed from Open to Feedback

#3 Updated by dany Lefeuvre 9 months ago

  • Assignee changed from Jürgen Fischer to Giovanni Manghi

2.18 it was good
At the beginning of the 3.4 it was good

#4 Updated by Giovanni Manghi 9 months ago

  • Assignee deleted (Giovanni Manghi)
  • Status changed from Feedback to Open
  • Subject changed from QGIS / Oracle to Issue loading Oracle layers

Also available in: Atom PDF