Hi Tim,
I know that my DBI version is old. I can't update my version since there are
lot of security restrictions. So the last thing I am left is call the stored procedure
each time for inserting a single row. Is there any other better way so that I can
minimize the calls to the SQL/PL. Please let me know.
Regards
Murugan
----- Original Message -----
From: Tim Bunce
Sent: Tuesday, March 11, 2003 3:08 PM
To: murugan mohan
Cc: Tim Bunce
Subject: Re: bind param array
Maybe your DBI version is too old.
Tim.
p.s. Please send all email to [EMAIL PROTECTED], not to me. Thanks.
On Tue, Mar 11, 2003 at 10:32:25AM +0530, murugan mohan wrote:
> Hi Tim,
> Thanks for sending me the reply so soon. I changes the code to execute_array
> and the error message I got is
> Can't locate object method "bind_param_array" via package "DBI::st" at dbcon.pl line
> 80
> whether bind_param_array is not supported in 5.6 version?. Also I can't shift my
> perl version to 5.8 or later because It involves lot of work. Is there any other way
> in 5.6 where I can call a stored procedure passing arrays as the arguments.
>
> Regards
> Murugan
>
> ----- Original Message -----
> From: Tim Bunce
> Sent: Monday, March 10, 2003 5:43 PM
> To: murugan mohan
> Cc: users perl perl
> Subject: Re: bind param array
>
> On Mon, Mar 10, 2003 at 03:17:46PM +0530, murugan mohan wrote:
> > Hi all,
> > I am trying to know how I can use bind array. I am having Perl version 5.6 and
> > i am working in windows 2k.
> > what I tried is as follows.
> >
> > $sth = $g_dbh->prepare(q{
> > BEGIN
> > test_1.P1(
> > ?,
> > ?,
> > ?,
> > ?);
> > END;
> > });
> > $sth->bind_param_array(1,[EMAIL PROTECTED]);
> > $sth->bind_param_array(2,[EMAIL PROTECTED]);
> > $sth->bind_param_array(3,[EMAIL PROTECTED]);
> > $sth->bind_param_array(4,[EMAIL PROTECTED]);
> >
> > $sth->execute();
>
> $sth->execute_array;
>
> Tim.Get more from the Web. FREE MSN Explorer download : http://explorer.msn.comGet
> more from the Web. FREE MSN Explorer download : http://explorer.msn.com
