I can confirm that I can access Oracle Views in my system using the steps as described by Richard.
Rob -----Original Message----- From: Richard Duivenvoorde [mailto:[email protected]] Sent: 16 October 2014 11:23 To: Jonathan Moules; Langford, Robert; '[email protected]' Subject: Re: [Qgis-user] QGIS and Oracle Views On 16-10-14 11:29, Jonathan Moules wrote: > Has anyone else had success pointing to Oracle Views? How about PostGIS > views, do they work? hi Jonathan, tried it here. I'm able to see an Oracle View, but only after: - create a simple (point view) via 'create view as select * from ....) at that time the view is not visible in QGIS, so - added the view to the spatial metadata table now I could see it, but it was still show as 'grey' text lines and not addable - then in the QGIS-add oracle dialog, there is a column 'Primary key column' in which you can select a column as primary column (probably this should be an unique one...). After doing that: - NOW the layer is black, and I'm able to add it to QGIS If you did the same steps, maybe your primary key column is not unique? Or have some invalid data? Maybe first try this with some simple test data? Regards, Richard Duivenvoorde DISCLAIMER: The information contained in this communication/message from [email protected] sent on Thu Oct 16 12:20:26 2014 is confidential. It is intended solely for the addressee(s) [email protected];[email protected];[email protected] Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. As a public body, Salford City Council may be required to disclose this email [or any response to it] under the Freedom of Information Act 2000, unless the information in it is covered by one of the exemptions in the Act. Please immediately contact the sender, [email protected] if you have received this message in error. For the full disclaimer please access http://www.salford.gov.uk/e-mail. Thank you. _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
