Hi, I have the spatial metadata in the both MDSYS.ALL_SDO_GEOM_METADATA and USER_SDO_GEOM_METADATA views. The SRID is well retrieved by Qgis in the add Oracle layer menu. But when I add the layer to the project QGIS tells me that the CRS is not defined (and it takes the default one).
The other problem is on the primary key that is not retrieved in the add Oracle layer menu at all. I saw in your link that there are 2 functions about primary key : determinePrimaryKey() and determineAlwaysGeneratedKeys(). I don't really understand what means AlwaysGeneratedKeys but what I'm sure about is that the request made in the function works if I run it in SQL Developer (I get the column name of the primary key for the table 'X') whereas the request in determinePrimaryKey can't as the table/view all_tab_identity_cols doesn't exists in my database ! Jérémie. Le mar. 18 févr. 2020 à 16:45, SPeillet <[email protected]> a écrit : > Hello, > > I add my few knowledge about the srid definition. Currently oracle provider > only check srid in the MDSYS.ALL_SDO_GEOM_METADATA view and not the > MDSYS.USER_SDO_GEOM_METADATA. > > cf. > > https://github.com/qgis/QGIS/blob/master/src/providers/oracle/qgsoracleprovider.cpp#L2635 > > I made some changes about this on my side to check it on both views, I will > do a PR soon. > > > > -- > Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html > _______________________________________________ > Qgis-user mailing list > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
