I was working on a program to take text files and insert them in to an
oracle datbase. I have the current version of both DBI and DBD:Oracle and
was trying to create a simple table wehn i got an error in reference to the
prepare.al
I run Mandrake 9 and my DBI utils are in
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/DBI
Here is my code
----------------------------------------------------------------------------
#!/usr/bin/perl
use DBI; #Opens DBI
#Connection to database
my $dbh = DBI->connect( "dbi:Oracle:accessdb", "webdata", "iisucks" )
or die "Cannot connect to Oracle Server\n: $DBI::errstr\n";
#Creating Tables #Line 19
my $sth = DBI->prepare( "CREATE TABLE rep (
srnu VARCHAR(6),
srna VARCHAR(30)
)
")
or die "Cannot prep for table rep\n: $DBI::errstr\n";
$sth->execute
or die "Cannot create table rep\n: $DBI::errstr\n";
#Close Database
$dbh->disconnect
or die "Disconnection Fialed: $DBI::errstr\n";
Here is the error
----------------------------------------------------------------------------
----------------------------------
Can't locate auto/DBI/prepare.al in @INC (@INC contains:
/usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at ./importv2
line 20
