> Hi,

> i was wondering whether it is possible (and more importantly how!) to
> execute some PL/SQL stored procedures on Oracle (stprocs) from PERL.

> I know using DBI, perl can execute SELECT stprocs but what about
> DELETE and UPDATES? Also can those DELETE and UPDATES stprocs return a
> value to PERL (say number of rows deleted or updated)?

> In these codes, im actually calling a stproc found in a Package and it
> simply select date from dual.

> use DBI qw(:sql_types);

>        my $today;

>        $csr = $dbh->prepare(q{
>              BEGIN
>                  PACK_TEST.TEST_PROC (:today);
>              END;
>        });

>        $csr->bind_param_inout(":today", \$today, 20);
>        $csr->execute;
>        print "Today is $today\n";

>        $dbh->disconnect;

> Is there some equivalent codes for DELETE and UPDATE?

> Thanks,

> GC.