Re: DBD::Oracle - specifying rollback segments

2002-07-30 Thread Michael Nhan
Hi, I believe the syntax is: set transaction use rollback segment ; > > The statement for assigning a rollback segment (ALTER SESSION, I think) is > Oracle SQL. You can execute it with prepare()/execute() or do() just like > any other non-SELECT statement. > > Be aware that COMMIT rel

RE: DBD::Oracle - specifying rollback segments

2002-07-30 Thread Guidarelli, John
-Original Message- From: Michael A Chase [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 1:24 PM To: Guidarelli, John; 'DBI Users' Subject: Re: DBD::Oracle - specifying rollback segments On Tue, 30 Jul 2002 12:50:25 -0700 "Guidarelli, John" <[EMAIL PROTECTE

Re: DBD::Oracle - specifying rollback segments

2002-07-30 Thread Michael A Chase
On Tue, 30 Jul 2002 12:50:25 -0700 "Guidarelli, John" <[EMAIL PROTECTED]> wrote: > Is there anyway to specify the rollback segment to use in Oracle via the > DBD::Oracle module? > > I did not see anything in the DBD::Oracle or DBI perldocs other than the > begin_work DBH Object (which doesn't