Re: VB6 SP3 / ADO2.1 /Ora 8 - "Error - Memory could not be written"

Jason,

Are you using the ODBC OLEDB provider or the Oracle OLEDB provider?

We are using the Oracle provider and not having any problems with using SP in packages to do our inserts, etc.

Env:
VB6SP3
Oracle8.0.5 on HPUX
ADO 2.10.3711.9 - Could be issue here
SQL Net 2.3

Mike

jason wrote in message <7op0t2$88b$1_at_trinitech.demon.co.uk>...
>I'm trying to insert records (using VB6 SP3 and ADO 2.10.4202.1) via a
>Stored Function into an Oracle 8.0.4 DB. The Fn is supposed to inserts a
new
>record and passes back the new Oracle - generated PK. If I try passing more
>than 5 parameters to the Fn - VB blows with - "at 0xXXXXXXXX referenced
>memory at 0xXXXXXXXX. The
>memory could not be written. " This is followed by the error - "at
>0xXXXXXXXX referenced memory at 0xXXXXXXXX. The memory could not be read.
"
>Which kills my App and VB.
>The action runs successfully if I limit the number of parameters to 5 but
>this no good to me. My largest Fn is only 13 parameters, surely ADO can
cope
>with more than 5 by now ?? .Is there another method of doing this or a
>Command Property I can set ?
>I've also tried this using an Stored Proc within a Package - same thing !!
>Please Help !!
>
>Any suggesetions are much appreciated.
>Thanks
>Jason
>
>
>
>
>
Received on Tue Aug 10 1999 - 16:34:19 CDT