in reply to performing stored procedures with the DBI

According to the documentation (perldoc) for DBD::Oracle, all you should have to do is wrap you code with a BEGIN and END (Oracle's BEGIN/END PL/SQL, not Perl's BEGIN/END):
$dbh->do("BEGIN exec XML_BULK_LOADER.clear_database_values('tester') + END");