I am not sure if it helps, but I would use:
- FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"'
- COMMENTS position(n:n+2000) where n=the offset of the first character of the field
COMMENTS including delimiters
- ROW_POCESSED SEQUENCE(MAX,1)
inka
-Original Message-
Sent: Wednesday, Oc
Hi All,
Oracle 8.1.6 WinNT
I have been trying to use sqlldr and I am getting following error
Record 1: Rejected - Error on table "INTERVIEW", column COMMENTS.
end of logical record found when reading length of varying length field
Here is sample record and control file.
Any ideas why I get thi
look in the sqlldr docs for example control files,
1. truncate is a keyword for control file
2. load data
3. create trigger to do the insert into another table.
[EMAIL PROTECTED] wrote:
>
> Hallo,
>
> Can anyone give me an example on a control.file for th esql ldr that does the
>follow
Hallo,
Can anyone give me an example on a control.file for th esql ldr that does the
following:
Truncate table X inthe database
Loads data into table X
Makes an insert from that table into another table in the database.
And of course commit statement afterwards
Thanks in advance
Roland S
--
Sounds like a job for Perl.
Here's an example of cleaning up this data before you
send it to the database.
Really, this is much easier than doing it with PL/SQL or Java.
Jared
--
#!/usr/bin/perl
our %hashData;
while() {
my($key, @data) = s
I have a data file that looks like this;
100Memo line 1 information.
100more information for record 100.
100extra information again.
200Memo for 200.
200more info for 200
300info for 300
300next memo
300and more
300yet more again.
I want to load to a table (co