Skip to Main Content
Forums

Oracle Developer Tools for Visual Studio

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Implicit REF CURSOR Binding with Date DataType

user489948Jul 16 2012
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!!!

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 13 2012
Added on Jul 16 2012
#11g, #oracle-developer-tools-for-visual-studio
0 comments
366 views