Partially fix of #39855: diminfo in inserted as string in mdsys query

By inserting the diminfo string into the query instead of giving it as a param in the prepared statement, the error is fixed. Apparently the param was resolved as a string? Note that this NOT fix the dbmanager issue of #39855. But it makes it possible to drag/drop a layer from the browser again. (cherry picked from commit 31a0e72)
qgis · Jan 15, 2021 · 8ba9727 · 8ba9727
1 parent 25d8a29
commit 8ba9727
Showing 1 changed file with 2 additions and 2 deletions.
diff --git a/src/providers/oracle/qgsoracleprovider.cpp b/src/providers/oracle/qgsoracleprovider.cpp
@@ -3094,8 +3094,8 @@ QgsVectorLayerExporter::ExportError QgsOracleProvider::createEmptyLayer(
       }
     }
 
-    if ( !exec( qry, QString( "INSERT INTO mdsys.user_sdo_geom_metadata(table_name,column_name,srid,diminfo) VALUES (?,?,?,?)" ),
-                QVariantList() << tableName.toUpper() << geometryColumn.toUpper() << srid << diminfo ) )
+    if ( !exec( qry, QString( "INSERT INTO mdsys.user_sdo_geom_metadata(table_name,column_name,srid,diminfo) VALUES (?,?,?,%1)" ).arg( QString( diminfo ) ),
+                QVariantList() << tableName.toUpper() << geometryColumn.toUpper() << srid ) )
     {
       throw OracleException( tr( "Could not insert metadata." ), qry );
     }