On Fri, Nov 09, 2001 at 10:44:47 +0100, sami Ghorbal wrote:
> does anyone has an idea on how to launch from PERL an oracle PL/SQL
> strored procedure?

perldoc DBI:
|   Calling stored procedures is currently not defined by
|   the DBI.  Some drivers, such as DBD::Oracle, support
|   it in non-portable ways.  See driver documentation for
|   more details.

perldoc DBD::Oracle:
[...]
|   $csr = $db->prepare(q{
|   BEGIN
|       PLSQL_EXAMPLE.PROC_NP;
|   END;
|   });
|   $csr->execute;
[... examples on passing parameters back and forth snipped ...]

-Wolfgang

Reply via email to