I just tested the following code in Oracle Express, and it works: a new row is inserted. The database is on my local machine. Note that AutoCommit is true.

use DBI;
my $dd = DBI->connect('dbi:Oracle:', 'scott', 'tiger',
  { RaiseError => 1, PrintError => 0 });
my $sth = $dd->prepare("insert into prod (ss) select 1+max(ss) from pr
+od");
$sth->execute;
$dd->disconnect;
[download]

So, I see no conceptual reason why it shouldn't work.