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";
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Oracle::SQLLoader Error
by ramrod (Curate) on Mar 14, 2009 at 05:02 UTC | |
by cocl04 (Sexton) on Mar 16, 2009 at 14:53 UTC | |
Re: Oracle::SQLLoader Error
by bichonfrise74 (Vicar) on Mar 14, 2009 at 05:04 UTC |
Back to
Seekers of Perl Wisdom