http://www.perlmonks.org?node_id=750561

cocl04 has asked for the wisdom of the Perl Monks concerning the following question:

All, I am trying to load data from a '*.csv' file to Oracle via the Oracle::SQLLoader module in a Windows enviorment. The code will not execute Below is the code. When I run it, I get the following error: Use of uninitialized value in concatenation (.) or string at C:/Perl/site/lib/Oracle/SQLLoader.pm line 576.

Does anyone out there have any suggestions?

Code:

#!/usr/local/bin/perl use strict; use warnings; use diagnostics; use Oracle::SQLLoader qw/$CHAR $INT $DECIMAL $DATE/; ### load a simple comma-delimited file to a single table my $ldr = new Oracle::SQLLoader( infile => 'C:\Sales Report Thru 12 March 2009.csv', terminated_by => ',', username => 'xxxxx', password => 'xxxxx', sid => 'xxxxx' ); $ldr->addTable(table_name => 'testTableName'); $ldr->addColumn(column_name => 'Location_ID'); $ldr->addColumn(column_name => 'Type_Description'); $ldr->addColumn(column_name => 'Type_ID'); $ldr->addColumn(column_name => 'DetailType'); $ldr->addColumn(column_name => 'Amount'); $ldr->executeLoader() || warn "Problem executing sqlldr: \n";