X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI%2FOracle.pm;h=77cedf303e0a14d6b789f66cf8662017fc1ec563;hb=dbaee7482fe6ff190e8ae53d609d0294b911339b;hp=fa5d67f3f2b51be028d065fd67fd2a826c938dae;hpb=d73c65616463b6d435eac899dc2ef21c1b53b29a;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/lib/DBIx/Class/Storage/DBI/Oracle.pm b/lib/DBIx/Class/Storage/DBI/Oracle.pm index fa5d67f..77cedf3 100644 --- a/lib/DBIx/Class/Storage/DBI/Oracle.pm +++ b/lib/DBIx/Class/Storage/DBI/Oracle.pm @@ -9,20 +9,24 @@ use base qw/DBIx::Class::Storage::DBI::MultiDistinctEmulation/; # __PACKAGE__->load_components(qw/PK::Auto/); -sub _ora_last_insert_id { - my ($dbh, $sql) = @_; - $dbh->selectrow_array($sql); -} -sub last_insert_id { - my ($self,$source,$col) = @_; +sub _dbh_last_insert_id { + my ($self, $dbh, $source, $col) = @_; my $seq = ($source->column_info($col)->{sequence} ||= $self->get_autoinc_seq($source,$col)); my $sql = 'SELECT ' . $seq . '.currval FROM DUAL'; - my ($id) = $self->dbh_do(\&_ora_last_insert_id($sql)); + my ($id) = $dbh->selectrow_array($sql); return $id; } -sub _ora_get_autoinc_seq { - my ($dbh, $source, $sql) = @_; +sub _dbh_get_autoinc_seq { + my ($self, $dbh, $source, $col) = @_; + + # look up the correct sequence automatically + my $sql = q{ + SELECT trigger_body FROM ALL_TRIGGERS t + WHERE t.table_name = ? + AND t.triggering_event = 'INSERT' + AND t.status = 'ENABLED' + }; # trigger_body is a LONG $dbh->{LongReadLen} = 64 * 1024 if ($dbh->{LongReadLen} < 64 * 1024); @@ -36,17 +40,9 @@ sub _ora_get_autoinc_seq { } sub get_autoinc_seq { - my ($self,$source,$col) = @_; + my ($self, $source, $col) = @_; - # look up the correct sequence automatically - my $sql = q{ - SELECT trigger_body FROM ALL_TRIGGERS t - WHERE t.table_name = ? - AND t.triggering_event = 'INSERT' - AND t.status = 'ENABLED' - }; - - $self->dbh_do(\&_ora_get_autoinc_seq, $source, $sql); + $self->dbh_do($self->can('_dbh_get_autoinc_seq'), $source, $col); } sub columns_info_for {