or download this
use DBI qw(:sql_types);
use DBD::Oracle qw(:ora_types);
my $sql3="insert into BEE_DBO.SQL_EXECUTION_LOG(process_execution_id,"
+. "process_step_seq,file_id,sql_statement)". "values(?,?,?,?)";
...
$sth2->bind_param(3,$file_id);
$sth2->bind_param(4,$select_insert,SQL_LONGVARCHAR);
$sth2->execute;