Devart Forums

Hello,
I'm currently trying to get the metadata from a View from an Oracle 10g database.
However, the GetSchema method does not support reference data of views.
Is there a way to find this data with DotConnect without having the owner rights?

Thanks in advance!

Please try using OracleMetaDataCollectionNames.Views as the GetSchema parameter.

For all possible metadata collections, please see the OracleMetaDataCollectionNames class.

I have tried this, and am still using it. But this does not return all the data i want to have.
When using the Views parameter in GetSchema(), it returns the name, query and schemaname of the view, but it does not return the columnnames and their parenttable names.

We will investigate the possibility of retrieving the ViewColumns metadata collection and notify you about the results as soon as possible.