Well, to paraphrase Johnny Cochrane... "If the data fits, you must commit" :)
-----Original Message----- From: Morrison, Trevor (Trevor) [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 9:10 AM To: Ronald J Kimball Cc: [EMAIL PROTECTED] Subject: RE: DBD::Oracle problems Sorry, I should have told you that in the original message. Yes, I used sqlplus to delete the rows in the table (delete from trouble_report;) and I ran a: select * from trouble_report; --to verify that they were missing and they were. And, no I did not commit the transaction to delete the rows. Thanks Trevor -----Original Message----- From: Ronald J Kimball [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 10:01 AM To: Morrison, Trevor (Trevor) Cc: [EMAIL PROTECTED] Subject: Re: DBD::Oracle problems On Wed, Jun 25, 2003 at 10:04:09AM -0600, Trevor Morrison wrote: > I am running the Perl DBI interface which connects to a Oracle 8.1.7 > database. This all works fine. The problem that I have is that when > I run a particular script ( show below) the dataset that is returned > includes rows from the database that I had deleted prior to running > the script? Any thoughts. Thanks, How did you delete the rows? Did you commit the transaction in which you deleted the rows? If you run the query in sqlplus, does it show those rows? Ronald
