Sqlldr question again (all text I hope)
From: Mikael Johansson <mjo_at_algonet.se>
Date: 1996/02/25
Message-ID: <4gq917$7l0_at_prometheus.algonet.se>#1/1
1996022014013658511019960320 99
[EOF] execution results in (extract of bad-file):
Date: 1996/02/25
Message-ID: <4gq917$7l0_at_prometheus.algonet.se>#1/1
I would appreciate if anyone could explain why this doesn't work.
Load file looks like this:
load data
infile *
append into table ordque(
time_que position (01:14) date 'YYYYMMDDHH24MISS', time_que_ms position (15:20) integer external, time_limit position (21:32) date 'YYYYMMDDHH24MI' "rpad(:time_limit,12,'0')", que_no position (33:34) integer external) begindata
1996022014013658511019960320 99
[EOF] execution results in (extract of bad-file):
Column TIME_LIMIT had SQL string "rpad(:time_limit,12,'0')" applied to it.
Record 1: Rejected - Error on table ORDQUE, column TIME_LIMIT. ORA-01840: input value not long enough for date format
The reason I want to do this is that I have hundreds of Megabytes to load and the time_limit field may or may not include the time value. Do I have to include seconds as well and if so how do I manage that?
Thanks,
Mikael Johansson, Stockholm Stock Exchange, email-work: mikael_at_xsse.se
Received on Sun Feb 25 1996 - 00:00:00 CET