Multiple ref cursors in DAAB

Topics: Building and extending application blocks, Data Access Application Block
May 24, 2009 at 3:40 PM

Hi. i am planning to use DAAB for all my future projects.It works perfectly with SQL.But i face problem in returning multiple ref cursors from Oracle.

Also, i want to use Oracle.dataaccess.client instead of System.data.oracle dll.I want to know how to do that

Thanks

 

May 25, 2009 at 5:40 AM

Hi,

What specific problem you've encountered with the ref cursors? I never have really tried using the Oracle.DataAccess.Client, I remembered what I used is the Sybase which has another provider, and in order for me to use the provider I followed the steps http://oakleafblog.blogspot.com/2007/03/orcas-march-ctp-on-vista-database.html . I haven't still have a look on the provider you are saying, I'l find a download and give it a try.

Valiant Dudan
Global Technology and Solutions
Avanade, Inc.
entlib.support@avanade.com

May 25, 2009 at 5:57 AM

Hi,

I want to return multiple ref cursors from my store procedures but there is not any dbtype available for ref cursors in Enterprise library.

As for my second query, Enterprise library internally use System.Data.OracleClient to log into Oracle database but instead of using that i want to use Oracle.DataAccess.Client becuase it provide some additional dbtypes and bulk operations.

Thanks,

Himanshu

May 25, 2009 at 7:13 AM

Hi,

Regarding the multiple ref cursor please see this link : http://entlib.codeplex.com/Thread/View.aspx?ThreadId=49907 .

For your second question, I downloaded the Oracle 11g ODAC 11.1.0.6.21 with Oracle Developer Tools for Visual Studio which is available from this link: http://www.oracle.com/technology/software/tech/windows/odpnet/index.html , after installing it. I noticed that in the connection string in the ent lib editor, there is a added provider which is the Oracle.DataAccess.Client . From this point I think this can be used as a usual provider in the Daab.

Valiant Dudan
Global Technology and Solutions
Avanade, Inc.
entlib.support@avanade.com