PL/SQL BLOCKS OR STORED PROCEDURES GENERATING INCORRECT RESULT (Doc ID 275250.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 9.2.0.4 - Release: 8.1.7 to 9.2
Information in this document applies to any platform.

Symptoms

Incorrect results ONLY occurs when PL/SQL code or Procedure is used to gather sum(tot) between two dates.
The normal select query to find the sum(tot) between two dates ALWAYS returns correct results.
All the partitioned Tables are analyzed with compute statistics

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms