different results procedure versus query analyser

Hi,

I use a 'sum/group by' query in a stored procedure to calculate some aggregated levels.

However, the results are slightly different from the EXACT SAME query run by hand in a query analyser window (same user).

The procedure stores some records of a certain table1 into a temporary table and directly uses a insert/select sum statement to add summed values to an other table2.

Directly selecting/summing these data from table1 by hand results in (some) different records.

The use of the temp table is for other purposes. I stripped the code as much as posible and replaced the temp table by a 'real' table and still get different results.

I use Oracle 10g XE on Win2K.

Does this sound familiar to anyone?
Many thanks,
Martijn Received on Tue May 30 2006 - 13:52:29 CDT