I have a sql loader that inserts perfect but it sends me the following error message you know what to do
load data
infile '&&1'
badfile '&&1.bad'
into table xgo_paso_envios
fields terminated by '|' optionally enclosed by '"'
(CUSTOMER_ID,COMUNA,DIRECCION)
---file
13414481|TALCAHUANO|ERRAZURIZ 3132 LAS SALINAS
13414482|TALCAHUANO|ERRAZURIZ 3132 LAS SALINAS
66447312|TALCAHUANO|PJE EL MONO 72
66447311|TALCAHUANO|PASAJE EL MORRO.. 72
72220043|TALCAHUANO|RIO ACONCAGUA 110 DENAVI SUR
--go
sqlldr $BDDUSER/$BDDPASS@$BDDHOST control=$DIR_SQL/$SQL_CARGARUTS DATA=${DIR_DATA}/cli_dire.txt log=${DIR_TMP}/tmp.tmp
--error
SQL*Loader: Release 11.2.0.4.0 - Production on Mon Dec 3 15:32:19 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Commit point reached - logical record count 38
ANALYZE TABLE XYG_NEG_CLIENTES_INPUT COMPUTE STATISTICS;
*
ERROR at line 1:
ORA-00911: invalid character