SQL LOADER

From: <ulysse51_at_my-deja.com>
Date: Fri, 10 Mar 2000 10:47:04 GMT
Message-ID: <8aajr8$65r$1@nnrp1.deja.com>

hi there,

i want to load some data in a table with sql loader in direct path, my control file seems like :

Options (DIRECT = True)
UNRECOVERABLE
Load Data
APPEND
INTO TABLE INPUT
FIELDS TERMINATED BY ";" OPTIONALLY ENCLOSED BY '"' (
LINE_ID "IMPORT_SEQ.NEXTVAL", SOURCE_FILE CONSTANT "C:\\Windows\\temp\\\File000.csv", USERID CONSTANT "JPB1", ID_INTERNAL_SOURCE,EXTERNAL_SOURCE,.......) without the options (direct=true) it works but with this option i've got the message : not allowed in direct path on column line_id, i precise that in this column i want to put a sequence thanks for your help
best regards
Fred

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Mar 10 2000 - 04:47:04 CST