Re: Accessing an Oracle view from ADO

Hi,

I just wanted to add a few more details. After posting the first message I found that the Stored Procedure works fine when the OLEDB provider is MSDAORA but fails with OraOLEDB.

I am using Oracle 8.1.7 and ADO 2.1 with OraOLEDB Is there some kind of parameter that I need to specify in the connect string (like PLSQLRSET=1 for returning a recordset)

• Hareesh

Hareesh.Gunti_at_Rapistan.com (Hareesh) wrote in message news:<e568234.0106290627.3be89dec_at_posting.google.com>...
> Hi,
>
> I have a view and a stored procedure that uses this view.
> If I call the Stored procedure from SQL*PLUS or TOAD
> I get the number of records correctly.
> But if I call the same Stored Procedure from VB using ADO
> the number of records in the View are always 0(zero)
>
> I find this strange.
> Help is very much appreciated.
>
> -- Hareesh
Received on Fri Jun 29 2001 - 19:06:44 CEST