SQL Loader with Expression-Function

From: <maik.bischoff_at_arcor.de>
Date: 7 Nov 2006 04:47:09 -0800
Message-ID: <1162903629.356323.214390_at_k70g2000cwa.googlegroups.com>



[Quoted] Hello all,

[Quoted] I have a problem with the SQL-Loader using the expression-function. I get the following error but I cannot find whats wrong with my control-file.

Perhaps anyone can help me.

Thx and brdgs,
Maik

Record 1: Rejected - Error on table DHL.SA_CUSTOMER_IMPORT, column UPLOAD_ID.
ORA-00936: missing expression

Control-File:

LOAD DATA APPEND INTO TABLE DHL.SA_CUSTOMER_IMPORT FIELDS TERMINATED BY " " OPTIONALLY ENCLOSED BY '\''
TRAILING NULLCOLS (
APPLICATION_ID CONSTANT 1,
UPLOAD_ID EXPRESSION "SELECT
'LISA'||to_char(to_number(to_char(sysdate,'YYYYMM'))-1)||'ACT' from DUAL",
VERSION CONSTANT 'F2',
CUSTOMER_ID,
BU_ID,
YEAR_ID "REPLACE(:YEAR_ID,'Y','')",
PERIOD_ID "REPLACE(:PERIOD_ID,'M','')",
ACTIVITY_ID "REPLACE(:ACTIVITY_ID,'A_','')", SEGMENT_ID CONSTANT '',
PRODUCT_ID CONSTANT '',
SCENARIO_ID,
ACCOUNT_ID "DECODE(REPLACE(:ACCOUNT_ID,'ACC_',''), '10_A_10','10',
'10_A_20','10',
'10_A_30','10',
'10_A_40','10',
'10_A_50','10',
'20_A_10','20',
'20_A_50','20',REPLACE(:ACCOUNT_ID,'ACC_',''))",
DATA_UNIT_ID,
USER_ID CONSTANT 'LISAASIAEXPORT',
CHANGE_DATE SYSDATE,
DATA_VALUE,
ROW_NUMBER SEQUENCE(1,1),
ACTION_ID CONSTANT 10) Received on Tue Nov 07 2006 - 13:47:09 CET

Original text of this message