[askdba] Re: Excel (csv file) and sqlldr(urgent, going mad he re)

  • From: Regis Biassala <Regis.Biassala@xxxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Wed, 10 Nov 2004 16:27:23 -0000

Thanks Justin,
I found the cause of my error...it is working now fine (I did panic..!!!).

My error was due to the fact I was trying to create a csv file while in fact
the file was excel (forcing a wrong extension).


Regis


 

-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx] On
Behalf Of Justin Cave (DDBC)
Sent: 10 November 2004 16:00
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: Excel (csv file) and sqlldr(urgent, going mad here)

How is the column defined (i.e. CHAR(3))?  What is the database
character set and what is the three-letter code?

Justin Cave  <jcave@xxxxxxxxxxx>
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]
On Behalf Of Regis Biassala
Sent: Wednesday, November 10, 2004 8:51 AM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Excel (csv file) and sqlldr(urgent, going mad here)

Hi guys,
I wrote a package which installs some data loaded from a csv file format
to
Oracle.

This process used to work fine...no problem.

=20

The format of the data is fine...but I can't now loaded using sqlldr..

I don't know what could be wrong...

It is complaining that the value inserted is too large while the value
itself is only 3 letter code for that column...

=20

Has anyone experienced this before...?

=20

I am on Oracle9iR2 Patch 4...

=20

If one wants to try it out for me, please let me know...I'll send you
the

Table ddl, ctl file and the csv file.

=20

=20

Thanks,

Regis





Other related posts:

  • » [askdba] Re: Excel (csv file) and sqlldr(urgent, going mad he re)