Re: perl with oracle stored procedure

Try in this way:

$dbh = DBI->connect("dbi:Oracle:", 'user/pass_at_db') if ($DBI::err) {
  print " NOT ALIVE\n";
  die;
}

$Sql  = "BEGIN \n";
$Sql .= "your_stored_procedure_n1 ( 'constant parameter'); \n";
$Sql .= "your_stored_procedure_n2 ( :variable_parameter ); \n";
$Sql .= "END; \n";
$sth = $dbh->prepare($Sql);
$sth->bind_param_inout(":variable_parameter", \$Perl_variable)
$sth->execute;

see DBI manual for more information

Good luck :-)
Massimo

In article <7pb4kl$hl4$1_at_nnrp1.deja.com>,   stevenkoh6096_at_my-deja.com wrote:
> hi,
>
> Is there any way to call a oracle stored procedure using perl?
>
> how do l do it ?
>
> Kindly advise.
>
> Thanks
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

--
 Massimo Balestra
 System Engineer
 Torino Italy

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 17 1999 - 03:46:51 CDT