metadata from views

metadata from views

Postby tkoning » Wed 31 Mar 2010 12:29

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!
tkoning
 
Posts: 2
Joined: Wed 31 Mar 2010 10:37

Postby StanislavK » Thu 01 Apr 2010 09:36

Please try using OracleMetaDataCollectionNames.Views as the GetSchema parameter.

For all possible metadata collections, please see the OracleMetaDataCollectionNames class.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby tkoning » Thu 01 Apr 2010 10:34

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.
tkoning
 
Posts: 2
Joined: Wed 31 Mar 2010 10:37

Postby StanislavK » Thu 01 Apr 2010 14:50

We will investigate the possibility of retrieving the ViewColumns metadata collection and notify you about the results as soon as possible.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for Oracle