|
 |
aspx thread: Execute A Oracle Stored Procedure which returns a recordset
Message #1 by "mohit navare" <mohitn@p...> on Wed, 18 Jul 2001 12:51:19
|
|
hi,
I want to execute a stored procedure in oracle which returns a Recordset.
The signature of the stored procedure contains the ref cursor as an out
parameter .
How do i call the OleDBCommand objects execute method.
It gives me an error saying unknown error.
I assing the command object all the parameters expected by the stored
procedure in the same order as expected.
I passed the ref cursor parameter as a varialbe of type object
whent the command:
oledbDataReader=oledbcommand.executeReader() is executed it throws an
error.
Please help me out if anyone know the answer.
Thanks And Regards
Mohit Navare
Message #2 by "Roy Ogborn" <rogborn@q...> on Fri, 20 Jul 2001 06:05:17
|
|
I've not tried this using ADO.NET yet (but will be soon). I could not
retrieve a recordset using ADO from an Oracle stored procedure in a VB6
application. I believe that the Microsoft Oracle OLEDB provider does not
support the returning of a recordset (odly enough). But it has been
documented at the Oracle web site that the OleDB provider for Oracle from
Oracle Corporation will return a recordset. In fact, the lastest OleDB
provider from Oracle will return multiple recordsets from a single stored
procedure. You can get the Oracle OleDB provider for ADO from the Oracle
web site (free download). However, know that once that provider has been
installed on your machine, the original Microsoft Oracle OleDB provider
will no longer work.
Please e-mail me back if you solve your problem by useing Oracle's OleDB
provider for Oracle instead of Microsoft's.
Roy
rogborn@q...
> hi,
> I want to execute a stored procedure in oracle which returns a
Recordset.
> The signature of the stored procedure contains the ref cursor as an out
> parameter .
>
> How do i call the OleDBCommand objects execute method.
> It gives me an error saying unknown error.
>
> I assing the command object all the parameters expected by the stored
> procedure in the same order as expected.
>
> I passed the ref cursor parameter as a varialbe of type object
>
> whent the command:
> oledbDataReader=oledbcommand.executeReader() is executed it throws an
> error.
>
> Please help me out if anyone know the answer.
>
> Thanks And Regards
>
> Mohit Navare
Message #3 by "Roger M. Taylor" <rogertaylor@f...> on Fri, 20 Jul 2001 07:35:03 -0400
|
|
The folks at:
http://www.asplists.com/asplists/asporacle.asp
will help you with retrieving the recordset from Oracle w/VB6 and ASP.
A bunch of articles @
http://www.learnasp.com/learn/oracle.asp
deal with that as well.
At 06:05 AM 7/20/2001 +0000, you wrote:
>I've not tried this using ADO.NET yet (but will be soon). I could not
>retrieve a recordset using ADO from an Oracle stored procedure in a VB6
>application. I believe that the Microsoft Oracle OLEDB provider does not
>support the returning of a recordset (odly enough). But it has been
>documented at the Oracle web site that the OleDB provider for Oracle from
>Oracle Corporation will return a recordset. In fact, the lastest OleDB
>provider from Oracle will return multiple recordsets from a single stored
>procedure. You can get the Oracle OleDB provider for ADO from the Oracle
>web site (free download). However, know that once that provider has been
>installed on your machine, the original Microsoft Oracle OleDB provider
>will no longer work.
>
>Please e-mail me back if you solve your problem by useing Oracle's OleDB
>provider for Oracle instead of Microsoft's.
>
>Roy
>rogborn@q...
>
> > hi,
> > I want to execute a stored procedure in oracle which returns a
>Recordset.
> > The signature of the stored procedure contains the ref cursor as an out
> > parameter .
> >
> > How do i call the OleDBCommand objects execute method.
> > It gives me an error saying unknown error.
> >
> > I assing the command object all the parameters expected by the stored
> > procedure in the same order as expected.
> >
> > I passed the ref cursor parameter as a varialbe of type object
> >
> > whent the command:
> > oledbDataReader=3Doledbcommand.executeReader() is executed it throws an
> > error.
> >
> > Please help me out if anyone know the answer.
> >
> > Thanks And Regards
> >
> > Mohit Navare
>
|
|
|
View Cart
