If you are using Oracle's OLE objects the syntax is incorrect for that.
Look in the online help.
Jim
"Alasdair Cunningham-Smith" <alasdaircs_at_metron.co.uk> wrote in message
news:971968296.9399.0.nnrp-04.d4f08801_at_news.demon.co.uk...
> I have a VB6 SP3 application which talks to Oracle (8.0.5 and 8.1.5). I
have
> both the MSDAORA and OraOLEDB.Oracle 8.1.6.2 OLEDB driver installed, and I
> can switch the code to use either.
>
> If I create an ADODB.Command with type = adStoredProcedure and CommandText
=
> 'p_MEASITEM_i' and then issue com.Parameters.Refresh, it works with
MSDAORA,
> but OraOLEDB.Oracle 8.1.6.2 fails with error 0x80040e51 - Provider cannot
> derive parameter information and SetParameterInfo has not been called.
>
> If I run the following code:
>
> Conn.OpenSchema(adSchemaProcedureParameters, Array(Empty, Empty,
> "p_MEASITEM_i", Empty))
>
> The MSDAORA driver returns a sensible rowset, but the OraOLEBD.Oracle
driver
> returns a rowset with the correct schema, but no rows.
>
> What am I doing wrong?
>
> Many thanks in advance for your time and attention,
>
> Alasdair Cunningham-Smith.
> MCSE MCSD MCDBA
>
>
>
Received on Thu Oct 19 2000 - 21:59:49 CDT
