none
odp.net, clob data type and oracle 10g RRS feed

  • Question

  • Hi

    I have the following problem. If I create a table in Oracle 10g (the same with Oracle 8i) with a CLOB field (or BLOB),
    the code:

     

    Code Snippet

    DataTable dt = OleDbConnection.ExecuteReader(CommandBehavior.SchemaOnly);

     

     

     

    throws an exception; data type is not supported.

     

    What can I do, since I also must get the metadata from a database.
    I also do not understand why oracle has a separate library odp.net, that does not support oledbconnection with its GetOleDbSchema method.

     

    Regards,
    Sebastijan P.

     

    Tuesday, March 4, 2008 9:31 PM

Answers

  • Some confusion here Oracle did not implement OLE DB that is second default Microsoft implementation and in .NET there is no way to use both Oracle 8i and 10 with the same code.  So if you need to use Blob make sure you install Oracle 9i client in your Oracle 8i and install 10g client in your Oracle 10g and use ODP.NET.  The reason it comes with a location based method that let you use up to 2gig BLOB file.  Check the link below for details.

     

    http://www.oracle.com/technology/oramag/oracle/05-nov/o65odpnet.html

     

    Tuesday, March 4, 2008 10:50 PM