Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved PowerServer Oracle decimal separator

  1. How-to
0
Votes
Undo
  1. Olivier THEVENIOT
    Olivier THEVENIOT
  2. PowerServer 2020 or older (Obsolete)
  3. Thursday, 8 November 2018 16:24 PM UTC

Hello,

I have a problem between PowerServer Web and Oracle. The decimal values ​​are multiplied by 100. I suspect a decimal separator problem.

How can i define it ?

It works well in PowerBuilder.

Thank you

Olivier

  1. Oracle
  2. PowerServer Web
Plugin will not run/install
Issue with using a homegrown C# dll with the appeo...
Responses (2)
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Friday, 9 November 2018 02:39 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Olivier,

What's the Oracle database version you are using? and what’s the Oracle client
version you are using?

And please note that, for Oracle database, the NLS_LANG on the machine where
the Appeon server located at should be the same with the one on the database
server. So please go to the Register on the server where the Appeon server is
installed to check if the NLS_LANG in the directory:
HKEY_LOCAL_MACHINE>SOFTWARE>ORICAL( or
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE) is the same with the one in
database. Change it to make it be the same as the one on the server side if
they are different and restart IIS Server.

Regards,
ZhaoKai

Comment
Olivier THEVENIOT
  1. Olivier THEVENIOT
  2. Friday, 9 November 2018 10:19 AM UTC
Hi Zhao,

Thanks for your answer.

NLS_LANG was the same in Appeon server and in Oracle server.

And it works very well with PowerBuilder version started on Appeon server.

There are two parameters called 'Other Options' and 'Extended Options' in Data Source configuration of PowerServer. But i don't know how to fill them.

Regards,

Olivier

  1. Helpful
Gerardo Barquero
  1. Gerardo Barquero
  2. Tuesday, 10 September 2019 21:19 PM UTC
Hi Oliver!

Did you resolve this issue? I have the same problem :(



Gerardo
  1. Helpful
There are no comments made yet.
Ignacio De La Rosa
Ignacio De La Rosa Accepted Answer Pending Moderation
  1. Thursday, 6 August 2020 17:37 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

Hola Oliver, resolviste este problema, tengo el mismo problema que el tuyo...

saludos!

Ignacio.-

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.