SQL*Loader-702 Internal Error - Unknown Column for OCI_ATTR_COL_COUNT (Doc ID 802996.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4
This problem can occur on any platform.

Symptoms

You try to load in direct path mode a table containing a DATE column like in the test below:

create table cdh
(
   col1       varchar2(10),
   lastupdate date
);

Control file cdh.ctl

load data
infile *
into table cdh
truncate
(
   col1       position (1:8),
   lastupdate position(9:22) date "YYYYMMDDHH24MISS" "replace (:lastupdate, '00000000000000', '19001231000000')"
)
begindata
first   20011201000000
second  20021202000000
third   00000000000000

SQL*Loader command line:

#> sqlldr tester/password control=cdh.ctl direct=true

This ends with errors:

SQL*Loader-702: Internal error - Unknown column for OCI_ATTR_COL_COUNT
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms