Still having trouble inserting date into Oracle

[Rick Windham - ISDLIS]

Hello all,

Here is the code snip that I'm using to insert data into Oracle:

my $sql = qq{ insert into apache_load_test(host,ident,authuser,http_date) values (?, 
?, ?,
to_date(?,'dd/mon
/yyyy:hh:mi:ss')) };
my $sth = $dbh->prepare ( $sql );
if (!$dbh)
{
       print "error connecting; $DBI::errstr\n";
}
else
{
    open (EP,"/accounts/rickw/Dec2001access_log");
    #open (EP,"/u01/ias/ias10201/Apache/Apache/logs/Dec2001access_log");
    while (<EP>)
    {
        chomp;
        s/\[//g;
        s/\]//g;
        s/"//g;
        my @values = split (/ /,$_);
        print "ip address $values[0]  $values[1] $values[2] $values[3]\n";
        $sth->execute($values[0], $values[1], $values[2]), $values[3]|| die ("didn't 
insert
$dbh->errstr\n")
;
        $dbh->commit;

I receive this error:

execute called with 3 bind variables when 4 are needed at apache_slice_up.pl line 25, 
<EP> line 1.
Database handle destroyed without explicit disconnect, <EP> line 1.


Sample data from the open file where the data comes from:

191.9.453.334 - - [12/Dec/2001:14:42:08 -0500] "GET 
/Safety/codeforce/ArtWork/addl_off.gif HTTP/1.1"
304 -
191.9.453.433 - - [12/Dec/2001:14:42:08 -0500] "GET 
/Safety/codeforce/ArtWork/corr_on.gif HTTP/1.1"
304 -
191.9.453.354 - - [12/Dec/2001:14:42:08 -0500] "GET 
/Safety/codeforce/ArtWork/corr_off.gif HTTP/1.1"
304 -
191.9.453.234 - - [12/Dec/2001:14:42:08 -0500] "GET 
/Safety/codeforce/ArtWork/inre_on.gif HTTP/1.1"
304 -

Any help please..

Thanks

rickw



--
===============================
Rick Windham                  |
DATABASE ADMINISTRATOR        |
MANATEE COUNTY GOVERNMENT ISD |
941-749-3075                  |
941-749-3086 (fax)            |
[EMAIL PROTECTED] |
===============================