No, this is done as: $csr=$dbh->prepare($sql)
then as $csr->execute(@parms) inside of a loop. On Feb 18, 2011, at 12:33 PM, Bill Ward wrote: > You're probably calling do($sql, @args) when you should call do($sql, undef, > @args) > > On Fri, Feb 18, 2011 at 11:31 AM, Bruce Johnson < > john...@pharmacy.arizona.edu> wrote: > >> I'm getting the following error: (some data has been change to protect the >> bystanders.) >> >> DBD::Oracle::st execute failed: called with 18 bind variables when 19 are >> needed [for Statement "insert into edsbase >> (cn,emplId,employeeType,employeeTitle,employeeStatus,employeeTotalAnnualRate,sn,givenName,netid,mail,employeeBldgName,employeeBldgNum,employeeCity,employeeFTE,employeePhone,employeePoBox,employeeRoomNum,employeeState,employeeZip) >> values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) >> " with ParamValues: :p1='Werner S Noname', :p10='some@here', :p11='COLL OF >> PHARMAC', :p12='00207', :p13='TUCSON', :p14='0', :p15='5205114411', :p16='PO >> BOX 210207', :p17='344', :p18='AZ', :p19='85721-0207', :p2='111111111', >> :p3='N', :p4='nosal', :p5='A', :p6='0', :p7='Zimmt', :p8='Werner S', >> :p9='wsz'] at ./edsload.pl line 97, <DATA> line 532. >> >> I've counted three times: I have 19 fields in the db, 19 '?'s, and 19 param >> values being passed, why am I getting this error? >> >> >> >> -- >> Bruce Johnson >> University of Arizona >> College of Pharmacy >> Information Technology Group >> >> Institutions do not have opinions, merely customs >> >> >> > > > -- > Check out my LEGO blog at http://www.brickpile.com/ > View my photos at http://flickr.com/photos/billward/ > Follow me at http://twitter.com/williamward -- Bruce Johnson University of Arizona College of Pharmacy Information Technology Group Institutions do not have opinions, merely customs
