my $sql = "
DECLARE
  in_row  myObj;
  retcode number;
BEGIN
  :retcode := Otherpackage.Function(:in_row);
END;
";

my $sth = $dbh->prepare($sql) ...