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


Reply via email to