文档解释
ORA-06567: invalid number of values specified
Cause: An invalid number of values to be bound was specified in a call to the procedure BIND_VARIABLE in the package DBMS_SQL. In order to execute a given parsed statement in a given cursor, the same number of values must have been bound for all bind variables, so when EXECUTE is called, the latest calls to BIND_VARIABLE must must have specified the same number of values to be bound for all bind variables.
Action: Make sure that the same number of values have been bound for all of the bind variables.
这是一个ORACLE数据库错误,当在执行SQLLOADER命令时,指定的字段值的数量(行)不正确,也就是操作时,插入的记录行数与指定的记录行数不一致时,ORACLE数据库会报告此错误。
官方解释
ORA-06567: invalid number of values specified
Cause: A call to the SQL*Loader control file was issued that specified an inappropriate number of values.
Action: Check the field specification in the SQL*Loader control file against the table description.
常见案例
最常见的情况就是在SQL*Loader控制文件中指定的字段数不匹配表结构字段数造成: 当用control文件中指定的值插入时,由于指定的字段数与表字段数不匹配,就会报以上错误。
正常处理方法及步骤
1.检查SQL*Loader控制文件的字段描述和表的字段描述是否匹配。
2.根据SQL*Loader控制文件的完整性,对其字段进行相应的添加删除。
3.检查加载文件中每行数据与表字段数量是否一致,数据格式与表字段格式是否一致。
4.重新启动SQL*Loader加载操作,如果仍不成功,请检查SQL*Loader控制文件中错误参数段,分隔字符是否正确。