Using Oracle-OLEDB-provider to query meta-data

I am using OLEDB to query meta-data from a database, using MSsqlServer i am successful !
When trying the code on the latest
OLEDB-Provider from Oracle i am run into strange problems.

i found that Orcacle does not support catalogs and schema's.

When filling the restrictions with null (cat-name), userid(schemaname), null [Quoted] (tablename) this gives back a not-supported ! while doing a unrestricted-query gives me the results i want.

BUT, an unrestricted query on an LARGE-database is veryvery timeconsuming

Now i have started to query the vieuws like all_objects etc to get me what i [Quoted] want :: ie coding db-dependant

Does anyone know a solution for me to use OLEDB ?

Tnx
Arjan van Muyen Received on Wed Nov 17 1999 - 17:53:47 CET