On Tue, Mar 11, 2003 at 03:13:32PM +0530, murugan mohan wrote: > 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.
I don't think so. Tim. > 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