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?

Oh! it's a .Net thing.

There was no way for you to know it (except maybe by browsing through some
of the previous questions in this newsgroup before posting yours - always a
recommended practice) , but this is a classic ADO newsgroup. ADO.Net bears
very little resemblance to classic ADO so, while you may be lucky enough to
find a dotnet-knowledgeable person here who can answer your question, you
can eliminate the luck factor by posting your question to a group where
those dotnet-knowledgeable people hang out. I suggest
microsoft.public.dotnet.framework.adonet.

--
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 using 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.data.ado)
  • 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: 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: Null values for parameters in Preview Data dialogue?
    ... but this is a classic ADO newsgroup. ... parameterised stored procedure. ... The problem I have is that the Preview Data dialogue demands that I ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: How do I link the results from sp_executeSQL to a gridview?
    ... I built a stored procedure that needed to use dynamic sql for a search ... but this is a classic ADO newsgroup. ... gridview and simply call the Fillmethod but the ...
    (microsoft.public.data.ado)