Oleg wrote:
> Hi,
> I'm trying to use an EnterpriseLibrary 3.1 and return recordset from
> oracle database using stored procedure.
> As you may know, oracle stored procedures have out parameter of type
> cursor in order to return a dataset.
>
> It seems like I need to add a paramenter of type cursor to execute
> this stored procedure, but I can't find the type for the cursor.
>
> Does enterprise Library support this senario at all?

"Matt Noonan" wrote:

> Oleg wrote:
> > Hi,
> > I'm trying to use an EnterpriseLibrary 3.1 and return recordset from
> > oracle database using stored procedure.
> > As you may know, oracle stored procedures have out parameter of type
> > cursor in order to return a dataset.
> >
> > It seems like I need to add a paramenter of type cursor to execute
> > this stored procedure, but I can't find the type for the cursor.
> >
> > Does enterprise Library support this senario at all?
>
> Yes, it is supported, but you don't have to add it. The Data block adds the
> cursor for you when you call ExecuteDataSet. The only thing you have to do
> is declare a "cur_out" (the default name) as the first parameter in your
> stored procedure.
>
> --
> Matt Noonan
> EasyObjects.NET: The O/RM for the Enterprise Library
> http://www.easyobjects.net
>
>