有没有人在啊,想请教下,java 往oracle中插入SQL语句出现:“索引中丢失 IN 或 OUT 参数:: 1”?
java 往oracle中插入SQL语句出现:“索引中丢失 IN 或 OUT 参数:: 1”if("0".equals(emp.getPeriodType())){
sql="insert into emp_info(emp_seq,emp_id,emp_name,emp_sex,emp_birth,emp_card," +
" start_date,job_date,emp_forms,emp_origin,polit_status,nation,native_place," +
" emp_tel,email,stature,blood_type,marriage_status,birth_place,domicile_place," +
" hight_education,hight_degree,school_name,major,grad_date,dep_id,post_id,type)" +
" Values (emp_seq.nextval,?,'aa','男',to_date('1985-4-8','yyyy-mm-dd')," +
"'211334678965437662',to_date('2010-01-07','yyyy-mm-dd'),to_date('2010-01-07','yyyy-mm-dd')," +
"'q','q','a','a','a','a','a','a','a','a','a','a','a','a','a','a'," +
"to_date('2010-01-07','yyyy-mm-dd'),'A0001','P0001','0')";
// sql="insert into emp_info(emp_seq,emp_id,emp_name,emp_sex,emp_birth," +
// "emp_card,start_date,job_date,emp_forms,emp_origin," +
// "polit_status,nation,native_place,emp_tel,email," +
// "stature,blood_type,marriage_status,birth_place,domicile_place,hight_education," +
// "hight_degree,school_name,major,grad_date,dep_id,post_id,type)" +
// " values(emp_seq.nextval,?,?,?,to_date('?','yyyy-mm-dd'),?,t