SQL Loader with Expression-Function
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