Hey Guys,
Any idea why I get this error:
when I try the ADDNEW method on ADO using the OraOLEDB.Oracle driver but when I use the MSDAORA.1 it works ??Code:Multiple-step operation generated errors. Check each status value.
HELP apreciated as this is DRIVING ME NUTS !!
Chars.
Pee
Haint nobody got no idea ???
I'm encountering this error msg all the time with ADO and Oracle but only during a .Update or UpdateBatch method call.
It is Oracle's way of telling ADO that the data didn't suit the structure of the table.
Are you trying to :-
- insert text into numerics?
- insert text too large for a text field?
- numbers too large?
- field name wrong or spelt incorrectly (for bound controls)
You mentioned you get this on an addnew which doesn't make sense, unless your addnew is firing a Oracle trigger that is trying to perform an update or something like that. Maybe your Addnew is firing an Update first.
To my knowledge, a .Addnew operates on a suitable recordset, not a database/backend - whereas a .Update operates on the backend via the recordset and this is where I get my multistep error message.
Gary, Thanks for your reply. I'm using Disconnected Recordsets The source of which is a dynamically created stored procedure
No connection, No activeConnection, no nothing. I get the data, disconnect it from it's source, addnew, delete & edit the data in it then pass the recordset to a function which filters for affected records & loops through them calling a stored procedure to do whatever action is required.
My problem is that all this works for MSADORA driver but MSADORA driver has implicity typing of inputs which differs dramatically from Oracle (ie Oracle says, pass me a number, but MSADORA says, no it's in fact not a Number and blows up ?), hence it's difficult to cast the variables Oracle expects to one the Driver thinks it should be, based upon the records in the ALL_ARGUMENTS table). To cut a long story short, I'm unable to use the MSADORA driver.
Now, not changing any code whatsoever, I changed the driver to ORAOLEDB. I can get my sp's, get my data, all fine, but when I want to simply ADDNEW or EDIT any of the fields in the disconnected recordset I get the STEP error.
My investigations have taken me deep into the object structure of the REcordset now (getting too familiar with it at this stage!!) but I can find no variance between the RS created with ADOORA as aainst ORAOLEDB.
My gues is that somehow, the ORAOLEDB driver does'nt support the interface for updateable fields, despite saying to the contrary.
Thanks again
Peeman.