Number datatype help?

New to Oracle. How can I declare a variable NUMBER that can be assigned:

1. 654321.00
2. Not 654321.000
3. Not 7654321.00

?

I am trying this code, but I am getting precision errors. Any ideas? Is my understanding of precision and scale incorrect? I want a number that can be 6 digits and 2 decimal places. What am I missing here? Thanks!

--***********

SET SERVEROUTPUT ON
SET VERIFY OFF
DECLARE
   v_number NUMBER(6,2) := &sv_number;

BEGIN
    DBMS_OUTPUT.PUT_LINE(v_number);

END;
/

--************

Cheers,
~ck Received on Mon Nov 19 2007 - 11:26:46 CST