5 Replies Latest reply: Oct 11, 2012 9:02 AM by 967262 RSS

    The provider did not return a ProviderManifest instance. Metadata is invali

    926487
      I am using VS2010 SP1
      Latest version of ODP.net downloaded for 32 bilt.


      I am getting the following error message when I try to build my project

      Error 168: The provider did not return a ProviderManifest instance. FSDEVTL.GET_SUPPLIERS.RefCursorMetaData.SUPPLIER_NAME.Column.0 Metadata is invalid

      My app.config entry looks as follows:

      *<oracle.dataaccess.client>*
      *<settings>*
      *<add name="FSDEVTL.GET_SUPPLIERS.RefCursor.SUPP_LIST" value="implicitRefCursor bindinfo='mode=Output'" />*
      *<add name="FSDEVTL.GET_SUPPLIERS.RefCursorMetaData.SUPPLIER_NAME.Column.1" value="implicitRefCursor metadata='ColumnName=SUPPLIER_NAME;BaseColumnName=SUPPLIER_NAME;BaseSchemaName=FSDEVTL;BaseTableName=A_SUPPLIER;NATIVEDATATYPE=Varchar2;ProviderType=Varchar2'" />*
      *</settings>*
      *</oracle.dataaccess.client>*

      My stoerd procedure looks as follows:

      PROCEDURE "GET_SUPPLIERS" (
      "SUPP_LIST" OUT SYS_REFCURSOR) IS
      BEGIN

           OPEN SUPP_LIST FOR
           SELECT
                SUPPLIER_NAME
           FROM
                A_SUPPLIER ;

      END;

      Please assist me.

      Thanks

      Edited by: 923484 on Mar 26, 2012 2:06 PM