Hi Rob, Thanks for the suggestion. I've already registered with USER_SDO_GEOM_METADATA to even get the table listed in the "Add table" dialog.
Selecting a geometry and/or primary key column don't work I'm afraid. I've also tried the "Select at id" checkbox on and off, but to no avail. Hence my wondering if QGIS supports views. I get this back: dbname='production.hw-uk.local' host=host port=1521 user='USER' password='PASSWORD' key='PKEY' estimatedmetadata=true srid=8307 type=POLYGON table="SZACCOUNTS"."JMO_TEMP_VIEW" (GEOMETRY) sql= is an invalid layer - not loaded Has anyone else had success pointing to Oracle Views? How about PostGIS views, do they work? Cheers, Jonathan -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Rob L Sent: Tuesday, October 14, 2014 8:25 AM To: [email protected] Subject: Re: [Qgis-user] QGIS and Oracle Views Jonathan, I think as long as the view is registered in the `USER_SDO_GEOM_METADATA` table then you should be able to add them in QGIS. Think at the "Add Oracle Table(s)" dialog you just have to select a geometry "Type" and a "Primary key column" using the drop downs. Let me know how you get on. Rob -- View this message in context: http://osgeo-org.1560.x6.nabble.com/QGIS-and-Oracle-Views-tp5166520p5167358.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user This message has been scanned for viruses by MailControl - www.mailcontrol.com Click https://www.mailcontrol.com/sr/yhxqFe!!ur!GX2PQPOmvUhStAXlT3N1zBgU!bku7KNXHzabdgX!LQrHMmaV05UyNdme+0SYzKNn1VsBVsOva5A== to report this email as spam. ________________________________ HR Wallingford and its subsidiaries uses faxes and emails for confidential and legally privileged business communications. They do not of themselves create legal commitments. Disclosure to parties other than addressees requires our specific consent. We are not liable for unauthorised disclosures nor reliance upon them. If you have received this message in error please advise us immediately and destroy all copies of it. HR Wallingford Limited Howbery Park, Wallingford, Oxfordshire, OX10 8BA, United Kingdom Registered in England No. 02562099 ________________________________ _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
