I agree with Gordon -- we need to see your code...if you have something like a "WHERE" clause in your "SELECT" statement that is eroneously pointing to the wrong information, but is still sintactically correct, your sql select statement will bomb without an error message and give you the wrong output, if any output at all -- I say this because I've been there...and realized my problem later. This is just a possibility... but, code would be much appreciated... :-) -- Margie New
--- [EMAIL PROTECTED] wrote: > It would help if we had the code to look at. > > -----Original Message----- > From: Sam Seaver [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 29, 2002 11:53 AM > To: [EMAIL PROTECTED] > Subject: update not committing > > > Im running perl v 5.6.1 > DBI 1.21 > DBD-Oracle 1.12 > > With the logging level set to 2, according to the > resulting log, I am > successfully updating my tables with the relevant > information. > > However, when i try to select the updated > information, whether from > within the script, sqlplus or even a seperate web > interface, I am not > getting the updates! It's almost as if the commit is > not working, but i > turned the autocommit off and did it again with > manual committing, and > this is registered in the logging but still, i > cannot select the > information, as it is NOT THERE! > > What is happening? > > S ===== Margie New 5503 Lands End Austin, Texas 78734 (512) 266-3947 e-mail: [EMAIL PROTECTED] __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com
