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
