RE: Basic pl/sql question

" number(2,2)" is a two digit number with both digits to the right of the decimal point. You cannot store 7.8 in a variable declared as number(2,2).

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu  

-----Original Message-----
From: Nguyen, Long [mailto:Long.Nguyen_at_its.csiro.au] Sent: Thursday, May 18, 2000 8:25 PM
To: Multiple recipients of list ORACLE-L Subject: Basic pl/sql question

Hi,

I have got the very simple pl/sql pgm below:

  1 create or replace procedure atest
  2 as
  3 rate number(2,2);
  4 begin
  5 rate := 7.8 ;
  6* end;

When I executed this procedure I got the following error

ERROR at line 1:

ORA-06502: PL/SQL: numeric or value error: number precision too large
ORA-06512: at "NGU059.ATEST", line 5
ORA-06512: at line 1

Why?

If I changed declaration of variable rate to number(3,2) the procedure is executed ok. Why?

Thanks.

-- 
Author: Nguyen, Long
  INET: Long.Nguyen_at_its.csiro.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).