$dbh = $dbh->prepare("INSERT INTO vindbase_operator.mobily_vb_
+script_worklistv2 (worklistid, emstype, submitserver, submitdate, sub
+mitowner, state, contents, contentscksum) VALUES (vindbase_operator.m
+obily_vb_script_worklist_inc.nextval,?,?,to_date(?,'YYYY-MM-DD H
H24:MI:SS'),?,?,?,?)");
[download]

The aove cited code looks suspicious to me. You are reassigning your database handle as a statement handle and then trying to treat it as a database handle again later on in your code.

When using DBI I normally use another variable as my statement handle thusly:

my $sth = $dbh->prepare("INSERT INTO vindbase_operator.mobily_vb_
+script_worklistv2 (worklistid, emstype, submitserver, submitdate, sub
+mitowner, state, contents, contentscksum) VALUES (vindbase_operator.m
+obily_vb_script_worklist_inc.nextval,?,?,to_date(?,'YYYY-MM-DD H
H24:MI:SS'),?,?,?,?)") or die $dbh->errstr;
[download]

and then hopefully life goes on as normal. Use the $sth to execute your insert.

That's just the first thing that leaps to my attention...