ADO and Oracle Stored Procs

[MRH]

I'm having trouble with ADO Command Object programming to access an Oracle
8
table using stored procedures both with and without parameters. I'm using

Nick Snowdon's text "Oracle Programming With Visual Basic".

When following the example I get unspecified errors or an error stating that
I am
using the wrong number or type of parameter arguments, even though I only

have one parameter and only one type.

After all that, Snowdon then states that some ADO drawbacks are:
1. Not being able to use PL/SQL cursor variables (which are required with
stored
procedures, 2. ADO doesn't do bind parameters 3. ADO doesn't work with
procedure
packages, all of which he uses in the text. ??

Anyone else had ADO problems along this line?

Thanks.

[MRH]

Got a tip from Dov Trietsch ("VB 6 Oracle 8") - upgrade to ADO 2.5 which is
now available on microsoft.com. This corrected the problem.

MRH


"MRH" <mrhagerty@west.raytheon.com> wrote:
>
>I'm having trouble with ADO Command Object programming to access an Oracle
>8
>table using stored procedures both with and without parameters. I'm using
>
>Nick Snowdon's text "Oracle Programming With Visual Basic".
>
>When following the example I get unspecified errors or an error stating
that
>I am
>using the wrong number or type of parameter arguments, even though I only
>
>have one parameter and only one type.
>
>After all that, Snowdon then states that some ADO drawbacks are:
>1. Not being able to use PL/SQL cursor variables (which are required with
>stored
>procedures, 2. ADO doesn't do bind parameters 3. ADO doesn't work with
>procedure
>packages, all of which he uses in the text. ??
>
>Anyone else had ADO problems along this line?
>
>Thanks.
>
>

[Phil Weber]

MRH: I'm glad you found the answer to your question. In the future, you're
more likely to get help with ADO questions if you post them to the
vb.database.ado newsgroup. Thanks!
---
Phil Weber
DevX Newsgroup Admin

[MRH]

Thanks, I'll make a note.

MRH

"Phil Weber" <pweber@teleport.com> wrote:
>MRH: I'm glad you found the answer to your question. In the future, you're
>more likely to get help with ADO questions if you post them to the
>vb.database.ado newsgroup. Thanks!
>---
>Phil Weber
>DevX Newsgroup Admin
>
>