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 <7pb3pl$h6k$1_at_nnrp1.deja.com>,   stevenkoh6096_at_my-deja.com wrote:
> hi,
>
> May l know is there any way to call oracle stored procedure
>
> from perl ?
>
> Thanks
>
> with regards
> Steven
>
> 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 Wed Aug 18 1999 - 09:35:46 CDT