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

Reply via email to