my $sth = $dbh->prepare("INSERT INTO TABLE (ID, HEXPIC, CLASSIFICATION) VALUES (classifieds_seq.nextval, ?, '$item_type')")or print "$DBI::errstr"; $sth->bind_param( 1, $hex, SQL_LONGVARCHAR); $sth->execute or print"$DBI::errstr \n";