When I dump stuff to a Long this is the format that I do. I use the DBI. $dbh is my database connection. This works for me.

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";
[download]

--BigJoe

Learn patience, you must.
Young PerlMonk, craves Not these things.
Use the source Luke.