Re: SQL*Loader problem - problem solved

pwneilson_at_telus.net (PWN) wrote in message news:<f8044af9.0407022150.34502d86_at_posting.google.com>...
> pwneilson_at_telus.net (PWN) wrote in message news:<f8044af9.0407021409.333df0ed_at_posting.google.com>...
> > Hi folks, I am having a problem using SQL loader to load some data
> > from a text file into a table. I am getting a "ORA-01722: invalid
> > number" error in the log file when loading data that has decimal
> > values.
>
> Problem Solved.
>
> In case anyone may have this problem, the solution is the following: I
> was trying to SQL load data using the "." as a decimal character.
> However, the NLS_NUMERIC_CHARACTERS setting (".,") was only set at the
> session level, not at the database level. Once I set the
> NLS_NUMERIC_CHARACTERS in the system registry and bounced the
> database, problem solved. Moral of the story: be sure to set the
> NLS_NUMERIC_CHARACTERS in the system registry so they take effect at
> the database level.

"I sell a lot of reports online. I sold a report to a Japanese client. The shopping cart system made the mistake with the comma. Instead of charging my client $1,200, it charged 1.2 cents." - Renato Beninatto

jg

--
@home.com is bogus.
Happy 58th Birthday, Burt Ward!