This discussion is archived
0 Replies Latest reply: Jul 16, 2012 9:16 AM by user489948 RSS

Implicit REF CURSOR Binding with Date DataType

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

Legend

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