Try http://www.orafaq.com/error/ora-01722.htm#WHAT
HTH
"Roar Renton" <roar.renton_at_lilleaker.com> wrote in message
news:eacc310a.0205020307.54b1f838_at_posting.google.com...
> Hei.
>
> I am quite new to Oracle, and I have problems getting an application
> to work with Oracle 9i. I have already searched different newsgroups
> and I have noticed that there have been lots of questions about
> ORA-01722 errors and I have
> tried different approaches to get it to work but without luck. Our
> company is rather small so we do not have people that are good at
> these things, that is why I tried to do it myself.
>
> We have Oracle 9i installed on a server, and we use Oracle 9i client
> to connect to it. Earlier we were using the same application with
> Personal Oracle 8 and it worked fine, but now only certain parts of
> the program works.
>
> I do not know exactly what is needed to answer this problem, but here
> are the nls-settings on this machine (the client):
>
> PARAMETER VALUE
> ------------------------------
> ----------------------------------------
> NLS_LANGUAGE NORWEGIAN
> NLS_TERRITORY NORWAY
> NLS_CURRENCY Kr.
> NLS_ISO_CURRENCY NORWAY
> NLS_NUMERIC_CHARACTERS ,.
> NLS_CALENDAR GREGORIAN
> NLS_DATE_FORMAT DD.MM.RRRR
> NLS_DATE_LANGUAGE NORWEGIAN
> NLS_SORT NORWEGIAN
> NLS_TIME_FORMAT HH24.MI.SSXFF
> NLS_TIMESTAMP_FORMAT DD.MM.RRRR HH24.MI.SSXFF
>
> PARAMETER VALUE
> ------------------------------
> ----------------------------------------
> NLS_TIME_TZ_FORMAT HH24.MI.SSXFF TZR
> NLS_TIMESTAMP_TZ_FORMAT DD.MM.RRRR HH24.MI.SSXFF TZR
> NLS_DUAL_CURRENCY Kr.
> NLS_COMP BINARY
> NLS_LENGTH_SEMANTICS BYTE
> NLS_NCHAR_CONV_EXCP FALSE
>
> The character settings on the server are the same as on the client.
>
> The settings on the database (I write select * from
> nls_database_parameters) are:
>
> PARAMETER VALUE
> ------------------------------ ----------------------------------
> NLS_LANGUAGE AMERICAN
> NLS_TERRITORY AMERICA
> NLS_CURRENCY $
> NLS_ISO_CURRENCY AMERICA
> NLS_NUMERIC_CHARACTERS .,
> NLS_CHARACTERSET WE8MSWIN1252
> NLS_CALENDAR GREGORIAN
> NLS_DATE_FORMAT DD-MON-RR
> NLS_DATE_LANGUAGE AMERICAN
> NLS_SORT BINARY
> NLS_TIME_FORMAT HH.MI.SSXFF AM
>
> PARAMETER VALUE
> ------------------------------ ----------------------------------
> NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
> NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
> NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
> NLS_DUAL_CURRENCY $
> NLS_COMP BINARY
> NLS_LENGTH_SEMANTICS BYTE
> NLS_NCHAR_CONV_EXCP FALSE
> NLS_NCHAR_CHARACTERSET AL16UTF16
> NLS_RDBMS_VERSION 9.0.1.1.1
>
> I used one of the database templates to make the database and used sql
> scripts provided by the program developers to generate the tables.
>
> I have tried the following:
>
> - I have changed the nls language settings both for the database and
> the client machine but nothing works. I used different combinations of
> these, but I admit that I did not really know what I was doing.
> - I shut the database down, changed compatible = 9.0.0 into compatible
> = 8.0.6 in the init.ora file
>
> Now I have tried everything I can think of, and I am quite confused.
> Can someone tell me what I should do?
>
> Thanks,
>
> Roar Renton.
Received on Thu May 02 2002 - 06:19:42 CDT
