OraFAQ Forum: General » Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status val

Home » Other » General » Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status val

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status val [message #134787]

Sat, 27 August 2005 00:47

stayi
Messages: 8
Registered: August 2005

Junior Member

Hi,

I have been using MSDAORA.1 provider till recently when I changed to OraOLEDB.Oracle provider.

After changing to this I started getting a error.

My test VB code:

Dim cn As New ADODB.Connection
Dim rsDtl As New ADODB.Recordset
Dim sSQL As String

sSQL = "SELECT A.DSP_SKU FROM A,B WHERE A.1 = 'YREPLSKU01' A.2=B.2"

cn.ConnectionString = "Provider=OraOLEDB.Oracle;Password=XXX;User ID=XXX;Data Source=XXX"
cn.Open
rsDtl.CursorLocation = adUseClient
rsDtl.LockType = adLockOptimistic
rsDtl.Open sSQL, cn

rsDtl.Fields("DSP_SKU") = "1" 'It fails here if we use OraOLEDB.Oracle provider instead of MSDAORA.1.

NOTE: IT works fine if my recordset is a result of a single table query as below.
sSQL = "SELECT DSP_SKU FROM A WHERE 1 = 'YREPLSKU01'"

Please comment if there is a known solution for this.

Thanks.

[Updated on: Sat, 27 August 2005 02:08]

Report message to a moderator

Re: Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status [message #134798 is a reply to message #134787]

Sat, 27 August 2005 03:53

Maaher
Messages: 7065
Registered: December 2001

Senior Member

stayi wrote on Sat, 27 August 2005 07:47

After changing to this I started getting a error.

You forgot to mention what errors you are getting.

MHE

Report message to a moderator

Re: Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status [message #134800 is a reply to message #134798]

Sat, 27 August 2005 03:57

stayi
Messages: 8
Registered: August 2005

Junior Member

I get this error:

Multiple-step operation generated errors. Check each status value.

Report message to a moderator

Re: Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status [message #134804 is a reply to message #134800]

Sat, 27 August 2005 04:11

Maaher
Messages: 7065
Registered: December 2001

Senior Member

A google for the error told me this:

 This error means that one or more fields you are inserting/updating contain an invalid value. Some of the possible scenarios are:

1. A string value is being inserted into a numeric field.
2. An invalid date expression is being inserted into a date field.
3. A string value being inserted is longer than the size of the string field.
4. A null value is being inserted into a field that does not allow nulls.

Verify the data types.

MHE

Report message to a moderator

Re: Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status [message #134805 is a reply to message #134804]

Sat, 27 August 2005 04:12

stayi
Messages: 8
Registered: August 2005

Junior Member

But thats not the case. The datatype is fine. Note that I stated it works fine if the recordset is from a single table, its only when we have joins that it starts throwing this error.

Report message to a moderator

Re: Pblm with OraOLEDB.Oracle provider - Multiple-step operation generated errors. Check each status [message #134811 is a reply to message #134805]

Sat, 27 August 2005 04:35

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Sorry, I'm no Visual Basic specialist. I can only point you to MSDN: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q269495

Do the queries work in SQL*Plus? Have you tried a simple EMP/DEPT join from the SCOTT schema?

MHE

[Updated on: Sat, 27 August 2005 04:39]

Report message to a moderator