Call PL/SQL procedure from Perl - DBI

[Sashafay]

Hi,

How I can call PL/SQL store procedure from Perl - DBI script?

Thanks in advance,
Alex

[Joachim Pense]

Sashafay wrote:

> Hi,
>
> How I can call PL/SQL store procedure from Perl - DBI script?
>

$dbh->do("begin procedure_call; end;");

Actually, you can access procedure parameters (even in/out ones) and
read dbms_output. It is documented in the DBD::Oracle POD.

Joachim

[Sashafay]

Ron Reidy <r_reidy@comcast.net> wrote in message news:<3F5BC057.4040600@comcast.net>...

> perldoc DBD::Oracle
>
> Sashafay wrote:

> > Hi,
> >
> > How I can call PL/SQL store procedure from Perl - DBI script?
> >
> > Thanks in advance,
> > Alex

Thanks Guys!

Regards,
Alex