Wrong calculation result with data retrieved with DBD::Oracle view

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:-

DBI-1.642.tar.gz (https://metacpan.org/release/TIMB/DBI-1.642)
DBD-Oracle-1.76.tar.gz (https://metacpan.org/release/DBD-Oracle)
libnet-3.11.tar.gz (https://metacpan.org/release/SHAY/libnet-3.11)
Mail-Sendmail-0.80.tar.gz (https://metacpan.org/release/NEILB/Mail-Sendmail-0.80)
Time-Local-1.28.tar.gz (https://metacpan.org/release/DROLSKY/Time-Local-1.28)
Test-Inter-1.07.tar.gz (https://metacpan.org/release/Test-Inter)
Date-Manip-6.73.tar.gz (https://metacpan.org/release/SBECK/Date-Manip-6.73)
Carp-Clan-6.06.tar.gz (http://search.cpan.org/~kentnl/Carp-Clan-6.06/)
Storable-3.05_17.tar.gz (https://metacpan.org/release/RURBAN/Storable-3.05_17)
Bit-Vector-7.4.tar.gz (http://search.cpan.org/~stbey/Bit-Vector-7.4/)
Date-Calc-6.4.tar.gz (http://search.cpan.org/~stbey/Date-Calc-6.4/)
Data-Dumper-2.173.tar.gz (https://metacpan.org/release/XSAWYERX/Data-Dumper-2.173)

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]
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.	[reply] [d/l]
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) [download]	[reply] [d/l]
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
Re^5: Wrong calculation result with data retrieved with DBD::Oracle view by marto (Cardinal) on Dec 06, 2019 at 08:04 UTC
Re^5: Wrong calculation result with data retrieved with DBD::Oracle view by poj (Abbot) on Dec 06, 2019 at 08:03 UTC


The stupid question is the question not asked
	PerlMonks