Pro*C method 4 query using a SUM column
From: Andy <andy_spiller_at_hotmail.com>
Date: 14 Jun 2001 00:31:34 -0700
Message-ID: <34f949f3.0106132331.7b9aaaca_at_posting.google.com>
Date: 14 Jun 2001 00:31:34 -0700
Message-ID: <34f949f3.0106132331.7b9aaaca_at_posting.google.com>
Env: Oracle 8.0.6 on HP-UX11
I am trying to use a method 4 query containing a SUM column. The column being summed is defined as NUMBER(16,6). However, when describing the select-list for the query the column (SUM(NUMBER(16,6))) is being described as an INT rather than a FLOAT. i.e. although it is saying that the field is a NUMBER, the precision and scale are both 0.
Any ideas gratefully received. Received on Thu Jun 14 2001 - 09:31:34 CEST