DBD::mysql::st execute failed: Query was empty at otest.pl line 56.
SQL error:$DBI::errstr

##</code><code>##

print "Symbol: $h1{'symbol'}\tExpn_date: $exp\tStrike: $h1{'strike'}\tBid: $h1{'bid'}\tAsk: $h1{'ask'}\tLast: $h1{'last'}\tOpen: $h1{'open'}\tVolume: $h1{'volume'}\n ";

my $ins_rec="INSERT INTO $table (symbol,expn_dt,strike,open,bid,ask,last,volume) VALUES(\'$h1{'symbol'}\',\'$exp\',\'$h1{'strike'}\',\'$h1{'open'}\',\'$h1{'bid'}\',\'$h1{'ask'}\',\'$h1{'last'}\',\'$h1{'volume'}\');";

##</code><code>##

my $dbh=DBI->connect($dsn,$user,$pwd) || die "could not connect to database:$error\n";

##</code><code>##

  my $sth=$dbh->prepare($ins_rec);

     $sth->execute || die "SQL error:$error\n";