Re: SQL*Loader-282

Can you connect to the database as system and select * from v$nls_parameters

There should be three records displayed that are relevant to the setting of NLS_LANG. These have the parameter field set to NLS_LANGUAGE, NLS_TERRITORY and NLS_CHARACTERSET. The values of these three records can be used to set the value of NLS_LANG on your client.

For example, my database is in England so the three parameters come out of my database like this: -

NLS_LANGUAGE            ENGLISH
NLS_TERRITORY            UNITED KINGDOM
NLS_CHARACTERSET    AL32UTF8

The NLS_LANG parameter is set on my clients as: -

    NLS_LANG='ENGLISH_UNITED KINGDOM.AL32UTF8' I think the error you are seeing might be because the character set is not defined in the NLS_LANG variable on your clients. Try setting NLS_LANG on your client as above with your own territory and character set settings and see whether this cures the problem.

Regards,

Richard

"Faisal" <faisal_qasimpk_at_yahoo.com> wrote in message news:d55ce0a6.0305072337.503ef6a2_at_posting.google.com...
> Richard,
>
> Same error appears, after setting 'NLS_LANG=AMERICAN' and
> 'NLS_LANGUAGE=AMERICAN' on client end.
>
> What else can I try?
>
> Thanks
> "Richard" <qaz1521_at_hotmail.com> wrote in message
news:<b9bv90$l73$1$8300dec7_at_news.demon.co.uk>...
> > Faisal,
> >
> > Do you have the NLS_LANG environment variable set on your client when
you
> > see this error? If so, what is it set to? What is the database
character
> > set in use on your server?
> >
> >
> > "Faisal" <faisal_qasimpk_at_yahoo.com> wrote in message
> > news:d55ce0a6.0305070533.57c3ba_at_posting.google.com...
> > > Dear all,
> > >
> > > While trying SqlLoader from 8i client to upload data in a 7.3.4 db, we
> > > are getting following error:
> > >
> > > SQL*Loader-282: Unable to locate character set handle for character
> > > set ID (0).
> > >
> > > We have tried loader on server side, which works fine. This error
> > > appears on Win 98 as well as XP.
> > >
> > > How can this be resolved? I am really desparate since this is
> > > mandatory part of an application.
> > >
> > > I will be grateful for your help.
> > >
> > >
> > > Regards
Received on Fri May 09 2003 - 08:46:36 CDT