Re: Decimal data stored in NUMBER(10)

Hi:

Please ignore this message. I have found the solution. That is NOT to use implicit fetch. After I used explicite fetch and define the NUMBER(10, 3) as the variable. It worked perfectly.

Best regards,

suisum_at_freenet.edmonton.ab.ca wrote:
: 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,

--
Best regards, Received on Wed Sep 23 1998 - 13:29:02 CDT