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 take any parameters). 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 releases the segment so you need AutoCommit off. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
