0 Replies Latest reply: Jul 16, 2012 11:16 AM by user489948 RSS

    Implicit REF CURSOR Binding with Date DataType

    user489948
      Hello everyone,

      Oracle 11gR2
      Oracle Client 11.2.0.3
      Visual Studio 2010 C#
      Entity Framework 4

      I am trying to bind the ref cursor returned from Oracle Stored Procedure. The ref cursor has a datetype column. I added following lines in App.Config file:

      <add name="OWNER.PCK_NAME.SP_NAME.RefCursorMetaData.REF_CURS.Column.5" value="implicitRefCursor metadata='ColumnName=ASSIGNED_DATE;
      AllowDBNull=true;
      NATIVEDATATYPE=Date;
      ProviderType=DateTime'" />

      And I got following error message:
      Error 168: The provider did not return a ProviderManifest instance. Package.Procedure.Column.5 ProviderType=DateTime is invalid

      Could anybody please let me know which PrividerType I should give here?
      Thanks in advance!!!