Re: Basic pl/sql question

 number(2,2);
the first number is total quantity of characters.

rate := 7.8 <- here is 3 characters "7" "." "8"

Serge Kosourikhin
Oracle DBA
JSC Bratsk Aluminium Plant

• Original Message ----- From: Nguyen, Long <Long.Nguyen_at_its.csiro.au> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, May 19, 2000 12:25 PM 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).
Received on Thu May 18 2000 - 22:29:16 CDT