Re: Strange results from OleDbCommand object

kirksmithson_at_hotmail.com (Smitty200) wrote in message news:<aa4fae9d.0306021041.5bf22001_at_posting.google.com>...
> I have a service I built in .net that will eventually run every two
> hours. It does a pull against an Oracle DB and pulls all records with
> a status of 3. These are then packaged up into an XML document and I
> use an HttpWebRequest object to send this XML to an aspx page on
> another server. Once the response from this server is received I
> update the oracle records with a status of 2. On the second server I
> place the Xml stream into a xml document and do some database inserts.
> I record if the inserts are successful or unsuccessful and send an XML
> stream back to an aspx page on the original server with the record
> number and wether it succeded or failed. I then run Updates against
> the Oracle table to change the 2 to a 1 for success or 0 for failed.
> The code runs and even tells me that 1 record was updated everytime I
> run the oledbcommand.executenonquery but when I do a pull against the
> Oracle table all records are still set to 2.
> Now if I save the same xml stream to a file and just run the page and
> have it pull this file everything works properly. Does anyone know why
> the automated method is not working. Thanks

Just a hunch... an Oracle commit maybe missing somewhere along the line after the updates.

Regards
/Rauf Sarwar Received on Mon Jun 02 2003 - 16:46:18 CDT