Forum Stats

  • 3,836,791 Users
  • 2,262,191 Discussions
  • 7,900,111 Comments

Discussions

Discoverer report is not working in users machine but it is working on mine

4f6becc4-afb3-49a3-abf4-33eaafd44cf5
edited May 29, 2019 8:30AM in Discoverer

Hi All,

Need help.

We have one report in Discoverer when we are running it in any machine it is working fine except Sweden user machine.

When we are running the report at Sweden machine we are receiving error -ORA 01722.

We checked the conversion of string to numeric but it is fine.

Thanks,

Purnachandu S

Answers

  • BluShadow
    BluShadow Member, Moderator Posts: 42,107 Red Diamond
    edited May 29, 2019 8:30AM
    4f6becc4-afb3-49a3-abf4-33eaafd44cf5 wrote:Hi All,Need help.We have one report in Discoverer when we are running it in any machine it is working fine except Sweden user machine.When we are running the report at Sweden machine we are receiving error -ORA 01722.We checked the conversion of string to numeric but it is fine.Thanks,Purnachandu S

    Well, obviously it's not, otherwise Oracle wouldn't complain.

    How is the conversion being done?  Is it considering local numeric formats?  or perhaps expecting a specific format that "looks fine" to yourself, but you don't realise that other countries use different formats?

    e.g. in the UK, we use a comma "," as the thousands separator and a period "." as the decimal separator.  In some other countries they are the other way around.