http://qs321.pair.com?node_id=792890


in reply to Invoke and bind parameters to a PL/SQL Procedure

With DBI I used bind_param. Something like:

my $csr = $dbh->prepare(q{ BEGIN schema.package.stored_procedure(:param1, :param2); END; }); $csr->bind_param(':param1', $param1); $csr->bind_param(':param2', $param2); ...