Stored Proseedcakes

Embarrassingly, I don't have any handy examples lying about.

• Particularly Sybase or SQL Server, where stored procedure writers are found of returning multiple result sets from a single command -- read DBD::Sybase for more details.
• As an example, though, and just for DBD::Oracle:

$sth = $dbh->prepare(qq{
  BEGIN 
    EXECUTE some_sql_function(:one, :two); 
  END;
});
$sth->bind_param(":one", $one);
$sth->bind_param_inout(":two", $two);
$sth->execute();
## do something with $two

• Obviously, creating stored procedures is just like any other DDL; use do().