Re: Help: DBI in oracle

sorry, i forgot:
that would not be useful anyway, because after each transaction perl DBI makes a implicit commit
so the rollback segment is not used

Markus Stuhlpfarrer wrote:

> hi,
> the mistake in your script is that the set that you want to make is an sql*plus command
> and not an oracle command
> you cannot execute that from any client application except sql*plus
> there must be some alter session parameter or something like that, that does the same
>
> Mike F wrote:
>
> > Hi, I am posting here because I know a lot of good DBAs are also good
> > perl programmer. I have a perl scripts which I want to use only one rollback segment.
> > the script is like the follow:
> > _----------------------------------------------------------------
> > my $dbh = DBI->connect ( 'dbi:Oracle:test',
> > 'test',
> > 'test',
> > {
> > PrintError => 1,
> > RaiseError => 1,
> > AutoCommit => 1
> > }
> > ) || die "Database Connection not made $DBI::errstr" ;
> >
> > #increate day in a month
> > my $count1 = 1;
> > while ($count1 < 32)
> > {
> > my $T1="to_date('2001/1/$count1 00:00:00','yyyy/mm/dd
> > hh24:mi:ss')";
> > my $T2="to_date('2001/1/$count1 23:59:59','yyyy/mm/dd
> > hh24:mi:ss')";
> > $count1 = $count1 + 1;
> >
> > # set rollback segment
> > my $sql = qq{ set transaction use rollback segment RBS0 };
> > $dbh->do ( $sql );
> >
> > #move data from test to archtest
> > my $sql = qq{
> > INSERT INTO table1 select * from table2
> > where polltime > $T1 and polltime < $T2};
> > $dbh->do ( $sql );
> > }
> > $dbh->disconnect();
> > ----------------------------------------------------------------
> > But the first sql does not seem to work, the transaction did not use
> > rollback segment I specified.
> >
> > Could somebody help me out?
> >
> > Thanks for your help
> >
> >
> >
> > --
> > Sent by dbadba62 from hotmail piece of com
> > This is a spam protected message. Please answer with reference header.
> > Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Tue Sep 25 2001 - 01:41:28 CDT