Maybe you can't rollback a SELECT statement, but it can be part
of a transaction.
Using Oracle as an example:
Session 1:
create table x ( x number );
insert into x values(1);
commit;
Session 2:
commit;
set transaction read only;
select * from x;
X
--
1
1 rows sele
On Thu, Feb 07, 2002 at 04:41:31PM -0500, Ronald J Kimball wrote:
> Selects, updates, and deletes are part of a transaction; they can be
> commited and rolled back. Creates and alters are not; they happen
> immediately and cannot be rolled back.
Selects? Oops. :D I didn't think that explanati
hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 13:53
Subject: RE: Re: Oracle DBI commit/rollback ques
Thanks. (I'm used to using Sybase... I din't know that)
What about inserts? Aren't they also part of a transaction?
-Dave-
-Original Message-
From: dpf
Sent: Thursday, February 07, 2002 4:48 PM
To: Wren, David
Cc: dpf; dbi-users
Subject: RE: Re: Oracle DBI commit/ro
PHONE (573) 341-4841
---
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 3:31 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Re: Oracle DBI commit/rollback question...
Mac,
Ok, I've go
On Thu, Feb 07, 2002 at 04:31:08PM -0500, [EMAIL PROTECTED] wrote:
> I probably shouldn't say "ROLLING BACK TRANSACTION" because the
> "Rollback Status = 1".
> But I expect because AutoCommit = "" (I set it OFF) that the table I
> created in the first SQL
> statement would not exist. But it d
d not exist. But it does!!
So I don't know why it won't rollback. Can you offer any more
suggestions? Is it perhaps
a setting in Oracle which overrides DBI rollback()?
-Dave-
-Original Message-
From: mchase
Sent: Wednesday, February 06, 2002 5:58 PM
To: Wren,
eats fish for an age.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 06, 2002 14:41
Subject: RE: Re: Oracle DBI commit/rollback question...
> Thanks Mac, but what I'm doing is looping different DML statements
> thro
m: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 06, 2002 14:03
Subject: Oracle DBI commit/rollback question...
> Does anybody know how Oracle8i handles transactions from DML statements
> passed from a DBI database connection?
>
> Do the dbh->co
Does anybody know how Oracle8i handles transactions from DML statements
passed from a DBI database connection?
Do the dbh->commit() and dbh->rollback() statements commit or rollback
all DML instructions issued while the connection is open, or just those
which get passed by sth->do() or sth->exec
10 matches
Mail list logo
