VB6 SP3 / ADO2.1 /Ora 8 - "Error - Memory could not be written"
From: jason <jfielding_at_trinitech.co.uk>
Date: Tue, 10 Aug 1999 12:02:57 +0100
Message-ID: <7op0t2$88b$1_at_trinitech.demon.co.uk>
[Quoted] 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 [Quoted] record and passes back the new Oracle - generated PK. If I try passing more [Quoted] 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.
[Quoted] 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 [Quoted] 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 !!
Date: Tue, 10 Aug 1999 12:02:57 +0100
Message-ID: <7op0t2$88b$1_at_trinitech.demon.co.uk>
[Quoted] 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 [Quoted] record and passes back the new Oracle - generated PK. If I try passing more [Quoted] 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.
[Quoted] 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 [Quoted] 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 - 13:02:57 CEST