Re: EnterpriseLibrary. Return Recordset using oracle stored procedure



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?

I'm not sure what this question has to do with ADO. Could you clarify? What
is EnterpriseLibrary?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.



Relevant Pages

  • Re: EnterpriseLibrary. Return Recordset from oracle stored procedure
    ... oracle stored procedures have out parameter of type ... 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? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: EnterpriseLibrary. Return Recordset using oracle stored procedure
    ... oracle stored procedures have out parameter of type ... this stored procedure, but I can't find the type for the cursor. ... Does enterprise Library support this senario at all? ... but this is a classic ADO newsgroup. ...
    (microsoft.public.data.ado)
  • Re: EXEC syntax for SP which returns row set
    ... you'd call a stored procedure and return data using an OUT parameter. ... I admit that I am new to Oracle stored procedures, ... > I was testing the SP in SQL*Plus not PL/SQL. ... > java program ...
    (comp.databases.oracle.server)
  • Re: Discover parameters using DAAB
    ... The configuration tool of Enterprise ... "Ravi Ambros Wallau" wrote: ... could discover a stored procedure parameters set without calling it. ...
    (microsoft.public.dotnet.framework.adonet)
  • out putting the Job to a text file.
    ... I scheduled a JOb (Stored Procedure) in the Enterprise ... Manager / Management/ sqlserver agent/ Jobs .. ...
    (microsoft.public.sqlserver.programming)