ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting oracle metadata - (OleDbConnection-GetOleDbSchemaTable)

626597Mar 4 2008 — edited Mar 5 2008

Hi

Microsoft has a library System.Data.OracleClient.
Since System.Data.OracleClient does not support CLOB, BLOB and XmlType data types; means it has limited functionality, we are trying to use odp.net.

Problem:
Microsoft also has a library System.Data.OleDb where you can find an object OleDbConnection.
That object has a method GetOleDbSchemaTable, where you can provide different parameters to get different oracle metadata.
Example parameters:
OleDbSchemaGuid.Foreign_Keys, OleDbSchemaGuid.Primary_Keys, OleDbSchemaGuid.Tables,...

My question is what the oracles odp.net substitution for this is (which method)? How to do that with odp.net?
Or does this library also have a limited set of objects to use?

Regards,
Sebastijan

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 2 2008

Added on Mar 4 2008

#odp-net

2 comments

2,220 views