How does one invoke stored procedures with DBI?

There is currently no standard way to call stored procedures with DBI. However,
if you have created a stored procedure within an Oracle database, you can
use $dbh->do() to immediately execute the procedure:

    $dbh->do("BEGIN myPackage.myProcedure; END;");