yusanity has asked for the wisdom of the Perl Monks concerning the following question:

Hi, want to check with you guys anyone encountered intermediate issue of wrong calculation with data retrieved with DBD::Oracle view?

My setup is as followings:-

Update: 6 Dec 2019 by footpad: Added rudimentary HTML tags for clarity.
  • Comment on Wrong calculation result with data retrieved with DBD::Oracle view

Replies are listed 'Best First'.
Re: Wrong calculation result with data retrieved with DBD::Oracle view
by marto (Cardinal) on Dec 05, 2019 at 07:57 UTC

    Post an short example which replicates the issue, along with your input data, the output and your expected output.

[reply]

      ...within <code></code> tags.

[reply]
[d/l]

      Hi i am unable to replicate the issue, it will randomly appear in my output. Because i am using doing a parallel run , my old server is definately having the correct result.

      Please let me know what more information i could provide.

      Migrated new server environment perl modules installed 

      1. DBI-1.642.tar.gz (https://metacpan.org/release/TIMB/DBI-1.642)


2. DBD-Oracle-1.76.tar.gz (https://metacpan.org/release/DBD-Oracle)

3. libnet-3.11.tar.gz (https://metacpan.org/release/SHAY/libnet-3.11)

4. Mail-Sendmail-0.80.tar.gz (https://metacpan.org/release/NEILB/Mail-
+Sendmail-0.80)

5. Time-Local-1.28.tar.gz (https://metacpan.org/release/DROLSKY/Time-L
+ocal-1.28)

6. Test-Inter-1.07.tar.gz (https://metacpan.org/release/Test-Inter)

6. Date-Manip-6.73.tar.gz (https://metacpan.org/release/SBECK/Date-Man
+ip-6.73)

7. Carp-Clan-6.06.tar.gz (http://search.cpan.org/~kentnl/Carp-Clan-6.0
+6/)

8. Storable-3.05_17.tar.gz (https://metacpan.org/release/RURBAN/Storab
+le-3.05_17)

9. Bit-Vector-7.4.tar.gz (http://search.cpan.org/~stbey/Bit-Vector-7.4
+/)

10. Date-Calc-6.4.tar.gz (http://search.cpan.org/~stbey/Date-Calc-6.4/
+)

11. Data-Dumper-2.173.tar.gz (https://metacpan.org/release/XSAWYERX/Da
+ta-Dumper-2.173)

      [download]
[reply]
[d/l]

        "Please let me know what more information i could provide"

        I asked you to show the code you're actually running. Also which version(s) of Oracle you're running.

[reply]

Back to Seekers of Perl Wisdom