my $sql = 'begin sm_api.renew_subscription(:1, :2, :3, :4); end;'; my $sth = $db->prepare($sql);
eval
{
$sth->bind_param(1, $order_id);
$sth->bind_param(2, $version_id);
$sth->bind_param(3, $sid);
$sth->bind_param_inout( 4, \$ret, 128 );
$sth->execute;
};
if( $@ )
{
# ........
}
-----Original Message-----
From: Biswajeet Padhy [mailto:[EMAIL PROTECTED]
Sent: Friday, June 20, 2003 1:45 PM
To: 'Alan Burlison '
Cc: ''[EMAIL PROTECTED]' '
Subject: RE: Perl:DBI:Oracle
Thanks Alan,
Can I call a stored procedure in perl DBI using DBD:Oracle driver. If so
can
I have a sample piece of code so that I can call a stored procedure.
the stored procedure will take some input parameters and return a unique
no.
Thanks for your help.
Biswajeet
-----Original Message-----
From: Alan Burlison
To: Biswajeet Padhy
Cc: '[EMAIL PROTECTED]'
Sent: 6/14/03 1:49 PM
Subject: Re: Perl:DBI:Oracle
Biswajeet Padhy wrote:
> I am a perl developer going to install Perl DBI in solaris which
require
> make utility. But I don't have a C compiler on my UNIX Box. Is there
any pre
> compiled version of Perl:DBI and DBD:Oracleis available so that I can
> directly install on my BOX.
You will need the Oracle client libraries, so you need to install Oracle
anyway. You can get this free for development purposes from
http://oracle.com
You should also grab a copy of gcc to build the DBI and DBD::Oracle
modules,
available prebuild from a number of sources:
http://wwws.sun.com/software/solaris/freeware/index.html
http://www.sunfreeware.com/
http://www.blastwave.org/
--
Alan Burlison
--
smime.p7s
Description: S/MIME cryptographic signature
