Author: spadkins
Date: Mon Jul  6 13:04:29 2009
New Revision: 13009

Modified:
   p5ee/trunk/App-Repository/lib/App/Repository/Oracle.pm

Log:
use self name instead of self dbname in specifiying the sqlldr options

Modified: p5ee/trunk/App-Repository/lib/App/Repository/Oracle.pm
==============================================================================
--- p5ee/trunk/App-Repository/lib/App/Repository/Oracle.pm      (original)
+++ p5ee/trunk/App-Repository/lib/App/Repository/Oracle.pm      Mon Jul  6 
13:04:29 2009
@@ -496,7 +496,8 @@
         $nrows = $self->insert_rows($table, $columns, $file, $options);
     }
     else {
-        my $context_options = $self->{context}{options};
+        my $context         = $self->{context};
+        my $context_options = $context->{options};
         my $prefix    = $context_options->{prefix};
         my $debug_sql = $context_options->{debug_sql};
         my ($timer, $elapsed_time);
@@ -508,6 +509,7 @@
         $filebase =~ s/\.dat$//;
 
         my $dbname = $self->{dbname};
+        my $dbrep  = $self->{name};
         my $control_key_source = join(",", @$columns);
         if ($options && %$options) {
             my @option_keys = sort keys %$options;
@@ -533,13 +535,13 @@
 
         #my $sqlldr_options = " direct=TRUE parallel=TRUE silent";
         my $sqlldr_options = "";
-        if ($context_options->{"app.Repository.$dbname.$table.import_rows"}) {
+        if ($context_options->{"app.Repository.$dbrep.$table.import_rows"}) {
             $sqlldr_options .= " " if ($sqlldr_options);
-            $sqlldr_options .= "rows=" . 
$context_options->{"app.Repository.$dbname.$table.import_rows"};
+            $sqlldr_options .= "rows=" . 
$context_options->{"app.Repository.$dbrep.$table.import_rows"};
         }
-        if 
($context_options->{"app.Repository.$dbname.$table.import_bindsize"}) {
+        if 
($context_options->{"app.Repository.$dbrep.$table.import_bindsize"}) {
             $sqlldr_options .= " " if ($sqlldr_options);
-            $sqlldr_options .= "bindsize=" . 
$context_options->{"app.Repository.$dbname.$table.import_bindsize"};
+            $sqlldr_options .= "bindsize=" . 
$context_options->{"app.Repository.$dbrep.$table.import_bindsize"};
         }
 
         my $cmd = "sqlldr userid=$self->{dbuser}/$self->{dbpas...@$dbname 
data=$datfile control=$ctlfile bad=$badfile log=$logfile errors=0 
$sqlldr_options > $outfile 2>&1";

Reply via email to