This discussion is archived
5 Replies Latest reply: Oct 11, 2012 7:02 AM by 967262 RSS

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

926487 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points