I am trying to set the transaction use specified rollback segment so I do
not
have to deal with error "SNAPSHOP TOO OLD"
here is the problemic part of my script
----------------------------------------------------------
my $dbh = DBI->connect ( 'dbi:Oracle:test',
'test',
'test',
{
PrintError => 1,
RaiseError => 1,
AutoCommit => 1
}
) || die "Database Connection not made $DBI::errstr"
;
# set rollback segment
my $sql = qq{ set transaction use rollback segment RBS0 };
$dbh->do ( $sql );
bla bla
$dbh->disconnect();
----------------------------------------------------------------
But it does not seem to work, the transaction did not use
rollback segment I specified.
Could somebody help me out?
Thanks for your help
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
