in reply to Wrong calculation result with data retrieved with DBD::Oracle view

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

  • Comment on Re: Wrong calculation result with data retrieved with DBD::Oracle view

Replies are listed 'Best First'.
Re^2: Wrong calculation result with data retrieved with DBD::Oracle view
by stevieb (Canon) on Dec 05, 2019 at 16:15 UTC

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

Re^2: Wrong calculation result with data retrieved with DBD::Oracle view
by yusanity (Initiate) on Dec 06, 2019 at 03:34 UTC

    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)

      "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.

        im using oracle 12C, the problem is the code are too complex, i am not sure where to snippet the code.

        im quite lose actually. Will like to seek advice on the troubleshooting steps or where can i extract information which is useful to the guru here.