Re: ORA-01722 and Oracle version problem?

Sorry. Yesterday we found out that there was an application problem, so now it is almost working. I think there was some sql that worked fine with Oracle 8 but not with Oracle 9i, but I really do not know what I'm talking about here.

Thanks anyway.

Regards

Roar Renton.

"Spark" <mark_at_nospam> wrote in message news:<3cd120ce$0$232$ed9e5944_at_reading.news.pipex.net>...
> 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 Fri May 03 2002 - 01:47:29 CDT