Re^2: Wrong calculation result with data retrieved with DBD::Oracle view

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]

Comment on Re^2: Wrong calculation result with data retrieved with DBD::Oracle view Download Code

Replies are listed 'Best First'.
Re^3: Wrong calculation result with data retrieved with DBD::Oracle view by marto (Cardinal) on Dec 06, 2019 at 04:15 UTC
"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]
Re^4: Wrong calculation result with data retrieved with DBD::Oracle view by yusanity (Initiate) on Dec 06, 2019 at 07:08 UTC
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.	[reply]
Re^5: Wrong calculation result with data retrieved with DBD::Oracle view by marto (Cardinal) on Dec 06, 2019 at 08:04 UTC
Unless you can post an example which replicates the issue (it doesn't have to be your complete script, a short example is preferable) then there's not much anyone can advise. A link to How do I post a question effectively? is displayed each time you post. Update: Fixed typo, thanks pryrt.	[reply]
Re^5: Wrong calculation result with data retrieved with DBD::Oracle view by poj (Abbot) on Dec 06, 2019 at 08:03 UTC
where can i extract information which is useful What is the Operating System, version of Perl and version of Oracle on the OLD server ? What is the Operating System, version of Perl on the NEW server ? poj	[reply]