ORA-01722 and Oracle version problem?

From: Roar Renton <roar.renton_at_lilleaker.com>
Date: 2 May 2002 04:07:57 -0700
Message-ID: <eacc310a.0205020307.54b1f838@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:07:57 CDT