Decimal data stored in NUMBER(10)

From: <suisum_at_freenet.edmonton.ab.ca>
Date: 23 Sep 1998 16:00:53 GMT
Message-ID: <6ub5vl$ghi$1@news.sas.ab.ca>

Hi:

I have a problme table. It has a field defined as NUMBER(10). But it stored with a number (with decimal) in it. When I user SQL/Plus to view the value, it shows the decimals of the value. But when I created a stored procedure, the value returned form the cursor didn't contain the decimal. I believe it rounded up the number to form a whole number. How can I get the decimal back in stored procedure?

I have tried:

v_number NUMBER(10, 3);

   v_number := my_cur.number_value; 
   v_number := TO_NUMBER (my_cur.number_value, '9999999.999');
   v_number := TO_NUMBER(TO_CHAR(my_cur.number_value, '9999999.999'));

But nothing successful. Please help.

--
Best regards, Received on Wed Sep 23 1998 - 11:00:53 CDT